Stock Report as on any date.

[Former Member]

i am developing a stock report as on any date where i have to get the closing stock of unrestricted blocked and transit stock as on any date.

i have taken a table mkpf and mseg to get the quantity and date.

i am not getting what all movement type i should use to get the closing stock for unrestricted blocked and transit and what method i shoud use?

please help me out.

[Former Member]

Hi,

In BSEG table there is a field name BWART.This field will give the movement type also.

Thanks,

shyla

[Former Member]

hi

i have taken all the movement type from mseg-bwart.

i am un able to segregate it like what is used for unrestricted or blocked or transit.

some movement type is used for all these three as well as for quality inspection stock also. this is the basic problem?

thanks.

jairaj

[Former Member]

hello

u can use table mard.Wer all data regarding stock is available.

Regards

shibino

[Former Member]

Jairaj Kumar ,

Your Report is Little bit complex and time consuming as well.We did a Report same as like you but not Special Stock (means for all of Stock).

For Closing Balance Which will be Opening Balance of next perio/ next day , can be calculated based on DEBIT / Credit inidcator available in the table you are using. This will used of calculate Stock balance. along with movement type for date range.

Hope this will give some info about for ur requirement. Note refer to Tcode MB5L for reference.