Can anyone give me a little guidance?

[accessfleet]

I have a report to submit partial payments against a purchase order.

The math works fine when single purchase orders are closed after one partial payment. The math doesn't work when calculating the current Po balance when payment involves a second partial payment or when two different purchase orders have a remaining balance for the same vendor.
>>
>>There are blanket purchase orders combined with single purchase orders for some vendors. If the math could be tied to all transactions for the specific purchase order it wouldn't matter if more than one purchase order was open at a time.
>>
>>In my head math.
>>Po1 = 100.00 DATE 06/01/12
>>IV1 10.00 06/02/12
>>IV2 10.00 06/03/12
>>IV3 10.00 06/04/12
>>PARTPAY1 30.00 06/06/12 CURRENT PO BAL 70.00
>>IV4 20.00 06/07/12
>>Iv5 20.00 06/08/12
>>Iv6 20.00 06/09/12
>>Partpay2 60.00 06/19/12 CURRENT PO BAL 10.00
>>IV7 10.00 06/20/12
>>
>>OK2PAY&CLOSE Po1 10.00 07/03/12

 

[accessfleet]

Problem solved.

Query to select purchase order specific records sorted by action date

Report header vendor name, vendor#, purchase order number

Partial payment page header action date, req date, part pay date, Po close date, description and amount

Partial payment footer =Sum([Amt])

Report footer =Sum([Amt])

req date = credit
action date = credits or debits
close date = sum