Related topics
The entries in this program are used in the Print A/R balances routine. Here you can create templates or maintain already existing templates to use when you order a printout of A/R balance lists. This means that you can create templates with frequently used sequences and selections.
The balances can be sequenced, grouped and summarised on up to 15 levels, based on the selections on the sequence panel. The sequence selections refer to information to be found on both transaction and debtor level. The heading sequences group refer to information on debtor level and the detail sequences group refer to information on transaction level.
The order in which the selected documents should be listed on the printout is defined by assigning sequence numbers to the sequence parameters. The sequence numbers must form a consecutive array beginning with 1.
On sequences you have the option to order sub-total printing, page break and end total printing. Sometimes an amount cannot be printed on the list because of too little horizontal space. The field for amount will then be completed with an asterisk (*).
Options
Selection fields
- Template
- This column lists the templates that have been defined in your system.
Work with templates, A/R balance list, Copy (FKR13905)
- Template
- Displays the template(s) you selected to copy.
- New templ
- Enter a code or name to identify the new template you are creating.
Work with templates, A/R balance list, Deletion (FKR13908)
Work with templates, A/R balance list (FKR13911)
On this panel you add or maintain templates for your A/R balance list printouts. This is the first of three panels where you can make your selections and define your sequences. On this panel you define how you want the information to be sequenced. Scroll to access the Selection and Specification panels.
Function keys
- Template
- For existing records, this field cannot be changed.
Sequence
- Sub-total
- Page break
Work with templates, A/R balance list (FKR13912)
On this panel you make the selections that should be included when you order a printout of A/R balances using the current template. Scroll to enter further specifications for the printout.
Function keys
- Template
- Displays the active template and its description.
Selection
- Debtor number
- Debtor internal name
- A/R group
- Category 1
- Category 2
- Category 3
- Area
- Transaction currency
- Document type
- Cost centre
- Division
Note: Cost centre and Division cannot be printed on the same list. They are mutually exclusive. - Main salesman/Handl
- Credit profile
Work with templates, A/R balance list (FKR13913)
On this panel you further specify the entries that should be included in the list printout from the current template.
Function keys
- Template
- Displays the active template and its description.
Specification
In the fields below you specify the type of list you want to have printed. Sub-totals and details are printed in the currency that you select on this panel.
- Standard
- Indicate if you want to print the standard list containing all documents for the accounting period entered, independent of whether they were settled in that period or not, as well as open items from previous periods.
- All transactions
- Indicate if you want to print a list with all transactions including all entered documents up to and including the stated period, open and settled.
- Open items
- Indicate if you want to print an open items list containing all open items up to and including the selected period.
- Debtor information
- Indicate if you want to print a header with extended debtor information. The debtor information will be printed if sub-totals have been selected for Debtor number or Internal name on the sequence panel. It will also be printed if one of these fields has been sequenced and either Details or Sub-totals has been entered for a higher level sequence.
- Details
- Indicate if detailed information for all selected documents is to be printed according to the list type you have selected. If you set to NO, only totals will be printed. If you set this field to YES, all documents that settle the balance document, up to and including the entered accounting period, will be printed for each selected balance document.
- Negative balance
- Indicate if only debtors with a total negative balance should be printed. Set to NO to include all debtors. You may only set to YES, if Details has been set to NO and at least one sub-total has been selected. When you set this field to YES, only the balance sub-totals which have negative values in system/reporting currency, on the highest sequence sub-total level, will be printed.
- System currency
- Indicate if you want the system amount balance presented on the list to be printed in system currency.
- Reporting currency
- Indicate if you want the system amount balance presented on the list to be recalculated into reporting currency.
Note: The system currency amounts and reporting currency amounts cannot be printed on the same list. They are mutually exclusive.
- Balance period
- Enter the period up to and including which documents are to be selected. The period is an accounting period for which the balance list is created.
- Temporary interrupt
- Set to YES if documents from temporary interrupted batches should be included in the selection. This concerns both documents created in an open batch as well as settlements that were created in a batch which has not yet been closed.
Set to NO if only updated documents should be included. If any settlements have been made against a document, but they still reside in a temporary interrupted batch, the settled amount will be presented as open for that document on the list.
Work with templates, A/R balance list (FKR13914)
On this panel you set the printout parameters for the list.
Function keys
- Template
- Displays the active template and its description.