You use this program to produce a list of selected customers against whom specific credit control action is required.
Field | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Report as of | The 'as of' date is taken from the Ageing
date entered on the Ageing Options
tab.
|
||||||||||
Report type |
|
||||||||||
Sequence | Indicate the sequence in which to generate the
report. The following sequences are available:
|
||||||||||
Branch selection by | This option is enabled when you select to generate the
report in Branch sequence and
the Report type is Include
transaction detail.
|
||||||||||
Print options | |||||||||||
Print full address | Select this to include each customer's full address on the report. | ||||||||||
Print all customer detail | Select this to include details defined against each customer (AR Customer Maintenance) in the report. |
Field | Description |
---|---|
Customer selection | Indicate the customer(s) for which you want to generate the report. |
Branch selection | Indicate the branch(es) for which you want to include customers in the report. |
Customer class selection | Indicate the customer class(es) for which you want to include customers in the report. |
Salesperson selection | Indicate the salesperson(s) for which you want to include customers in the report. |
Geographic area selection | Indicate the geographic area(s) for which you want to include customers in the report. |
Field | Description |
---|---|
Ageing options | These options enable you to 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 Payable 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 Payable Setup program. Invoices are aged according to how you have defined your invoice ageing method (Accounts Receivable Setup - General tab) |
Use standard ageing columns | Select this to 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 | You use these fields to 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 -
General tab), 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. |
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, and are accessible on the Periods tab of the Accounts Receivable Setup program. 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 |
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, and are accessible on the Periods tab of the Accounts Receivable Setup program. 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 |
Select this to aged invoices according to the difference between the invoice date and the system run date as follows:
|
Invoice due date |
Select this to 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 will remain current provided that the due date is greater than the ageing date. 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 (AR Customer Maintenance - Basic tab). |
The options on this tab page only apply if you selected the setup option Foreign currency sales required (Accounts Receivable Setup - General tab). |
Field | Description | ||||||
---|---|---|---|---|---|---|---|
Show values in | This option enables you to indicate the currency in
which you want 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 you want to print transactions. This option 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 |
|
||||||||||||
Customer account selection |
|
||||||||||||
Limit checking | This option is only available if you defined Customer selection by Limit checking or by Limit and terms checking. | ||||||||||||
Over limit by | Indicate the amount by which customers must have exceeded their credit limit for them to be included in the report. | ||||||||||||
Minimum balance checking | This option is only available if you defined Customer selection by Minimum balance checking. | ||||||||||||
Balance | This indicates the minimum balance. If a customer's balance exceeds this amount, then that customer is included in the report. | ||||||||||||
Terms selection |
|
||||||||||||
Terms | This indicates the single terms code for which you want to include customers in the report. | ||||||||||||
Terms checking | This option is only available if you defined Customer selection 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 |
You can only access this field if you selected either the Terms checking or Limit and terms checking options at the Customer selection by field. This enables you to 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). |
These options enable you to indicate additional criteria according to which customers are selected and additional information that you may want to include on the report.
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Credit narrations selection |
|
||||||||
Follow-up date selection | Indicate the customers to include in the report based on the follow-up date. | ||||||||
Customer on hold selection |
|
||||||||
Include | |||||||||
Zero balance customers |
Select this to include customers whose balance is zero for the month you selected to generate the report.
|
||||||||
Future invoices |
Select this to include future invoices in the report. 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 current invoices | Select this to include zero balance invoices that became zero in or before the month you selected to generate the report. | ||||||||
Post dated checks | Select this to include post dated checks in the report. | ||||||||
Retained invoices |
Select this to include retained invoices in the report. Retained invoice are zero value invoices which have been retained for more than one month. |
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).
The total in brackets ( ) indicates the average number of days that invoices are overdue for the customer. This is calculated as: the sum of the days overdue for each of the customer's invoices, divided by the number of invoices that are overdue.
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).
The following error messages could be displayed:
Invoice balance error
This indicates that the total invoice transactions printed for the customer does NOT equal the customer balance held on file.
This can be caused when there was a system problem when posting the transaction (e.g. a power failure or a technical problem) and the transaction was posted but the customer balance was not updated or vice-versa.
You need to run the Balance function of the AR Period End program to correct this. The AR Period End balance function accumulates the transaction values and changes the customer balance to match the total of the transactions.
Alternatively, the report was printed by branch and a customer has transactions allocated to more than one branch. The customer is repeated for each branch with the applicable transactions for each branch, but the balance held for the customer on file is the total for all the branches, therefore the total calculated at branch level is different to that held on file.
Customer branch balance variance
This only applies if the report is generated in Branch sequence and the Branch selection by option is set to Invoice. It indicates that the customer balance does not equal the total of the invoices for that branch.