Stock Aging buckets ?

[#1]

Hi All,

I have attached EXcel file With 5 Fields..

SL_BAL_QTY_BU

SL_COST_1 ,

SL_DT,

SL_ITEM_CODE,

SL_RCVD_ISSD

I want to get Stock QTY, Based on SL_RCVD_ISSD (Received- Issued) ==  Stock Quantity

For Stock Value, Stock QTY * SL_COST_1  (Cost of Item is noth but Last Received of Goods,(SL_RCVD_ISSD ='R'))

Total STock QTY, STock Value to distributed on on Buckets (0-3 Months, 3-6 Months,6-9 Months, 9-12 Months,1-2 Years,2-3 Years,3-4 Years,>4 Years) ...

Stock QTY Should work on Purchase Date(SL_RCVD_ISSD ='R')

Attached are the Data SOurce, Sample Out put ,Sample qvw file...Please let me Know...

Regards,

Helen

[jyothish8807]

Hi Helen,

For buckiting the data into months you can use class function it may help you.

class([Year],2)

Regards

KC