Discussion Board for collaboration related to QlikView App Development.
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 5 Items at the rate of 10.So total Price 502.On March 3rd warehouse received 6 Items at the rate of 5,So total price 30.3.On March 5th warehouse got order to sell 8 items.4.Now QlikView has to generate the report like, First 5 Items at the rate of 10 and remaining 2 items at the rate of 5.5.So total Selling price should be (5*10)+(3*5)=656.If you have same kind of QVW then please share with me.
7.For more clarity here with I have atatched my qvw.
Thanks & Regards Jai
any news about this question?
I have the same problem and it would be nice to know how to solve it.
Rob replied in another thread:
Is it possible FIFO in QlikView
I see, but it still doesn't answer to the question: data are grouped by purchase rows and costs are not reflected on the sell rows.
Any other ideas?