How to find balance for multiple Invoices of a similar Doc Number
Hello All,
Please find the attachement with the screenshot
I have Columns CLEARING_DOCUMENT_NUMBER, DOCUMENT_NUMBER, Amount, Payment and Balance.
One CLEARING_DOCUMENT_NUMBER has multiple DOCUMENT_NUMBER and every Document_Number has certain amount and if the Payment is completed the balance should be zero if not then the Balance should show the Pending Amount.
For Example: CLEARING_DOCUMENT_NUMBER - 1400000235
DOCUMENT_NUMBER for above CLEARING_DOCUMENT_NUMBER : 90000416 90000432 90000475
In the 4th row this CLEARING_DOCUMENT_NUMBER -1400000235 gives total of all DOCUMENT_NUMBER , So if the the Amount total and Payment total matches the Balance output should be Zero else vice versa.
