Skip to the main content.

 

FREE ASSESSMENT

StarShip

 


Paya Nuvei Logo 2

 

AvidXchange Logo USE

 

1 min read

In Sage 100 ERP, how do I do an adjusting invoice entry and when?

In Sage 100 ERP, how do I do an adjusting invoice entry and when?

Common question: In Sage 100 ERP (formally Sage MAS90) Accounts Receivable how do I do an adjusting Invoice entry and when is it necessary?

Answer:  Normally an Accounts Receivable invoice adjustment is 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. 

Adjusting Invoice entry resized 600

Second, the system will then pull the existing invoice information and show 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 $100 adjustment. Accept the entry, run the Accounts Receivable sales journal and post as always.

Adjusting Invoice entry 2 resized 600

Fourth, If the Sage 100 ERP Accounts Receivable Trail Balance Report balances, then this normally means there are dating issues with the input of Sage 100 ERP Accounts Receivable Invoice data entry. In other words an invoice with an invoice date of 5/31/2012 should be posted with an accounting date of May 2012. If it was posted with an accounting date of 6/1/2012 this would cause the Sage 100 ERP Accounts Receivable balance to not agree with the Accounts Receivable Aged Report.

Fifth and final step, through Sage 100 ERP Accounts Receivable Customer Maintenance, Invoices check each of the Accounts Receivable Invoices in question that are showing up on the Aging Report. Trouble shoot them, match the invoice date with the accounting posting date. If there is an error do a reversing entry to the Sage 100 ERP invoice in question and correct the date until the report balances.

 Adjusting Invoice entry 3 resized 600

 

Thank you Mike Renner at www.caserv.com for this helpful Sage 100 ERP guest blog tip!  Please stay tuned for more helpful Sage 100 ERP tips!
ERP Implementation Partner Selection Tips and eBook

ERP Implementation Partner Selection Tips and eBook

How to Find the Right ERP Implementation Partner Working with the right ERP implementation partner will be critical to the success of your ERP...

Read More
Are You Outgrowing Your ERP Manufacturing Software?

Are You Outgrowing Your ERP Manufacturing Software?

3 Tips for Finding the Best ERP Manufacturing Software for Your Business If your manufacturing company is outgrowing your software the search for...

Read More
5 Ways a New Manufacturing ERP Helps Your Business Grow

5 Ways a New Manufacturing ERP Helps Your Business Grow

Grow Your Business with a New Manufacturing ERP Solution The economy is constantly changing, and manufacturing companies have been hit hard by recent...

Read More