Stock ageing

mazacini — Thu, 11 Oct 2012 11:12:51 GMT

I have a stocktake file showing quantity in stock per item:

Item	StockQty
A	5
B	10
C	7

I have a file of Stock Received showing quantity received by date for each item

Date	Item	Ref	QtyIn
03-Jan	A	5497	3
05-Feb	A	5346	2
31-Mar	A	5386	2
05-Mar	B	5029	3
12-Apr	B	5442	5
15-May	B	5289	7
12-Feb	C	5401	3
08-Mar	C	5334	1
09-Apr	C	5267	5

I want to age the items in stock in the stocktake file by listing the Stock Received trasnactions that make up thw stocktake quantity ie by making a new table like so:

Date	Item	Ref	QtyIn
03-Jan	A	5497	1
05-Feb	A	5346	2
31-Mar	A	5386	2
12-Apr	B	5442	3
15-May	B	5289	7
12-Feb	C	5401	1
08-Mar	C	5334	1
09-Apr	C	5267	5

So, the stocktake quantity for A is made up of the full receipt on 31-Mar and 05-Feb, and 1 of the quantity of 3 received 03-Jan.

Re: Stock ageing

Sat, 06 Dec 2014 20:17:04 GMT

Share answer of this problem

topic Stock ageing in QlikView

Stock ageing

Re: Stock ageing