Configure Credit Monitoring

This settings document explains how to set the rules regulating how information is retrieved and calculated to support credit monitoring of customers.

Outcome

Rules for selecting transactions and payers to be monitored are defined. The rules can be reviewed in ‘Settings – Credit Monitoring’ (RMS905).

The rules are automatically applied when selecting transactions to be included in the credit monitoring routine in ‘Credit Monitoring. Create Transactions’ (RMS410). The rules control which values will be retrieved from the accounts receivable file (FSLEDG), the accounts receivable balance file (FSLBAL), and the customer master file (OCUSMA).

The information retrieved is used for credit monitoring purposes, to analyze a customer’s solidity and to adjust the customer’s credit limit. It can also be used to identify invoices for reminding a customer about past due invoices.

The values are displayed in the following programs:

  • ‘Credit Monitoring. Process’ (RMS420) with subprograms
  • ‘Credit Monitoring. Display Total’ (RMS430)
  • ‘Accounts Receivable. Display’ (ARS200)
  • ‘AR Payment Forecast/Age Distribution. Display’ (ARS260)
  • ‘Payer. Display Payment Pattern’ (ARS270)

Before you start

  • The company must have a well-defined policy for managing customer credit risk.

Parameters to Set

Depending on the value entered here, different values are displayed in the Value 1 and Value 2 columns in ‘Credit Monitoring. Display per Payer’ (RMS421/B) and ‘Credit Monitoring. Display Total’ (RMS430).

Program ID/Panel Field The field indicates …
(RMS905/E) Customer stop

… whether customers blocked with status 90 in the Status field in ‘Customer. Open’ (CRS610/E) are included when retrieving information in ‘Credit Monitoring. Create Transactions’ (RMS410).

– Value 1 and 2: Not applicable.

(RMS905/E) Credit limit 1

… whether customers having exceeded the first credit limit specified in ‘Customer. Open’ (CRS610/J) are included.

For more information on this and the following credit limit fields, see Apply Company Credit Policy to Customer

– Value 1: Amount past due

– Value 2: Credit limit 1.

(RMS905/E) Credit limit 2

… whether customers having exceeded the second credit limit specified in (CRS610/J) are included.

– Value 1: Outstanding amount

– Value 2: Credit limit 2.

(RMS905/E) Credit limit 3

… whether customers having exceeded the third credit limit specified in (CRS610/J) are included.

– Value 1: Outstanding amount and amount for open orders

– Value 2: Credit limit 3.

(RMS905/E) Insurance limit exceeded

… whether customers who have exceeded their insurance limit specified in (CRS610/K) are included.

– Value 1: Outstanding amount

– Value 2: Insurance limit.

(RMS905/E) Days of Sales Open (DSO) code

… whether customers with a specified DSO code are included.

– Value 1: DSO code

– Value 2: DSO value.

(RMS905/E) DSO codes 1–6

… up to six DSO codes to be used as a selection criteria when retrieving information for credit monitoring, provided the DSO code check box is selected.

Example

By selecting DSO code 2, only customers buying less but increasing credit time are included. By adding code 5, customers with unchanged buying habits but with increased average time for payment are included as well.

– Value 1 and 2: See previous field.

(RMS905/E) Number of credit days > XX days

… whether customers with an invoice past due more than the number of days specified in (RMS905) – see below – are included.

– Value 1: Total amount past due for selected invoices

– Value 2: Number of invoices

(RMS905/E) Days past due – credit hold

… the maximum allowable number of days past due date for an invoice.

– Value 1 and 2: Not applicable.

(RMS905/E) Follow-up date exceeded by XX days

… whether customers with invoices overdue the number of days specified in (RMS905) from the follow-up date – see below – are included.

– Value 1: Total amount past due for selected invoices

– Value 2: Number of invoices.

(RMS905/E) Days past follow-up date

… the maximum allowable number of days past the follow-up date for an invoice.

– Value 1 and 2: See previous field.

(RMS905/E) Stop date exceeded by XX days

… whether customers with invoices overdue the number of days specified in (RMS905) from the stop date – see below – are included.

– Value 1: Total amount past due for selected invoices

– Value 2: Number of invoices.

(RMS905/E) Days past stop payment limit

… the maximum allowable number of days past the stop payment date for an invoice.

– Value 1 and 2: See previous field.

(RMS905/E) Unpaid payment document

… whether customers with unpaid and/or refused checks and drafts are included.

– Value 1: Outstanding amount

– Value 2: Number of documents.

(RMS905/E) Exchange rate type

… an exchange rate type previously defined in ‘Exchange Rate Type. Open’ (CRS056). The rate type is used when converting credit limits and past due amount to local currency during the selection of invoices in (RMS410).

Note: This field is only displayed if the company consists of several legal units.
(RMS905/E) Amount without risk

… if invoices marked as outstanding without risk should be included.

A setting in (CRS075 - Payment Term. Open) determines whether an invoice should be classified as outstanding without risk.

An outstanding invoice amount without risk is a customer invoice or debt that is considered to be without risk in the accounts receivable according to the normal credit policy. The outstanding amount without risk is deducted from the outstanding amount when the credit limits are compared against the fixed credit limits.

Invoices with risk-free payment terms do not consume the available fixed credit limit that has been set for general trading terms. The benefit of this flexible approach to credit checking means that fixed limits do not need to be adjusted except as determined by the regular credit limit or customer risk reviews. For overdue invoices, all invoices are with risk even if they have been treated as risk-free before the due date has passed.

Follow These Steps

  1. Start ‘Settings – Credit Monitoring’ (RMS905/B).

  2. Enter a division. Click New.

  3. On the E panel, define the credit monitoring based on the table in the Parameters to Set section. Press Enter to finish.