Stock Overview

[Former Member]

hi friends,

i want to get the stock report at particular point of date.

in MBBS report we can get the report for current date.

but i need the report that display the stock for past dates also

which tables i have to refer and how can i get the data.

thanks & regards,

srinivas

[Former Member]

Hi Srinivas,

Try

Batch Stocks - MCHB

Special Stocks from Vendor - MKOL

Sales Order Stock Valuation - EBEW

Project Stock Valuation -QBEW

Valuated Stock with Subcontractor - OBEW

Edited by: Raj on May 5, 2008 6:42 PM

[Former Member]

HI,

Get either opening /Closing balance depending on you need the stock on which date. If the date is close to the end of the month date then get the closing balance as of month end date otherwise get the o/p balance as of 1st of that month by using the tables MBEW/MBEWH. i.e. if you want to know the stock position say as of 05/04/2008 then pickup the o/p balance as of 01/04/2008 but if you need the stoch say as of 20/04/2008 pickup the balance as of 30/04/2008. If you use the o/p balance then get all the transactions from MKPf/MSEG for the period between 01/04/2008 & 04/04/2008 & add/subtract Qty's of all those transactions. Igf you start with the balance as of 30/04/2008 then reverse all transactions between 30/04/2008 & 20/04/2008 to arrive at the balanace as of 20/04/2008. I hope this helps,

Regards

Raju Chitale