How to Offset an Open Invoice and Open Credit Memo in the AP Open Item File

Release: 11/30/2022
Version: 7.x & Up

Accounts Payable has an Open Item file that contains all the vouchers, checks, credit memos, and adjustments.  AP does not have a reapply utility like Accounts Receivable, so you are unable to reapply an open credit memo to a voucher when there is no check to print.  In the example below, credit memo 1526CM needs to be applied to invoice 1526 for $7,450.86.

Even though the vendor balance is $0.00, the open items still print on the A/P Open Item Report.  Another way to offset the credit memo and invoice is to use the Manual Payment function in AP Open Item Adjustments to pay the invoice (positive) with the credit memo (negative) in the same batch.  This will mark the records as “fully paid.”  In AP, Processing, AP Open Item Adjustments, and Add, select Trx Type “M” (Manual Payment).  Enter the invoice as you normally would, but give the check number a special value (i.e., 99).

Now create a manual payment for the credit memo.  The check number should be 99, same as the invoice payment, and the payment amount should be negative (-7.405.86) as well.

Make sure Check-Totals is $0.00 on the A/P Open Item Adjustment Edit List.  This is very important.

Post the transactions in Post Adjustment Transactions in AP Processing.  Print the Manual Payment Register in AP Report to verify the transactions posted.  Print the AP Open Item Report to make sure the offset is successful.

MAD

• Related Articles

• How to Get All Credit Memo Documents in AR Open Item File

  Release Date: 12/24/2020 Version: 7.0 & Up Q - How do we get a list of all credit amount documents in the AROPNFIL that are not applied to anything? Is there a way to get just these documents using the Expanded Aging Report? A - You can use one of ...

• Feature - Automatically Reapply Credit Memo to Charge-Back Debit Memo

  Release Date: 3/23/22 Revised: 3/29/22 Version: 8.5 and Above This feature will reapply an existing open credit memo to a debit memo the system just created during cash receipt posting. This will reduce the user’s database entry burden involved in ...

• Feature - Credit Memo Warning When Fully Paid

  Release date: 9/14/2019 Version 8.5 & Up Users can enter a new Credit Memo using COP, Order Entry, Change Mode, and pressing F3 or F4 at the Order Number field. When using the F4 option, the application allows the user to pick the invoice to apply it ...

• AP22S1 Accounts Payable Purge AP Open Item File

  Purge A/P Open Item File Application Overview Even when an invoice has been fully paid, the information on the A/P Open Item File pertaining to it remains on file until purged. If you never purged the A/P Open Item File, the disk would eventually get ...

• AROLOAD Accounts Receivable A/R Open Item File Maintenance

  A/R Open Item File Maintenance Application Overview The A/R Open Item File is the file where all transactions that occur between you and your customers are stored. As such, it is a very important file. Any time you want to know how much a customer ...