Does anyone know where the OrderHed.OpenBalance field from Customer Credit Manager is actually stored in the DB? It shows the current open balance for open orders for a customer.
John
I think this might be a value that is calculated on the fly?
Erp.Proxy.BO.CreditManagerImpl GetOrdersAny idea on what it’s doing to calculate the value? There used to be a conversion that you would run to recalculate credit limits, which makes me think that it is writing the value to a table…somewhere.
I received an answer from Support so I thought I would include it for anyone to find later:
Table:OrderHed
Formula : OrderHed.TotalCharges + OrderHed.TotalMisc - OrderHed.TotalDiscount + OrderHed.TotalTax - OrderHed.DepositBal - OrderHed.TotalAdvBill - OrderHed.TotalInvoiced
2 Likes