Showing results for 
Search instead for 
Did you mean: 

BPC Consolidation Data Load issue

0 Kudos


I have loaded Data in BI for BPC Consolidation. 0BALANCE field contains cumulative data. However for Balance sheet Accounts all the balance is getting loaded to flow F99 in BPC which is closing balance. Previous period balances are carried forward in this period at Opening balances to Flow F00. Any other Assets Transactions like Acquisition Retirement etc., are getting loaded in BPC with respective Flows like F25, F35 etc.

My Flow Dimension has all the flows in the hierarchy END of period Movements but F99 is out of the hierarchy.

Consider Account XXXXX which has opening Balance of 13588.51 CAD Flow F00

Closing Balance as                                                               3099.57 CAD Flow F99

However I am checking Balance sheet at the Flow END of period Movements and thus Closing balance is out of the hierarchy. Thus my question is how to load movements for that account as 3099.57 as Credit and 13588.51 as debit so that when I will check balance sheet at End of period movements it will match.

View Entire Topic
Active Contributor
0 Kudos

Hi Ganadhish,

If the movement is not available while pulling the data, then I think it is not possible. There are various gls like debtors, creditors, etc where the movement are not available in BI,and so you will not movement of these gls in BPC