There are AdvanceBIllBal and DepositBal fields in OrderHed and OrderDtl tables. I think you'll find your amounts there.
Sue
Sue
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
ejohnston@...
phone: 303-951-2401
2400 Industrial Lane
Broomfield, CO 80020