Opening And Closing Stock
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
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.