Is it possible FIFO in QlikView

[#1]

Hi All,

Wishes from Jai.I am having critical scenario this time.It is based on FIFO report which based on Inventory system.

Thing is,

1.On March 1st warehouse received 6 Items at the rate of 10.So total Price 60

2.On March 3rd warehouse received 5 Items at the rate of 5,So total price 25.

3.On March 5th warehouse got order to sell 8 items.

4.Now QlikView has to generate the report like, First 6 Items at the rate of 10 and remaining 2 items at the rate of 5.

5.So total Selling price should be (6*10)+(2*5)=70

6.If you have same kind of QVW then please share with me.

Thanks & Regards

Jai

[rwunderlich]

Attached is an example I created a couple years ago for a FIFO Stock scenario. It may give you some ideas.

-Rob

[#3]

Hi Rob,

This Example is working for limted transactions.. If there are more no.of Purchase & Solds are happened..

Then which Logic have to be used ...

Help me Please...

Regards,

Helen

[piotr-bratek]

Hi Rob,

your solution is great to track balances. Yet, I'm looking for the best way do one more thing - to calculate profit you make on each Sales Trn. In other words I somehow need to link Sales Transactions with relevant Purchase Transactions based on FIFO rule and partial reductions for each transaction bucket as presented below. Any idea?

Just in case I attach the XLS presented above.

Any idea