Cash Advance Amount Monitoring AP Down Payment Invoice
I would like to ask in the AP Down payment Invoice to know or monitor the remaining amount until became zero from AP Invoice.
How to connect this tables?
Example output is :
CA No. Cash Advance AP Invoice API Amount CA Drawn Balance
114 200000 1347 142,118.74 142,118.74 57881.26
1354 86,191.31 57,881.26 0.00
Thank you very much.