Inconsistency while loading YTD data from YTD model to Periodic model in BPC

[former_member669125]

Hi Team,

We are implementing Planning and Consolidation solution in BPC 11.1 standard system which sits over B4HANA 2.0.

Consolidation model is a YTD model and Planning model is Periodic model. We are pushing Balance Sheet GL Account Balances from Consolidation model to Planning model using Destination App function in Script Logic in Consolidation model. We are expecting that YTD balances should get copied over for all Balance Sheet Items from Consolidation model to Planning model.

However, we find issue for 2 GL Asset accounts as below:

Lets say for both Asset accounts, YTD balance in Consolidation model in Period 4 is 100 and in Period 5 YTD balance is 0. It means that Periodic posting in S4 for Period 5 is -100. As a result, YTD balance is 0 in Consolidation model. When this balance gets pushed to Planning Model, we find that for Period 4 Balances are 100, and for period 5 posting is -100 and not 0. We find this rather odd. As a kind of workaround, we posted 1 cent against those GL Asset Accounts in Consolidation model for Period 5, so that YTD is not 0 but 1 cent for Period 5. Post this, when we push the data from Consolidation model to Planning model, data gets copied over correctly for Period 5 in Planning model.

I am not sure if it is a system bug. Attaching the Script Logic below for clarity:

*SELECT(%CURRENT_PERIOD%,[ID],TIME, CURRENT_PERIOD=Y)		// Time period for pushing data	
*SELECT(%Select_PLAN_YEAR%,[YEAR],TIME,ID = %CURRENT_PERIOD%)	// fiscal year
*XDIM_MEMBERSET TIME = %CURRENT_PERIOD%                         // Time scoping
*XDIM_MEMBERSET DATASRC_CONS = S4				// scoping data Coming from S4
*XDIM_MEMBERSET GL_ACCOUNT_CONS = BAS(BALANCE_SHEET)		// All balance Sheet GL Accounts
*XDIM_MEMBERSET FLOW_CONS = 999					// Closing Flow
*XDIM_MEMBERSET GROUP_CONS = NO_GROUP				// Unconsolidated Data
*XDIM_MEMBERSET VERSION = ACTUAL				// Actuals from S4
*XDIM_MEMBERSET RPTG_CURRENCY = LC, USD				// Both Local Currency and USD
*DESTINATION_APP=FINSTMT					// Planning model: FINSTMT
*SKIP_DIM = CUSTOMER, USER_DEFINED1, USER_DEFINED2, FLOW_CONS, GROUP_CONS, DATASRC_CONS


*ADD_DIM PLAN_YEAR = %Select_PLAN_YEAR%
*ADD_DIM COUNTRY = CUS
*ADD_DIM SCENARIO = NO_SCENARIO
*ADD_DIM PRODUCT = NO_PRODUCT
*ADD_DIM USER_DEFINED3 = NO_USER_DEF3
*ADD_DIM USER_DEFINED4 = NO_USER_DEF4
*ADD_DIM DATASRC_PLAN = S4
*RENAME_DIM GL_ACCOUNT_CONS = GL_ACCOUNT_PLAN //both dimensions have same GL Accounts & same hierarchy
*WHEN TIME
    *IS *
    *REC(EXPRESSION=%VALUE%)
*ENDWHEN