Cash Flow & Inter Profit Centre Elimination

[Former Member]

Hello Experts

I want to create a Cash Flow in SAP BPC NW 10. Which method is best.

Account Based Calculation Business Rule 

     or

Scripti Logic

Second Part of my question is.

My condolidation model is able to run Intercompany Elimination. Is it possible in BPC do  inter profit centre elimination & reporting , or I need to create another model  replacing entity model with profit centre?

Looking to hear from you.

Kind regards

Abraham Thomas

[Former Member · Accepted solution]

Hi Abraham,

The cash flow generation can be done using either business rule or script logic. The script logic might become long; since you are going to post data to the different cash flow accounts based on the data in the different P&L or BS accounts. It is basically a copying data from one place to another with some data massaging. On the other hand business rule becomes easier to be created and maintained; since its a tabular structure, and it will be easier to understand the BR in the future, as well.

Coming to the intercompany eliminations, the adjustment BR uses the entity type of dimension, and you need to have the profit centers as entity type of dimension.

Hope this helps.

[Former Member · Accepted solution]

Hi Nilanjan

Thanks for your answers.

I was in a dilemma to use script logic considering the volume of
adjustments. From your reply I consider BR will be the best option.

To my second part of the question I have already Entity
Dimension replicating the Legal structure of the Group Company, where
intercompany elimination is configured. Profit centre is and additional dimension
in the model (which can only be U type dimension), in that case how can we
reflect in the inter profit centre elimination.

Also one profit centre may share with many entities

Hope you understand my question.

Abraham

[Former Member · Accepted solution]

Hi Abraham,

In the same model, you cannot eliminate based on 2 different dimensions. You can have the PC elimination in a separate model, and then send the data back to the main model.

Hope this helps.

[Former Member]

Hi,

The account based calculation rules are best used for the cash flow statement. It contains all the source and target dimensions required i.e. account, flow, datasource. And is easier to view than reading script logic.

Please expand on your requirement for intercompany elimination by profit centres. If you require profit centre for reporting in your consolidation model - you can add this dimension in addition to your entity in the consolidation model. Any entity based intercompany eliminations will also populate the profit centre field - hence you can use profit centre breakdown for reporting consolidated results.

Linda

[Former Member]

Hi Linda

Thanks for your answers.

I was in a dilemma to use script logic considering the volume of
adjustments. From your reply I consider BR will be the best option.

To my second part of the question I have already Entity
Dimension replicating the Legal structure of the Group Company, where
intercompany elimination is configured. Profit centre is and additional dimension
in the model (which can only be U type dimension), in that case how can we
reflect in the inter profit centre elimination.

Also one profit centre may share with many entities

Hope you understand my question.

Abraham