Applied Deposits Field

There are AdvanceBIllBal and DepositBal fields in OrderHed and OrderDtl tables. I think you'll find your amounts there.


We’re having trouble reconciling the Deposit Invoice report. I’m trying to query to find the value displayed on the invoice form/tracker but I can’t figure out where this is stored in the db. It looks like it changed with E9, since I have values in InvcHead.DocDepositCredit but they only go through the date we converted to E9. Am I missing something obvious or is this not a stored value?



Emily Johnston

Fusion Specialties


phone: 303-951-2401

2400 Industrial Lane

Broomfield, CO 80020