Clearing Offsetting Open Items in Accounts Receivable

In order to get open items off of the A/R Aging Report, they need to be applied to an invoice.

If an invoice does not already exist that would be appropriate for applying the open items, then you need to create an invoice for zero dollars, and do reapplications of the open debit item(s), open credit item(s), or open payment(s) to that invoice.

If one or more of the items are open credits or debits, use this procedure.

  1. Open the A/R Posted Transactions Detail form.
  2. To reapply an open debit or credit to one invoice:
    1. Filter for both Customer and Open Credit.
    2. In the Invoice field, either enter or select the invoice to apply the open debit or credit.
    3. Click Save.
  3. To reapply an open credit to multiple invoices:
    1. Determine the check/reference number of the credit memo you want to reapply.
    2. Add the customer number and check/reference number of your open credit.
      Note:  The receipt date normally would not be changed. Credits are already against Accounts Receivable and no journal entries will be created as a result of this reapplication.
    3. Click Save.
    4. Open the A/R Payment Distributions form.
    5. Add as many invoices as required to distribute the credit amount.
    6. Perform A/R Payment Posting to post the reapplication.
    7. If one of the items is an open payment transaction, then you will need to do the following:
      • Determine the customer number and check number from A/R Posted Transaction Detail form.
      • Open the A/R Payments form.
      • Enter Customer Number and Check Number. You should see RE-APPLICATION OF OPEN PAYMENT beside the G/L Reference. If this does not appear, stop here and re-examine the check number being entered.
      • The date of the check should be changed to the current date. A journal entry will be created as a result of the reapplication. The entry will debit the A/R Deposit Account and credit the Accounts Receivable Account.
      • Go to the A/R Payment Distributions form, enter the zero dollar invoice number as required to distribute the Open payment.
      • Perform A/R payment posting.