You use this program to print a list of customers, reflecting the balance of each ageing column. The report is a summarized version of the Credit Management report.
The report ignores customers against whom no invoices are attached (i.e. sub-account customers where the invoices and balances are held against the master account customer).
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Report as of | The 'as of' date is taken from the Ageing
date entered on the Ageing
Options tab.
|
||||||||
Sequence | Indicate one of the following sequences in which to
generate the report.
|
||||||||
Customers on hold |
|
||||||||
Include | |||||||||
Include future invoice totals |
Select this to include the totals of future invoices in the report. This option is selected by default. Future invoices are those with an invoice date ahead of the ageing date you entered for the report, but which were posted in the current or a previous month. |
||||||||
Zero balance customers | Select this to include those customers whose account
balance is zero in the report. You must select this option to balance the MTD activity value, at company or branch level, to the MTD values displayed by the AR Company Control Balances program. See Coding considerations in Notes and warnings |
||||||||
Print full address | Select this to include each customer's full address on the report. | ||||||||
Print customer details | Select this to include details defined against each customer (Customers) in the report. |
Field | Description |
---|---|
Ageing options | Indicate how you want the ageing columns to be represented on the report. |
Ageing date |
Enter the date to use to calculate the time bucket allotted to each invoice printed. Regardless of the month selected to print, the entry made at this field is used to calculate the time buckets. If you selected Report as of - Current period on the Report Options tab, then this field defaults to the current SYSPRO system date. If you selected Report as of - Previous period 1 on the Report Options tab, then this field defaults to your Current year previous period 1 date from the Periods tab of the Accounts Receivable Setup program. If you selected Report as of - Previous period 2 on the Report Options tab, then this field defaults to your Current year previous period 2 date from the Periods tab of the Accounts Receivable Setup program. Invoices are aged according to the Invoice ageing method defined (Accounts Receivable Setup) |
Use standard ageing columns | Use the standard ageing columns. If you do not select this
option, then you can define the number of days to use for each
ageing column. The standard ageing columns are: Current, 30 days, 60 days, 90 days, 120 day and 150 days+. |
Column 1 - 5 | Enter the number of days to use for each ageing column. These fields are only enabled if you did not select to use standard ageing columns. |
Report ageing method | If your Invoice ageing method is
By statement (Accounts Receivable Setup) and your ageing
buckets are defined as 30 days each, then the maximum age of
invoices calculated by the system is 210. If it is By
aged statement, then the maximum age of invoices
calculated by the system is 180. Refer to Invoice Ageing for information on Accounts Receivable invoice ageing. See also: Notes and warnings. |
Statement | Select this to age invoices according to the last seven period end dates defined for your Accounts Receivable module. These dates were defined at the time of adding a company (Accounts Receivable Setup). The invoice date is used for ageing. An invoice is current if the invoice date is later than the last period end date. |
Aged statement | Age invoices according to the last seven period end dates defined for your Accounts Receivable module. These dates were defined at the time of adding a company (Accounts Receivable Setup). The invoice date is used for ageing. An invoice is current if the invoice date is later than the penultimate period end date. |
Invoice date |
Age invoices according to the difference between the invoice date and the system run date. For 30 day ageing buckets, the ages would be:
|
Invoice due date |
Age invoices according to the due date of the invoice. This is calculated as the invoice date plus the days until due as indicated in the Invoice Terms table. The invoice remains current providing the due date is greater than the ageing date. For 30 day ageing buckets, overdue invoices are aged into the following columns:
Due date ageing does not affect the handling of future invoices. If you select to age the report By invoice due date, then the date and terms defined against the invoice are used to age the invoice. The terms defined against the customer are ignored (Customers). |
These options only apply when the Foreign currency sales required option is enabled (Accounts Receivable Setup)
Field | Description | ||||||
---|---|---|---|---|---|---|---|
Show values in | Indicate the currency in which to print invoice amounts on
the report.
|
||||||
Convert to local value at | These options are only available if you selected
Local currency at the Show values
in option.
|
||||||
Currency selection |
|
||||||
Currency |
Indicate the single currency for which to print transactions. This option only applies if you selected to print transactions for a Single currency, or you selected to Show values in - Foreign currency. |
These options enable you to include customers in the report based on the method of credit checking indicated.
Field | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Customer selection by |
|
||||||||||||
Limit checking | This only applies when Customer selection is by Limit checking or by Limit and terms checking. | ||||||||||||
Amount over limit / Over limit by | Indicate the amount by which customers must have exceeded their credit limit for them to be included in the report. | ||||||||||||
Terms checking | This only applies when Customer selection is by Terms checking or by Limit and terms checking. | ||||||||||||
Based on |
|
||||||||||||
Days over terms | Enter the number of days to use to determine whether
customers have exceeded their terms. This applies if you selected the option: Actual days overdue. |
||||||||||||
Include where credit not available |
Include customers who are in a credit status of 9 (i.e. a manual hold has been placed on the account to suspend all credit for the customer). This option only applies when Customer selection is by Terms checking or by Limit and terms checking. |
||||||||||||
Minimum balance checking | This option only applies when Customer selection is by Minimum balance checking. | ||||||||||||
Balance | Indicate the minimum balance. If a customer's balance exceeds this amount, then the customer is included in the report. | ||||||||||||
Customer account selection |
|
||||||||||||
Terms selection |
|
||||||||||||
Terms | Indicate the single terms code for which to include customers in the report. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
To balance the Summary Credit Management and Credit Management reports when you have Future invoices, you need to either select the Include future invoice totals option in the Summary Credit Management report and select the Future invoices option in the Credit Management report or deselect these options in both reports.
Zero balance customers
Zero balance customers are always included in the report when Future invoices exist against them. This is irrespective of whether you selected to include Future invoices and/or Zero balance customers.
If you have foreign currency customers and you do not include zero balance customers, then the ageing totals on the report may not agree with the control balance totals.
This happens when a foreign currency customer's balance is zero in the foreign currency, but non-zero in the local currency (e.g. there is an invoice and credit note for the same foreign value, but the exchange rates differ and they have not been offset against each other).
If you are using the Number of days fixed terms code (AR Invoice Terms) and you defined your own ageing buckets, then you need to customize the report to display the headings you defined in the AR Terms Ageing Headings program for the customer totals. The AR heading elements are available in the schema and may be used to customize the report.