How to correct an incorrect posting date on an Accounts Payable Invoice
Description
Cause
Resolution

Note:  If the invoice has been paid you will first need to follow the steps for reversing a check in accounts payable DocLink: How to reverse a check in Accounts Payable. After the payment has been reversed, you can then proceed with the below steps.

Enter Credit Memo to reverse the original invoice:

  1. Open Account Payable, Main, Invoice Data Entry
  2. Select the vendor in the Vendor No. field.
  3. In the Invoice No. field enter the invoice number with a (dash) -cm
  4. In the Invoice Date field, use the same date as the original invoice
  5. Enter the Invoice Amount as negative.
  6. Click the Lines tab
  7. General Ledger Account(s) and Amount(s) should be populated
    • If they are not, select the GL Account(s) and enter Amount(s) as negative
  8. Click Accept
  9. Click Printer Icon
  10. Enter wrong posting date, use the same date as the original invoice
  11. Print Accounts Payable Invoice Register
  12. Confirm that posting date is the same wrong posting date
  13. If accurate, click Yes to update
  14. Print/Update the Daily Transaction Register

Manually apply credit memo to original invoice:

  1. Open Accounts Payable, Main, Manual Check and Payment Entry.
  2. Enter the Bank Code.
  3. Type APP and a number from 1 to 999 in the Check No. field
    (For example, APP001).
  4. In the Check Date, use the same date as the original invoice
  5. The Check Amount field should be zero and cannot be changed.
  6. In the Vendor No field, select the vendor number
  7. Click the Lines tab
  8. At the Invoice No field (line 1), select the invoice with the wrong posting date to apply the credit memo.
  9. At the Invoice No field (line 2), select the credit memo previously created.
  10. At the Invoice Amount field, change the invoice amount to reflect the amount of the credit memo, if necessary.
  11. The check distribution amount should be zero.
  12. Click Accept.
  13. Click Printer icon, the Account Payable Posting Date field, use the correct posting date.
  14. Click Print or Preview the Manual Check Register
  15. If accurate, click Yes to update
  16. Print/Update the Daily Transaction Register

Enter a new invoice with the correct posting date - it MUST be entered with a different invoice number.

DocLink: How to adjust or reverse an Accounts Payable invoice
DocLink: How to create or enter invoices in Accounts Payable, Invoice Data Entry for Sage 100

[BCB:155:Chat 100 US:ECB]

Defect ID
Steps to duplicate
Related Articles