Understanding AR “adjustment types” in Sage 300CRE
Cleaning up old reports
By Kyle Zeigler, Sage Certified Senior Consultant
Cleaning up the Accounts Receivables aging in particular can be confusing and troublesome for Sage 300 CRE users, especially if this hasn’t been done in a while. Do you edit, void, or use an adjustment to make corrections to invoices, retention, or over/underpayments? For outstanding transactions in prior accounting periods, edits or voids are not likely the right choice, but then what adjustment type is going to produce the desired results? The good news is that the best resource available for selecting the proper adjustment type is right at your fingertips.
For immediate help with understanding AR adjustment types, go to the AR application and launch Help. On the index tab, enter the word “adjustment” and look for the “adjustment types” topic that will be included in the list of topics. Double-click to open this topic and you’re on your way.
Ask yourself these questions…
The main rule for selecting an adjustment type is to first determine whether you want the adjustment to affect the customer only, accounts receivable only, or billed information in Contracts and Job Cost. That is, do you want the accumulated totals to be increased or decreased on the customer, contract or job, or do you just want the total accounts receivables to be increased or decreased without changing the total amount billed on the customer, contract or job? Other questions to ask might center on whether you are adjusting an invoice now on a contract or job that will be invoiced again in the future, or whether the contract or job is completed and you are now correcting overbillings or adjusting negotiated customer discounts or other such scenarios.
By reviewing the information in the “About adjustment types” Help topic prior to making an adjustment and understanding the effect of the adjustment on the customer, accounts receivable, contract and job cost billed totals, you can select the proper adjustment the first time avoid the frustration of trial and error and worrying about the results — a much cleaner approach to spring cleaning in Accounts Receivable.