Automatically Allocating Customer Payments from Batch File to Invoice

This document explains how you allocate verified and adjusted customer payments in the form of electronically transferred receipt orders received from bank to your customer invoices.

Outcome

Receipt orders in a batch file are allocated to customer invoice records in accounts receivable. An accounting journal, a customer payment journal, and a checklist are printed.

If any allocated receipt orders need to be corrected, continue with Adjusting Customer Payments.

Accounts receivable and the general ledger are updated. For information on account entries created, see Allocating Customer Payments to Invoice.

The receipt orders may include variances like cash discount, VAT handling, advances, or exchange rate differences. If so, these are recorded separately under accounting event AR40 (Automatic customer payments).

Before you start

  • The starting conditions listed in Processing Customer Payments must be met.
  • Accounting rules under accounting event AR40 must be defined in 'Accounting Rule. Set' (CRS395).
  • The batch file with the electronically transferred receipt orders must be downloaded, verified, and adjusted.

Follow These Steps

  1. Allocate Receipt Orders from Batch File to Invoice

    Update accounts receivable by using the function for automatic allocating of receipt orders to invoice records. You do this in 'Batch Payment. Update' (ARS040).

  2. Verify Allocation Result

    Review the result of the allocation in 'Accounts Receivable. Display' (ARS200) to check whether any payment records need to be processed further.

  3. Adjust Payment Records Further in Accounts Receivable

    If necessary, adjust the allocated payments in any of the ways explained in Adjusting Customer Payments in 'Payment Received. Record' (ARS110).