Stock Inventory Ageing

[#1]

Hello Folk

I am having an Adhoc requirement  of Client where Client want to see Quantity wise inventory,

For Example we have an following Data

Data:

SL_BAL_QTY_BU	SL_DT	SL_ITEM_CODE	SL_RCVD_ISSD	Ageing
100	10/3/2011	1	I	2-3 Year
100	10/3/2011	1	R	2-3 Year
30	12/27/2011	1	I	2-3 Year
70	12/27/2011	1	I	2-3 Year
100	12/27/2011	1	R	2-3 Year
100	4/30/2012	1	R	2-3 Year
100	5/12/2012	1	I	2-3 Year
100	6/19/2012	1	I	2-3 Year
200	6/19/2012	1	R	2-3 Year
200	3/8/2013	1	R	1-2 Year

in the above given data I is Sold and R is Received on the basis of this Flag Purchase and sold is to be determine.

using the above data Client want to see bucket wise ageing Such As

Bucket	1-2 Years	2-3 Year
Code
1	300	100

I had tried my level best but not able to find any Solution for this,

m also attaching the working and the Excel sheet & QVW file of my working with this post.

Thanks.

[Anonymous]

Try:

Sum({<SL_RCVD_ISSD = {'R'} >} SL_BAL_QTY_BU) - Sum({<SL_RCVD_ISSD = {'I'} >} SL_BAL_QTY_BU)

[#3]

Hey Kim,

The above given Expression gives result but it dont give the desired result since, using above expression in 2-3 year bucket it shows 100 and 1-2 year bucket it shows 200,

but client requirement is the old bucket Quantity should also be carried forward in a newer bucket.

Thanx

[PrashantSangle]

Hi,

Then try with nullifying Bucket field in expression.

try Like,

Sum({<SL_RCVD_ISSD = {'R'},Ageing= >} SL_BAL_QTY_BU) - Sum({<SL_RCVD_ISSD = {'I'} ,Aging=>} SL_BAL_QTY_BU)

Regards

[#5]

Hi max Its too not working

[Anonymous]

Vini, this should work (see attached app):

Sum({<Flag = {'R'} >} Quantity) - Sum({<Flag = {'I'} >} Quantity) + after(Sum({<Flag = {'R'} >} Quantity) - Sum({<Flag = {'I'} >} Quantity))