problem is that we need to extract all Invoices those payments are not received yet i mean if customer have 4 invoices and invoices data is

in other word we need to extract recovery data

TransectionID,CustomerID,Date,DebitAmount,CreditAm ount
1, 1,1/1/2009, 24,000,0
2, 1,4/1/2009, 22,000,0
3, 1,4/1/2009, 16,000,0
4, 1,4/1/2009, 36,000,0
4, 1,4/1/2009, 0, 50000

and Customer Deposit only 50000

then data show only those Invoices with out 50000 Recovered Amount in FIFO

mean

TransectionID,CustomerID,Date,DebitAmount,CreditAm ount, RecoveryBalance


3, 1,4/1/2009, 12,000,0
4, 1,4/1/2009, 36,000,0

Please give us fruitful guide line