Stock Ageing Report in FIFO manner. - Qlik Community

rahulsud007 · ‎2015-04-23

Hi All,

I have a problem in creating a Stock Aging. I have three files named Old, New and Sale.

I need to create an Aging report in the form of FIFO (First in First Out)

Old file has data till 2014, while new has the data from the current year till date.

Old file. New File

Product Id, Qty, Posting date. Product ID, Qty, Posting date

P1. 10 20/5/2014 P1. 10 2/1/2015

P1. 5 23/6/2014 P1. 10 4/2/2015

P2. 5 23/6/2014 P2. 20 1/3/2015

Sale.

Product Id, Qty, Sale Posting date.

P1. 5 2/2/2015

P1. 3 3/2/2015.

Output

Product Id, (Remaining)Qty, Posting date. Sale Posting date

P1. 5 20/5/2014 2/2/2015

P1 2 20/5/2015 3/2/2015

That is in sale if the quantity is 10, then in the remaining quantity field it should be P1 0 20/5/2014 Sales Posting date.

Regards

Rahul.S

vikasmahajan · ‎2015-04-23

Hii

Please check if attached file is useful for you

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

rahulsud007 · ‎2015-04-23

Hi Vikas,

didn't get ur attachment

regards

vikasmahajan · ‎2015-04-23

PFA

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

rahulsud007 · ‎2015-04-23

Hi Vikas,

Thanks for your quick reply. But this was not I wanted.

Actually I need a table which shows deduction of those data which came into inventory first.

Suppose stock has entered in JAN, FEB, Mar.

the stock of Jan should cleared first, then of feb and then of March.