How to Get closing stock for Historical data without loading Movements?

[vaibhav_chikhale]

Dear Experts,

We are working on Inventory management scenario in BW 7.5.

In our case client is expecting last two year's data (closing stock) and is allowing to load last two year's movements only as they are having 15 years of inventory by now.

So, if I do a stock initialization today and load the delta from today on-wards, I will be able to get closing stock, but how to get historical closing stock without loading all movements?

Thanks in advance !!

[giselle_lin · Accepted solution]

Hi Vaibhav,

With open stock today, then load history movement of last two years, the closing stock of each day in last two years can be calculated out backwards. Read how inventory query works in KBA 1548125

More info on this topic is at: https://wiki.scn.sap.com/wiki/x/BIFdEg

[rahul_panchal · Accepted solution]

Hello Giselle,

I have similar scenario.

Can you please explain little bit further on this ? How can we calculate stock of any day in last 2 years if we have done stock initialization today and loaded 2 years of historical movements ? Please explain "the closing stock of each day in last two years can be calculated out backwards"

Thanks in Advance