Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need Small help from you.
This is my Requirement.
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 |
In Above table i want to fifo order in Script level.
this is my output:
Rec ID | Pay ID | Amount |
1 | 1 | 2000 |
1 | 2 | 3000 |
2 | 2 | 5000 |
How to solve this problem.very urgent..
Waiting for u Answer..
Thanks
Mahendra
Can you explain the logic of fifo you have used ?
Where you got Rec ID and Pay ID?
Hi Manish,
Actually i have to rec amount 5000 but i have pay amount 2000, remaining 3000 is there.In Pay and rec as same id=1 and comes to pay id=2 in 8000 is there.it will pay 3000 in same rec id=1 but remaining amount is 5000 is there .here rec id =1 is complete.then come to rec id=2 under rec id=2 in amount is 6000 but i have to pay only 5000 in pay id=2,remaining 1000 is remainder.and so on...
it is an interview purpose..plz let me..
But what you explained is not matching with your output !
Can you try yourself in excel to get the same output and please attach excel file here.
k sure...i will do it ....
Thank you so much for replying...