When you set up your analysis templates the procedure is the same for both A/R and A/P analysis lists and reports.
To create a template for A/P analysis, do as follows:
- Select the Work with A/R – A/P analysis reports menu item.
- On the main panel, click Add to create a new report.
- On the A/R & A/P analysis report, Sequences panel, click Template to create a new template.
- You access A/R & A/P analysis list/report, Template selection. Click Maintain templates, and then Add to create a new template.
- You access A/R & A/P analysis list/report, Sequences template maintenance. Complete the following fields:
- Template
- Enter the name of the template you are creating.
- Description
- Enter a description of the new template.
- Heading
- Enter your sequences for the heading level. Note: Sub-total must be set to YES if sub-totals are selected on the detail level when you create a report on-line.
- Detail
- Enter your sequences for the detail level. Note: For a report on-line it is only possible to select a maximum of 4 sequences.
- Sub-totals
- Here, set to YES for sub-totals for all the selected sequences, i.e. 4 levels, so that the report will include four levels to drill down through.
- Note: If you define sub-totals for more than one sequence when you create a report on-line, you must make sure that the level above 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.
- You access A/R & A/P analysis list/report, Specifications template maintenance. The following fields are relevant:
- A/R, A/P list
- Set A/R or A/P report to YES, or both.
- Details
- Indicate if you want to display a line for each individual document. Here, set to NO.
- Amount collation seq
- Enter the code for ASCENDING or DESCENDING for sub-total amounts. If you enter the code for ASCENDING 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 the amounts will be sorted in sequence order.
- Currencies
- Set Reporting currency and one more currency to YES, to be able to toggle between currencies in the report. System currency and Reporting currency are mutually exclusive.
- Report description
- 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 (Date 1), 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.
The ARAPCSEQ (A/R-A/P report col sequence) function in the Function control file controls if the list should be printed in either ascending or descending date interval sequence. If that function is not activated, the date interval sequence will be printed in ascending order. If that function is activated, the date interval sequence will be printed in descending order.
Completion of these date fields works as follows:
If the ARAPCSEQ function is not activated
For a new starting date for calculation ahead in time, you enter the date in the leftmost field (i.e. Date 1) and enter a positive number in Interval.For a new starting date for calculation back in time, you enter the date in the rightmost field (i.e. Date 6) and enter a negative number in Interval. When you click OK, new dates are calculated.
If ARAPCSEQ is activated
For a new starting date for calculation back in time, you enter the date in the leftmost field (i.e. Date 1) and enter a positive number in Interval.For a new starting date for calculation ahead in time, you enter the date in the rightmost field (i.e. Date 6) and enter a negative number in Interval. When you click OK, new dates are calculated.
- Interval
- Completion of this field works as follows:
If the ARAPCSEQ function is not activated
Enter the number of days for the date range.For calculation ahead in time, you state the value with a positive number only (e.g. 8), then enter the starting date in the leftmost field (i.e. Date 1).
For calculation back in time, you state the value followed by a minus sign (for example, 10-). You indicate the ending date in the rightmost field (i.e. Date 6).
If the ARAPCSEQ function is activated
Enter the number of days for the date range.For calculation ahead in time, you state the value followed by a minus symbol (e.g. 10-). You indicate the ending date in the rightmost field (i.e. Date 6).
For calculation back in time, you state the value with a positive number only (e.g., 8), then enter the starting date in the leftmost field (i.e. Date 1). When you click OK, new dates are calculated. Note: If you enter the value 999 or 999- as interval, then the End date value defined for the actual period in the G/L control file is defaulted to each Date field.
- You access A/R & A/P analysis list/report, Selections template maintenance. On this panel you make your selections for the template, for example, debtor/supplier number, transaction currency and document type. Click OK when you have made your selections.
- You will access A/R & A/P analysis list/report, Printer data template maintenance, which is used for the Print A/R – A/P analysis list routine.
- You return to A/R & A/P analysis list/report, Sequences template maintenance where you can create a new template, or exit the routine.
There are two sequence levels, heading sequence and detail sequence, in which you can determine the print order of the list. You are able to combine the sequences in whichever order you want the documents to be printed.
Click OK.
Click OK.
Click OK and exit the template routine.