BPC10.1 Copy Opening best practice for Historical data

[Former Member]

Hi Experts

As per my observation, If I load data monthly basis and executed package "Copy Opening Balance" or

/CPMB/OPENING_BALANCES then it calculates CORRECT opening balance of each GL and assigned Flow F00 to it.

If I load data yearly basis and executed package "Copy Opening Balance" then it calculates INCORRECT opening balance of each GL and assigned Flow F00 to it. Why??

If I need to load 15 year of historical data from BW how can I calculate correct opening balances month wise of each GL and assigned Flow F00 to it ??

Waiting for helpful reply.

Regards

ISKhan

[former_member186338]

The word "INCORRECT" looks very unprofessional... You have to describe all details.

[Former Member]

Thanks for highlighting my unprofessional word.

When I run copy opening month wise it sums F00, F99 & other movement flows for last month and store the value to F00 of next month which is correct.

When I run copy opening year wise it sums F00, F99 only for last month and store the value to F00 of next month which is incorrect.

Business Rule and Script Logic of Copy Opening as shown below:

[former_member186338]

You have to use FOR/NEXT in the script with variable iterating months... Easy!