Skip to Content
0
Former Member
Jan 07, 2011 at 12:42 PM

Batch wise stock for a given period or month

1750 Views

Hi,

My company wants to implement stock ageing report in MM.

We manage the stocks in Batches. For us the main criteria for stock ageing is batch creation date.

The report should run stock ageing based upon the date range given as an input screen

For ex : date range in input can be of today or as of 30.06.2010.

If the report is run as of today then I am able to get the batch stock from table MCHB . Quantity from field "CLABS" and the batch creation date from the field "ERSDA"

But if the report to be run as of 30-06-2010. Then I am not able to get the data from MCHBH as of 30.06.2010.

I have checked for one material in the table and as per stock it should be 351 as of 30-06-2010 but in the MCHBH table for the month 06. year 2010 it is showing as 136 pcs only.

As our LIS tables are not getting populated correctly I am not able to check those tables too.

Can any one guide me with the logic or the table where I can get the batch stocks for a particular month.

I need Material, Batch, Quantity month and year .

Please advice how can i get the data and from which table.

Thanks you for your support in advance.

Regards

Fazal