How to find fifo order ?

[mahichowdary]

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

[MK_QSL]

Can you explain the logic of fifo you have used ?

Where you got Rec ID and Pay ID?

[mahichowdary]

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...

[mahichowdary]

it is an interview purpose..plz let me..

[MK_QSL]

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.

[mahichowdary]

k sure...i will do it ....

Thank you so much  for replying...