How to get the ending inventory

[#1]

Hi,

I have a problem in getting the ending inventory report could you pleas help me on what to do. See below sample for reference.

BWART as MovementType,
if(BWART = '561', 'BegBal') as Beg_Balance,
if(BWART = '562', 'BegBalReversal') as Beg_Bal_Reversal,
if(BWART = '351', 'GoodIssuePlant') as Good_Issue_Plant,
if(BWART = '301', 'GoodsIssue') as Goods_Issue,
if(BWART = '302', 'GIReversal') as GI_Reversal,
if(BWART = '901', 'GIStockTrfPlant') as GI_Transfer_Plant,
if(BWART = '902', 'GIStockTrfPlantReversal') as GI_TPlant_Reversal,
if(BWART = '101', 'GoodsReceipt') as Goods_Receipt,
if(BWART = '102', 'GRReversal') as GR_Reversal,
if(BWART = '951', 'Sales') as Sales,

MENGE as QTY,
if(BWART = '561', MENGE, 0) as BegInv,
if(BWART = '101', MENGE, if(BWART = '302', MENGE, 0)) as Receipt,
if(BWART = '351', MENGE, if(BWART = '301', MENGE,
if(BWART = '901', MENGE, if(BWART = '102', MENGE,
if(BWART = '951', MENGE, 0))))) as Issuance,

This will be the correct output for Summary Report :
BegInventroy Receipt Issuance EndInventory

5 2 2 5
10 6 4 12
20 10 10 20

Thanks,

Jhon

[suniljain]

Thanks Lot to giving me opportunity to solve

[#3]

HI Sunil,

Need Some help..

Can you check this link

Stock Aging buckets ?

Regards,

Helen

[vikasmahajan]

PFA sample hope this may help you

vikas

[#5]

HI Vikas,

http://community.qlik.com/thread/136422

Could you please gonthrough the Link ?

Regards,

Helen