Creating Written Payment Reminder for Past Due Customer Invoices in (ARS150)

This document explains how to create a written payment reminder; that is, a list of customer invoices past due, for one or several payers or customers.

Outcome

A payment reminder is created and printed, displaying all past due accounts receivable invoices, per payer or customer and currency. Depending on the payment reminder rule used, any penalty interest may be specified and open invoice records that are not past due can also be included. Each record can be printed with the voucher text as additional information or a comment. The reminder can be sorted per salesman, credit department reference, etc.

You can review the invoices included in the reminder in 'Acc Receivable. Display Additional Info' (ARS250) even after the reminder itself is deleted in 'Payment Reminder. Open' (ARS150).

Print interest invoices as well, depending on how the payment reminder rule is defined.

You can send the payment reminder to the payers.

Create account entries if any interest invoices are created together with the payment reminder. The reminder is saved in the following reminder files: FREMD1 (listing name and status of all reminders), FREMD2 (listing payers), and FREMD3 (listing invoices).

The reminder is automatically allocated information category number 202 and saved under its reminder number.

The reminder level and the last reminder date displayed in 'Customer Invoice. Change' (ARS201) are updated.

Block codes used

When a specific invoice is included in the printed reminder, it receives block code 9 in the accounts receivable file (FSLEDG). This prevents the invoice from being included in another payment reminder proposal until the number of days specified in the payment reminder rule is passed.

Additional payment reference

You can create a 'Parallel invoice number' for customer invoices. The rules for this are defined in 'Additional Payment Reference. Open' (CMS090). The only available 'Reference number type' is 1='Parallel invoice number'. You can only add the 'Parallel invoice number' to the XML when an invoice document is created. The 'Parallel invoice number' is saved in the FSAPRN table together with the invoice number.

Before you start

Before you can start, you must meet these prerequisites:

  • You must meet the starting conditions listed in Managing Customer Debts by Using Reminders.
  • You must define the number series type 50 under number series 1 for the payment reminder in 'Number Series. Open' (CRS165).
  • Rules that determine which invoices should be included in the reminder must be set in 'Payment Reminder Rule. Open' (CRS465).
  • You must connect each customer to be included in the payment reminder routine to a payment reminder rule in 'Customer. Open' (CRS610/K). Note that you must activate the rule in the adjacent field.
  • If standard texts for opening and closing comments are to be used in the payment reminder per language, you must define these in advance in 'Payment Reminder Rule. Enter Text' (ARS010).
  • To calculate interest and include it in the payment reminder, you must define an interest rule in 'Interest Invoicing Rule. Open' (CRS460) and connected to the payer in 'Customer. Open' (CRS610/K).

Follow these steps

  1. Create a payment reminder proposal

    Create a proposal in 'Payment Reminder. Open' (ARS150) by specifying different selection criteria.

    Note: All credit invoices are included in the proposal, regardless of due date. If the credit total is equal to or greater than the total amount due – that is, if the customer is owed – then all customer invoices in the proposal are blocked from being included in the final payment reminder.

  2. Adjust the payment reminder proposal

    When necessary, adjust the proposal by blocking or deleting payers or invoices to prevent them from being included in the reminder. This is done in (ARS155) and (ARS156). These programs are called from (ARS150).

    You can also add or adjust opening and closing comments and other user-defined texts to be printed on the payment reminder in (ARS155). This program is called from (ARS150). If standard texts are defined, these are automatically retrieved but can be changed. See Before you start above.

  3. Create the final payment reminder

    Print the payment reminder in (ARS150). Note that you cannot change or review the payment reminder on screen after having been printed. You can print it again, naturally.

  4. Send the payment reminder to the payer

    You should send the reminder to the payer on the day specified as the reminder date. Since the reminder is saved under an information category number, you can then delete it in (ARS150).

Related topics