How to adjust or reverse an Accounts Payable invoice
Description


Cause

Resolution
New to Sage 100 or just need a refresher? Find out what SageU has to offer.


For additional training on this KnowledgeBase topic, click here!

Section I: Adjustments to Invoice Balance:
Monetary adjustments may not impact some reports such as the Accounts Payable Aged Invoice Report and Accounts Payable Trial Balance Report..
Please refer to KB article 18430, DocLink: How to enter credit and debit memos in Accounts Payable

  1. Open Accounts Payable, Main menu, Invoice Data Entry
  2. For Vendor No., enter the Vendor Number to which the invoice belongs
  3. For Invoice No., enter the Invoice Number to be adjusted
  4. Click Adjust in the Adjust Invoice on File window that appears when an existing invoice is referenced
  5. On the Header tab:
    • For Adjustment Amount:
      • To increase the invoice balance: Enter a positive amount to adjust the invoice by.
      • To decrease the invoice balance: Enter a negative amount to adjust the invoice by.
      • If you are only changing the G/L distribution account on the invoice: Enter 0.00 as the adjustment amount
        • On the lines you will enter the original GL account and the amount as a negative.
        • For the correct GL account you will enter the amount as a positive creating a zero dollar adjustment.
        • If possible, always use the original posting date.
      • To "delete" or "adjust out" or "zero out" an invoice: Enter the entire balance of the invoice equal to the amount. (Negative or positive = zero)
        • Note: Invoices are not truly deleted. Those adjusted to $0 will show with an Invoice Balance of $0. Eventually, they will be cleared based on your retention settings.
        • Note: Adjustments are considered transactions of the original invoice and all reports where prompted to include or exclude "future-dated transactions" will be impacted. A separate credit or debit memo entered and updated then, manually applied through Manual Check and Payment Entry is a more thorough process of reducing or increasing an invoice balance.
  6. On the Lines tab:
    • If integrated with Job Cost, enter Job No. entered on original invoice entry.
    • For G/L Account, enter the original incorrect General Ledger account as a negative amount. Usually, this will be the same account(s) posted (debited or expensed) for the original invoice, but that is not always the case. And then enter the correct G/L account with a positive amount. (The net result should be zero)
    • For Amount, enter the amount of the adjustment, whether a positive or negative amount. If there is more than one line, a proper amount may have to be allocated to each G/L account for the adjustment entry.
    • For Comment, enter a comment if desired
  7. Click Accept
  8. Click the Print (printer icon) button to print and update the Accounts Payable Invoice Register to post the adjustment to the invoice

Section II: Adjustments to Invoice Date:

Section III: Adjustments to Discount:

  • To adjust the amount of the discount for the invoice, enter any change to the discount amount in the Discount Adjustment field.
  • For example, if an existing invoice has a $2 discount which should be $5, enter $3 in the discount adjustment field. After the invoice is updated, it will reflect a $5 discount ($2 original + $3 adjustment).

Section IV: Adjustments to Tax Calculation:

  • In the Adjust Invoice on File window:
    1. Select Tax Schedule
    2. Enter a Tax Class and click on the Tax Detail button
    3. Enter the Tax Amount as negative
    4. Click OK
    5. Accept the Invoice

Section V: Adjustments to Invoices from Purchase Order:

  • While invoice receipts created via the Purchase Order module may also be adjusted in this manner, be aware that adjustments to them that are made via A/P Invoice Data Entry will not be able to reference Item Codes (meaning inventory quantities will not be affected), and Purchase Orders and P/O Receipt History will not be updated either.
  • If postings are made to an Inventory account number from A/P Invoice Data Entry, that may lead to discrepancies between the Inventory Trial Balance Report and the reports in General Ledger for the Inventory account.
  • Depending on the circumstances, you may want to consider entering a negative P/O Receipt of Invoice Entry or consider entering a P/O Return of Goods Entry with Invoice Number.


DocLink: How void or delete an AP invoice
DocLink: How to create or enter invoices in Accounts Payable, Invoice Data Entry for Sage 100
DocLink: How to process a Return of Goods Entry in Purchase Order to reverse a receipt of goods.
DocLink: How to reverse a Receipt of Invoice Entry posting
DocLink: How to change an incorrect Invoice Date or Due Date for a posted Accounts Payable invoice

[BCB:155:Chat 100 US:ECB]

Steps to duplicate
Related Solutions