Skip to Content
0
Jul 23, 2020 at 08:11 AM

What is the best approach to Calculate Retained Earnings while loading Data from BW to BPC

69 Views

Hi Team,

We are implementing Legal Consolidation on BPC standard 11.1 over B4HANA 2.0.

We are loading data from BW to BPC, and are trying to calculate the Retained Earnings using the default logic at the time of Data Load. The script is as below:

// Net Income ---> Current Year Retained Earnings

*XDIM_MEMBERSET GL_ACCOUNT_CONS = BAS(INCOME_STATEMENT)

*WHEN GL_ACCOUNT_CONS

*IS BAS(INCOME_STATEMENT)

*WHEN GL_ACCOUNT_CONS.ACCTYPE

*IS INC

*REC(FACTOR = 1, GL_ACCOUNT_CONS = 302000) //302000 is the Current Year Retained Earnings

*REC(FACTOR = 1, GL_ACCOUNT_CONS = 302000, FLOW_CONS = 999) // 999 is closing flow

*IS EXP

*REC(FACTOR = -1, GL_ACCOUNT_CONS = 302000) //302000 is the Current Year Retained Earnings

*REC(FACTOR = -1, GL_ACCOUNT_CONS = 302000, FLOW_CONS = 999) // 999 is closing flow

*ENDWHEN

*ENDWHEN

The above Default Logic script works perfect when we save data via input schedule or post any journals. However during data load from BW to BPC, Retained Earning is not getting calculated correctly.

Should we be running Retained Earning Calculation after Data Load has happened, or do we fix anything in script?

Kindly suggest.

Regards,
SHUBHAM