Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Opening And Closing Stock

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


Former Member
Former Member replied

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.     

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question