| How to adjust or reverse an Accounts Payable invoice |
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 - Open Accounts Payable, Main menu, Invoice Data Entry
- For Vendor No., enter the Vendor Number to which the invoice belongs
- For Invoice No., enter the Invoice Number to be adjusted
- Click Adjust in the Adjust Invoice on File window that appears when an existing invoice is referenced
- 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.
- 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
- Click Accept
- 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:
- Select Tax Schedule
- Enter a Tax Class and click on the Tax Detail button
- Enter the Tax Amount as negative
- Click OK
- 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]
|
|