Skip to Content
0
Dec 24, 2018 at 07:24 AM

Month wise Opening Stock and Closing Stock in SAP BPC 10.0 NW Calculation

218 Views

Hi

We have two GLs S60040-Opening Stock and S60041- Closing Stock. We want to copy month-wise closing stock of previous month to opening stock of next month.

TIMES dimension is in following format:

I am unsure whether member formula will be a correct approach or writing a Business Rule ?

I tried using PREVMEM property of TIMES dimension but was unable to fetch the data of S60041 in subsequent month at S60040.

Please suggest how should I go ahead with the solution.

Regards,

Neha.

Attachments

apl-times.png (51.5 kB)