Cash Adv Applied - amount stored in EX_ADV_HDR.BALANCE record field

EX.ADV.HDR.BALANCE record field has been previously reported not been updated accordingly. It is anticipated that EX_ADV_HDR.TOTAL_AMT record field to be >= to records fields listed below:

EX_SHEET_HDR.ADVANCE_AMT

EX_SHEET_ADV.AMOUNT_APPLIED

As a result when value stored on EX_ADV_HDR.TOTAL_AMT record field is > than these record fields, there should be a value > 0.00 on the EX_ADV_HDR.BALANCE record field

And when value stored on EX_ADV_HDR.TOTAL_AMT record field is = to these record fields there should be a value = 0.00 stored on the EX_ADV_HDR.BALANCE record field.