Eliminating Residual A/R Balances

Before you generate any financial statements, use the Residual A/R Balance Eliminations utility to eliminate any residual A/R balance  amounts that were created by exchange rate fluctuation and currency rounding differences. Residual balances show up as open items in receivables. This utility eliminates the residual balance amounts by generating debit memos or credit memos  to offset the balance.

Note:  This utility only generates debit and credit memos for individual  customers and not for corporate customers.
  1. In the Residual A/R Balance Eliminations utility, specify the search criteria ranges for the residual balances.
  2. Select Preview and click Process.
  3. The lower grid displays the results based on the criteria you selected:
    • For open item customers, the utility searches their open accounts receivable records and invoices net balance due. If the net amount is a positive balance, a Credit Memo will be created for each of the invoices. If the net amount is a negative balance,  a Debit Memo will be created for each of the invoices.
    • For balance forward customers, the utility searches their open accounts receivable records and net amount from their invoices. If the net amount is a positive balance, a Credit Memo will be created as an open credit and the invoice number will be zero. If it is a negative balance, a Debit Memo will be created and the invoice number will be zero. The words "Balance Forward" display in the Invoice column on the lower grid. The Invoice Date in the grid will be blank.
  4. Select Commit and click Process.

    If the open invoice amounts are positive numbers, the utility generates Credit Memos; if the amounts are negative numbers, the utility generates Debit Memos.

    Note: The Debit Memos and Credit Memos generated here are similar to those entered using the Invoice, Debit and Credit Memos form except they will use the general ledger account number defined in this utility. You can still run the Delete A/R Posted Transactions utility to set the customer balance forward to zero.
  5. After the utility generates the debit or credit memos, use the Invoice, Debit and Credit Memos form to modify the transactions and then post using the Invoice Posting Utility.
Related topics