1. Home
  2. /
  3. Panel Help
  4. /
  5. Financials
  6. /
  7. A/R balance list printout,...

A/R balance list printout, Sequences (FKR03901)

Related topics

Note: Template handling is implemented in this program. You must select a template. The last used template, including the sequences and specifications defined for it, is defaulted, but these can be changed. If a template has not previously been selected, then the SYSTEM template is defaulted. Use the available function keys to create a new or maintain an existing template.

In this program you order printout of A/R balances. The main purpose of printing the balance list is to show the open amounts (balances) that remain for each document within your selection. By request, all the documents that settle the balance list documents can also be printed as detail information.

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 (*).

Function keys

Template
Select the template you want to use for the printout. The last used template is defaulted.

Sequence

Sub-total
Page break

A/R balance list printout, Selection (FKR03902)

Related topics

On this panel you make the selection for the documents on the A/R balance list. Note: The active template is indicated in the header. You can, however, change any information defaulted by the selected template.

Function keys


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

A/R balance list printout, Specifications (FKR03903)

Related topics

On this panel you make specifications for the documents on the A/R balance list. Note: The active template is indicated in the header. You can, however, change any information defaulted by the selected template.

Function keys


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.

A/R balance list printout (FKR03904)

Related topics

On this panel you set the printout parameters for the list.

Function keys

Save as template (FKR03914)

Related topics

In this pop-up window you can save the made selections and sequences, that you are currently working with, in a new or an existing template.

Template
The system will automatically retrieve the ID of the template you are currently using. You can change the name to a new one, or use the name of an existing template. Note: Changing template will override the made selections and sequences of the old template with the new ones.
Description
For existing templates, the current description is suggested. This description may be changed. Note: The defaulted description is the description entered when the template was created, even if a translated description exists.