Related topics
The entries in this table are used in the Print A/R – A/P analysis and Work with A/R – A/P analysis reports routines. Here you can create templates or maintain already existing templates to use when you order printouts of A/R and A/P analysis lists or when you create an on-line report. This means that you can create templates with frequently used sequences and selections. You can, however, change any information defaulted by the template for the printouts.
Options
Selection fields
- Template
- This column lists the existing templates.
A/R & A/P analysis list/report, Sequences template maintenance (FSR55801)
The entries in this table are used in the Print A/R – A/P analysis and Work with A/R – A/P analysis reports routines. Here you can create templates or maintain already existing templates to use when you order printouts of A/R and A/P analysis lists or when you create an on-line report. This means that you can create templates with frequently used sequences and selections.
- Template
- Note: This field cannot be changed when you maintain an already existing template.
- Description
Heading
- Sub-total
- Note: This field must be YES if sub-totals are selected on detail level when you are creating a report on-line.
- Page break
Detail
Note: When you create a report on-line it is only possible to select a maximum of 4 sequences.
- Sub-total
- Note: If you define sub-totals for more than one sequence when you create a report on-line, then you must make sure that the level above it is also set to YES, i.e. if sub-total sequence 4 is YES, then the sub-total parameters 3, 2 and 1 must also be YES.
- Page break
A/R & A/P analysis list/report, Specifications template maintenance (FSR55802)
Specification
In the fields below you specify the type of list/report you want to be printed.
Sub-totals and details are printed in the currency that you select on this panel. Totals are always printed in system currency for the currency that you select, except when you select reporting currency, where sub-totals and details are printed in reporting currency and totals are printed in both reporting and system currency.
- A/R list
- Indicate if you want to print an A/R list.
- A/P list
- Indicate if you want to print an A/P list.
- Debtor/Supplier info
- Indicate if you want to print debtor/supplier address information.
- Details
- Indicate if you want to print a line for each individual document.
- Amount collation seq
- Only used for the Work with A/R – A/P analysis reports routines. Enter the code for ASCENDING or DESCENDING to sort the sub-total amounts. If you enter the code for ASCENDING, then the sub-totals for A/R documents will be displayed with the highest negative amount first and for A/P documents with the lowest positive amount first. The sort order will be reversed when you enter the code for DESCENDING. If the field is left blank, then the amounts will be sorted in sequence order. You can change this field when you view a report on-line.
- A/D
- Displays the language code for ascending and descending.
- Transaction currency
- Indicate if you want transaction currency amounts to be printed for sub-totals and details.
- Primary currency
- Indicate if you want primary currency amounts to be printed for sub-totals and details.
- System currency
- Indicate if you want system currency amounts to be printed.
- Reporting currency
- Indicate if you want reporting currency amounts to be printed in sub-totals, details and totals. Note: System currency amounts and reporting currency amounts cannot be printed on the same list. They are mutually exclusive.
- Ageing date
- Enter a code to define the date to which you want to base your ageing date.
- Min remaining amount
- Enter an amount if you want to limit the number of open items to be included in the analysis list. Minimum remaining amount is an absolute value, i.e. both positive and negative amounts are taken into consideration. E.g. if you enter 1000, documents with system currency amounts 1000 and more are included, as well as documents with system currency amounts -1000 and less.
- Past due date only
- Indicate if you only want to include all documents or only those that are past due as of today.
- Credit limit
- Set to YES if only debtors that have exceeded their credit limit, i.e. the A/R balance is greater than the credit limit, should be included in the list/report. This means that you can set to YES if you have selected an A/R list and the Debtor/Supplier no or Internal name field on the previous panel is sequence number 1.
The credit limit will be printed/displayed in the header with extended debtor information, in reporting or system currency. If you set the transaction, primary or system currency to YES on this panel, the credit limit will be printed in system currency. If you set the reporting currency to YES on this panel, then the credit limit will be printed in reporting currency.
- Balance period
- Enter the balance period for the documents you want to include. Documents that were entered in later accounting periods are then excluded. Actual period is used as default value. If you leave the field blank, all open items will be included.
- Report description
- Only used for the Work with A/R – A/P analysis report routine. Enter a description for the report.
- Date intervals
- The printout will report amounts entered/due as per six dates, as well as the amounts entered/due after the last date. Today’s date will be proposed as starting date, with a seven day range forward in time. If you want other dates or ranges, you can either complete the six dates yourself, or state a new ending or starting date and a different day interval.
For a new starting date for calculation ahead in time, you enter the date in the leftmost field, enter a positive number in the Interval. For a new starting date for calculation back in time, you enter the date in the rightmost field, enter a negative number in the Interval. When you click OK, new dates are calculated.
- Interval
- Enter the number of days for the date range. For calculation ahead in time, you state the value with a positive number (e.g. 8), then enter the starting date in Date 1. For calculation back in time, you state the value followed by a minus symbol (e.g. 10-). You indicate the ending date in Date 6. Note: If you enter the value 99 or 99- as interval in the template, then the End date value defined for the actual period in the G/L control file is defaulted to each Date field.
If the ARAPCSEQ (A/R – A/P report column sequence) function is active in the Function control file, then you can select to print the A/R and A/P analysis lists in either ascending or descending date interval sequence.
A/R & A/P analysis list/report, Selections template maintenance (FSR55803)
On this panel you make the selections for the template for printout of the A/R and/or A/P analysis list or on-line report.
Selection
- Debtor number
- Debtor internal name
- Supplier number
- Supplier internal name
- A/R group
- A/P group
- Category 1
- Category 2
- Category 3
- Area
- Main salesman/Handl
- Transaction currency
- Document type
- Cost centre
- Division
- Credit profile
A/R & A/P analysis list/report, Printer data template maintenance (FSR55804)