How do I change distribution information on a paid Accounts Payable invoice?
Description
Cause


Resolution
There are two options:

  • Add new distributions to reverse and replace the original distributions. Record a payment for the entries. See steps below.
  • Use Record Entries in General Ledger if the changes are only for GL account reallocation. Do not use this option if changes are to reallocate to a different Commitment, Job, Cost Code or Category.

Change the distributions on a fully paid invoice in Accounts Payable:
Notes:

  • Invoice changes may post to a closed period depending on the accounting date of the invoice. If you do not want to post invoice changes to a prior period in General Ledger or Job Cost, change the accounting date of the invoice to the current period. See the Note under step 2 for more information.
  • If you use intercompany accounting see How does Accounts Payable determine when intercompany accounting is needed and which accounts to use? for more information before changing prefixes.
  1. From Tasks, select Change Invoices.
  2. Enter the Vendor and Invoice ID for the invoice you want to change.
  3. Press Tab or Enter until you see the distribution grid.
  4. Press Tab or Enter until you move to a new distribution line. Don’t change the original distribution.
  5. Enter a new negative line of distribution that offsets the paid line of distribution you want to reverse. Enter the same account and job information as the original paid line of distribution with negative amounts.
    • Note: You may need to enter multiple negative lines of distributions if you want to offset multiple paid lines of distributions.
  6. Enter new positive lines of distribution with correct distribution information. Offsetting negative lines of distribution and new positive lines of distribution should net to zero. The invoice amount does not change.
    • Example: You have an invoice for $100.00 that you entered and fully paid. There are two lines of distribution for $50.00 each. They have incorrect job information. When you correct these invoices, you enter four new lines of distribution. Two lines of distribution for -$50.00 that have the original incorrect job information, then two new lines of distribution for $50.00 each that have the correct job information. The net change to the invoice amount is zero. There are now six distributions instead of two.
  7. Click Accept dist after entering each new distribution.
  8. Click Accept invoice after making all invoice changes.
    • Note: If you changed the accounting date to your current period, you can specify where to send the reversing entries. Select Revised accounting date and click OK.
  9. Click Finish and print your journal. Your new distributions net to zero, but they are unpaid and have a status of Open. If you use cash basis accounting, the expense information doesn’t post to General Ledger until these distributions are paid.

Pay these distributions to change the status to Fully Paid by printing checks for this vendor or by recording a $0.00 manual check:
Note:
If the invoice was paid or recorded in Record Payment by Credit Card and the prefix was incorrect, record the payment with record payment by credit card instead of record manual/print quick checks. This will create the entries to correct the Credit Card Payables accounts previously used.

  1. From Tasks, select Record Manual/Print Quick Checks.
  2. Choose a payment Method
    • If you use Quick Check a Check will print with a check stub showing the changes made, The check will be recorded in Cash Management and can not be reused.
    • If you use Manual Check the check number will record in Cash Management and cannot be reused. No Check stub will print.
    • If you record the entry as an EFT Payment to use a Reference number instead of using a Check number. Reference numbers can include characters like "Inv123412C". No check stub/notice will be print.
  3. Enter Bank information as usual.
  4. The payment amount is 0.00.
  5. In the Invoice column of the invoice grid, click List. Select the invoice changed above. Change the Amount to 0.00.
    Note: If invoice was fully paid, clear the Retainage Held on the correcting lines. If Retainage has not been paid, Zero the Retainage Held Amounts on the Credit/Negative lines, enter the total held retainage amount in the Invoice Amount.
  6. In the Distribution grid, the Amount column should total 0.00.
  7. Click Accept invoice. Click Accept check.
  8. Click Finish. Print your journal.
  9. Post entries in General Ledger and Job Cost.


[BCB:156:Chat 300 CRE US:ECB]

Steps to duplicate
Related Solutions

DocLink: What changes can I make to a fully paid invoice in Accounts Payable?
DocLink: How does Accounts Payable determine when intercompany accounting is needed and which accounts to use?
DocLink: How do I print checks in Accounts Payable?