Skip to Content
0
Former Member
Jul 01, 2009 at 10:05 AM

Calmonth wise Inventory report issue

31 Views

Hello Gurus,

i have a stock report that has Month selection and it shows Opening.... Issues..... Receipts... Stock transits... and Closing

so if i give 05.2009, then for Opening will be closing of 04.2009 and rest KFs for 05.2009.

I have not directly restricted calmonth , what i did is Opening stock is month variable - 1 (04.2009 here)

and rest Kf is = month variable (05.2009 here )

now wen i drill to calmonth in report , table shows 2 months

but it should show only 05.2009 and all KFs under it.

Right now its the showing the following output

Calmonth	Plant	Material Batch	Opening	Receipts  Issue  Stock in transit  Closing
04.2009	1001	20277	0000	7,800 PC				
			--------0201	1 PC				
			--------0401	6,428 PC				
05.2009	1001	20277	0000		17 PC	17 PC	7,800 PC    	  7,800 PC
			--------0201		16 PC	16 PC	1 PC	               1 PC
			--------0401		16 PC	16 PC	6,428 PC  	   6,428 PC


Thanks and regards

Sonal....