We wish to see vendor dues at any given day. One form should show the total dues and we should be able to see the details for the amount dues in a drop down list and if we wish to UN check certain invoices i should be able to do that.
Example for a Vendor:
Total Due = $100000
The drop down should give me details invoice wise. Where the payment clerk should be able to un-check certain invoices, if we decide to pay $80000.
Please advice the best possible way to handle such requirement.