Discussion Board for collaboration related to QlikView App Development.
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
Product Id, Qty, Sale Posting date.
P1. 5 2/2/2015
P1. 3 3/2/2015.
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.
Please check if attached file is useful for you
didn't get ur attachment
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.