Invoice Overpayments

Epicor ERP 10
1

We have a customer that is overpaying invoices and wants to due a ‘true up’ periodically (quarterly or end of year). They do this because our pricing changes quarterly due to fluctuation in material costs which in turns adjusts prices. They want to pay the same price and true up at end of period.

We do not want the overpayment to appear as a credit on the aging report. We created a seperate G/L sales account for these overpayment amounts.

However, when using AR adjustments/write offs - and writing off balance to this account - it hits the review journal with error
Combination of controlled segments is invalid Company XXX. COACode MASTER. Account 3035|00. [Line 1]
Account is inactive Company XXX. COACode MASTER. Account 3035|00. Date 6/10/2019 [Line 1]

Is this account not set up correctly? Is there something we need to run after? Any ideas?

We wanted the seperate account to keep track of all these overpayments easily so when it comes time to true up - it is easily done.

2

Looks like either the segment (3035) or the account (3035-00) is inactive. Verify that the GL account is active.

3

They are marked ‘active’

4

And 3035-00 is an active GL Account?

5

It is.

We ran ‘Rebuild Display GL Account’ - when in to the journal review - revalidated and confirmed. All set now. Guess we missed the step of ‘Rebuilt’ after created this new GL account.

I do believe there may be a better way to handle this rather than doing adjustments every time but at least this worked and we now have a good balance in that account.

Thank you!