Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi can anyone help me
i have a table like below
type id date amount
rec 1 1/4/2015 5000
rec 2 1/5/2015 6000
pay 1 1/6/2015 2000
rec 3 1/7/2015 1000
pay 2 1/8/2015 8000
i need o/p like this
recID pay ID amount
1 1 2000
1 2 3000
2 2 5000
Whatever you are explaining, can you provide this in figure... Like...
5000 - 2000 = 3000
3000 + 6000 - 8000 = 1000 etc..
Don't write in words.. It's difficult to understand. Provide by calculation.. I will work on this for you..!
@
i have attached my file kindly have a look
But Calculation is Missing... !
(1) rec id 5000 but payment is 2000 for same id (1) but here remainder is 3000 think ur still in( tran 1) thats y
recid payid amount
1 1 2000
1 2 3000 (remainder)
but in second payment u need to pay 8000 here 3000 is paid by trans 1 so still 5000 should be paid right
recid pay id amount
2 2 5000
2 2 1000 as received am is 6000 but 5000 already present so remainder is 1000 for the same transaction like wise it shold follow the loop