1. Accounts Receivable Implementation Guide
  2. Balance Forward Match (R03B50B)

Balance Forward Match (R03B50B)

You can use the Balance Forward Match method to apply receipts to the invoices in sequential order. You can apply receipts to the oldest invoice or to the newest invoice. The system uses the invoice due date to determine the first invoice. Additionally, you can specify whether to match by customer and payor or payor only. This method reads the open invoices in a customer's account and applies the receipt to each invoice until either the receipt amount is zero or the system runs out of invoices for the customer.

The system applies a partial payment if the receipt amount is insufficient to completely close the invoice. If an amount remains on the receipt after applying it to all open invoices, the system creates an unapplied receipt.

The system has two demo versions for this base method that are defined to select invoices for payment according to either a last-in-first-out (LIFO) manner or a first-in-first-out (FIFO) manner.

This program contains a processing option that enables you to specify whether to allow the receipt open amount to exceed the received payment amount. Invoice documents with negative open amounts (such as credit memos) can cause the receipt open amount to be greater than the received check amount. This may occur when you have credit memo open amounts greater than the invoice open amounts that are being processed at the same time. Results may differ depending upon the order in which the report processes the documents from the Customer Ledger table (F03B11). If you enter a 1 in the Receipt Open Amount processing option, then the system does not process invoice documents with negative open amounts that cause the receipt open amount to be greater than the received check amount.

For example, assume you have a customer that has a credit balance and has the following records:

  • •Invoice (document type RI) for $10.00 USD.

  • •Credit memo (document type RM) for $-50.00 USD.

  • •Unapplied receipt (RU) for $500.00 USD.

When you run the R03B50B program, this could result in the system closing the credit memo and invoice and increasing the RU open amount being by the remaining net credit (-$540.00). Therefore, the open amount of the RU is greater than the gross amount.

(Release 9.2 Update) The JD Edwards EnterpriseOne software provides record reservation capability within the Balance Forward Match Batch Application (R03B50B). Record Reservation errors are sent to the Work Center.

Record Reservation errors are sent to the Work Center when some of the invoice pay items processed by the invoice matching routines are reserved by another process or user. Those invoice pay items are not considered for processing automatic receipts. To ensure that all applicable invoice pay items are processed, remove the reservation of the invoice pay items before executing the Automatic Receipt Processing program.

See Section 2.2,“Understanding Record Reservation (Release 9.2 Update)”for more information.

Using the Receipt Open Amount processing option, you can prevent the RU from having an open amount greater than the received check amount. If you enter 1 in this processing option, the RU would be used to offset the RI only and the RM would not be processed. This would result in the following:

  • •RI: open amount of $0.00 USD.

  • •RM: open amount of $-50.00 USD.

  • •RU: open amount of $490.00 USD.