Opening And Closing Stock

[Former Member]

Hi All,

          I have installed inventory cube and reports and filled the data in cube now in standard reports i can't find opening stock and closing stock in any report.

1) is there any standard report for closing and opening stock ?

2) we have to create custom report for closing and opening then please give in detail(on which key figure we have to restrict and on which date we have to restrict and what are the variables we have to create and restrict).

3) formula for closing and opening of stock.(detail level).

4) my requirement is to show BI reports as similar as (MB5B).

thanks in advance

praveen

[anshu_lilhori · Accepted solution]

Hi,

Check this out:

http://help.sap.com/saphelp_nw04/helpdata/en/5b/8dc73cee4fb55be10000000a114084/frameset.htm

Hope that helps.

Regards,

AL

[Former Member · Accepted solution]

HI All,

         i know MB5B and MB52 Tcode in ECC. But How Will you create Opening And Closing Stock in SAP BI.

And If you have any useful links please provide. the above is not useful for my scenario.

Thanks in Advance.

Praveen.

[anshu_lilhori · Accepted solution]

Hi,

For opening stock the formula should--

(0totalstck + 0ISSTOTSTCK - 0RECTOTSTCK)

For closing stock

0totalstck

thats how we have calculated in my system.

Hope this helps.

Regards,

AL

[Former Member · Accepted solution]

Create a local formula for opening stock.

opening stock = quantity total stock + issue total stock - receipt total stock.

                     =  0totalstck +  0isstotstck - 0rectotstck.

closing stock = opening stock + receipt total stock - issue total stock.(0totalstck).

(but in BW it is calculated in extractors there is no need for calculation simply rename it 0totalstck as closing stock.     

[anshu_lilhori · Accepted solution]

what did i suggest..its just a replica of my reply

[biplob_chowdhury15]

Hi,

MB5B will give you day wise, Month wise Opening and closing Stock.

MB52 will give you the current stock.

Thanks,

Biplob