Print Analysis of Payer Credit Limits

Outcome

A report is printed, based on user-defined selection criteria. The actual values are retrieved from the accounts receivable file (FSLEDG).

The report lists each payer with information on the total unpaid invoice amount, credit limit 1 (for invoices past due) or credit limit 2 (for outstanding invoices). The relation between these values is expressed as an index. Index 1.0 indicates that the maximum credit limit is used; any value above 1.0 indicates that the payer has exceeded the credit limit.

Note that the report does not include credit limit 3 (for outstanding invoices and customer orders).

Use the credit limit index to review the payer's credit status and as a basis for deciding what action to take. These are the :

• Retrieving further information by monitoring the payer credit and general payment behavior in 'Credit Monitoring. Process' (RMS420)
• Contacting the payer
• Prioritizing open invoices in the payment reminder and debt collection routines in 'Payment Reminder. Open' (ARS650) and 'Collection. Open Assignment' (ARS170) respectively
• Redefining credit limits in 'Customer. Open' (CRS610/J)
• Blocking the payer from further order processing in (CRS610/J).

Before you start

Before you start, you must meet these prerequisites:

• You must meet the starting conditions listed in Managing Customer Credit.
• You must define the credit limits 1 and 2 for the payer/customer in 'Customer. Open' (CRS610/J).

Follow these steps

1. Start 'Credit Limit. Print Analysis' (ARS525).

2. Optionally, on the E panel, specify the accounting date up to and including which the analysis should cover.

3. Optionally, specify any of the following ranges: The person responsible for sales to a customer/payer, customer group to which the payers to be selected belong, payer district, and payer.

4. Optionally, specify the sorting order and if page breaks are used, and whether totals is printed at line breaks.

   You can specify this information for any of the ranges above.

5. Specify a report layout with these options:

   • 1=All payers, with or without defined credit limits
   • 2=Payers with a defined credit limit 1
   • 3=Payers with a defined credit limit 2
   • 4=Payers past the defined credit limit 1
   • 5=Payers past the defined credit limit 2

6. Specify a report text to print on the report. Press Enter.

   The list is printed. These columns are included: Payer, name, amount past due, currency amount (if the payer is registered with another currency than the division's), credit limit 1, index, total claim (past due + outstanding amount), currency amount, credit limit 2, and index. Any VAT is excluded.