Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 50
2.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)=65
6.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
Hi,
any news about this question?
I have the same problem and it would be nice to know how to solve it.
Regards
Antonio
Rob replied in another thread:
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?
Regards
Antonio