ERP Consultant Blog

How to Make Sage 100 Accounts Receivable Invoice Adjustments

Written by Mike Renner | Fri, Apr 29, 2016

Question: How and when is it appropriate to make an Accounts Receivable invoice adjustments in Sage 100?

As a Sage 100 consultant, I wanted to share an answer to a question I occasionally get from our Sage 100  (formerly Sage MAS90) customers about how do I do an adjust an Accounts Receivable Invoice entry. Also, when is it appropriate to make adjustments?

Answer: An Accounts Receivable invoice adjustment may be necessary because an incorrect entry was made. Sometimes it is done when a customer requests a write-down of an invoice, but this can also be handled with a credit memo. Note when an invoice adjustment is made there is no invoice printed, so if you need something printed to give to the customer we suggest using a Credit Memo.

First, go to Sage 100 ERP Accounts Receivable>Main>Invoice Data Entry, type in the invoice number and customer number. After this you will see a message, Invoice already exists do you want to adjust, click the yes button.


 
Second, the system then pulls the existing invoice information and shows it on the screen, at the first screen verify the information is correct and then click the OK button.



Third, the system will then pull the original invoice entry screen with the original date, click on tab #2 lines and type in the adjustment amount and use the correct item codes, you will want to make the amount negative. In our example we wanted a $50 adjustment. Accept the entry, run the Accounts Receivable sales journal and post as always.
 
You should now be able to check in Accounts Receivable Customer Invoices and see the reduced amount of the invoice in question.

If you have questions please contact us at www.caserv.com or 760-618-1395. Please stay tuned for more helpful Sage 100 ERP tips!

Written by Mike Renner, Partner WAC Consulting, Owner at Computer Accounting Services Mike is an expert on Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage and Acumatica.

Specialties

Sage 100 ERP (formerly Sage MAS90 / MAS200), Sage 100 Fund Accounting (formally MIP Non Profit Software), Sage Grant Management, Acumatica, Sage Online Fundraising, QuickBooks Enterprise and Point of Sale VAR.