After a decade of manual calculations in Epicor, I’ve discovered that the ‘Sales Order Balance’ is represented by the OrderHed.OrderOpenCredit column. Always learning!
4 Likes
Like the balance = the order open credit column?
Yes so if you ship a partial and pay partial invoice, or prepayment or whatever, the OrderOpenCredit will become lower and lower until 0$ when paid in full.
I used to calculate that myself using the OrderRel and Summing InvcDtl’s.
Also confirmed by @Jonathan
1 Like
Nice, that makes sense!
the recalc customer credit process only touches the balances on the customer records I am guessing? Or does it update the open order credit field too 
The OrderOpenCredit is recalculated by a Internal Process CalcOrderOpenCredit which is I think triggered by Invoice Payment (Cash Receipt) and that process will also run UpdateGlbCustCredWithOrderValues which seems to update Customer Credits. (Uncomfirmed just reading the trace code)
LibDeferredUpdate.PostCustCredit(Session.CompanyID, BTCustNum, 0, 0, 0, OrderOpenCredit, 0, 0, OrderCount, 0, "findboth");
1 Like
Still wish I learned more about how to be proficient at that from you. That and decompiling.
1 Like