Error: **Invoice 168880 - Sales Order has Negative Deposit Balance

Epicor ERP 10
1

Receiving an error when attempting to print an edit list from an AR invoice group. We just upgraded to 10.2.300.10.

Error: **Invoice 168880 - Sales Order has Negative Deposit Balance.

The steps to reproduce are as follows. Create a group -> New Deposit Billing -> Add the Sales Order -> Add amount on deposit line -> Save -> Actions -> Group -> Edit List.

The report fails and the error in the system monitor is above.

It seems that it occurs randomly only for deposit invoices. Haven’t got much help from Epicor support and can’t seem to find anything similar to this on the forum.

2

Jorge,
Did you ever get resolution on this? We are seeing this randomly as well (3) times since Oct 2018.

3

We get this when a deposit is applied then pulled from an order. The customer asks for the deposit to changed to another order or someone makes a mistake. Either way we have to get a datafix from Epicor support.

There is supposed to be a real fix in .300 and above but we’re on 10.2.200.x so can only get a datafix.

4

We were able to fix this error by recreating the Order itself and just re-linking any jobs or projects associated with that order. We are not 100% sure why it happens but that does seem to do the trick.

5

Nope, no need to recreate the order. This is a Deposit to DocDeposit mismatch. Both DocDeposit and Deposit must be the same value.

Create an Updateable BAQ for OrderHed. You will need to be able to update both Deposit and DocDeposit on the OrderHed. Put a criteria on OrderHed: DepositBal <> DocDepositBal AND DocDeposit >= 1 constant. Do a Get List on the BAQ and fix the balances. Easy as eatin’ pancakes.