• Monetary adjustments don’t affect certain reports. For example, the Accounts Payable Aged Invoice Report and the Accounts Payable Trial Balance Report
• To learn more, check out How to enter credit and debit memos in Accounts Payable

On the Invoice Data Entry 

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 you’re adjusting.
4. Click Adjust in the Adjust Invoice on File window that appears.

Header tab

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’re only changing the G/L distribution account on the invoice: Enter 0.00 as the adjustment amount
  • On the lines, you’ll enter the original GL account and the amount as a negative
  • For the correct GL account, you’ll 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. (Negative or positive = zero)
  • Invoices don't truly delete. Those adjusted to $0 will show with an Invoice Balance of $0
  • Eventually, they’ll clear based on your retention settings
  • We treat adjustments as part of the original invoice. Any report that asks whether to include 'future-dated transactions' will reflect those changes
  • For a more thorough way to adjust an invoice balance, enter a separate credit or debit memo. then update it.  Manually apply it using Manual Check and Payment Entry

Lines tab

• If integrated with Job Cost, enter Job No. entered on the original invoice entry
• For G/L Account, enter the original incorrect General Ledger account as a negative amount. Then enter the correct G/L account with a positive amount. (The net result will be zero)
• For Amount, enter the amount of the adjustment, whether a positive or negative amount
  • Is there more than one line? You'll need to allocate an amount to each GL account for the adjustment entry
• For Comment, enter a comment if desired

Post the adjustment

1. Click Accept.
2. Click Print (printer icon) button to print and update the Accounts Payable Invoice Register and post the adjustment.

Adjustments to Invoice Date

• See Change an incorrect Invoice Date or Due Date for a posted Accounts Payable invoice

Adjustments to Discount

• To adjust the discount, enter any change to the discount amount in the Discount Adjustment field

   

  For example: Enter $3 in the discount adjustment field
   if the invoice shows a $2 discount and is supposed to be $5

   

  • After you update the invoice, it will reflect a $5 discount ($2 original + $3 adjustment)

Adjustments to Tax Calculation

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

Adjustments to Invoices from Purchase Order

• You can adjust invoice receipts from the Purchase Order module, but A/P adjustments won’t update inventory
• A/P Invoice Data Entry adjustments won’t affect item codes, inventory quantities, or P/O history
• Posting to Inventory accounts from A/P Invoice Data Entry will cause mismatches between Inventory and General Ledger reports
• To correct entries, consider using a negative P/O Receipt of Invoice or a P/O Return of Goods

New to Sage 100 or just need a refresher? Find out what SageU has to offer.
Check out extra training on this knowledgebase topic.

Void or delete an AP invoice
Create or enter invoices in Accounts Payable, Invoice Data Entry
Process a Return of Goods Entry in Purchase Order to reverse a receipt of goods
Reverse a Receipt of Invoice Entry posting