Quickbooks style payments

[RichSmith]

I would like to create a form to display and pay invoices in the style used by Quickbooks.

A client's invoices are displayed with balances greater then zero one payment is listed for the client (see hihlighted)then in the payment column the payments are calculated across the open invoices on a line by line basis till the balance reaches zero of any or all invoices reaches zero. A overpayment can happen or an under payment of one or more Line item (invoices) can happen. Can this be done in Filemaker 11? How would this be calculated?

Thank you

Rich

..

QuickbooksPaymentsExample.pdf