Account Based-Calculation

[Former Member]

Hi All,

The Account Based-Calculation in the business rule is too basic.

There is no column for Entity, Interco, or any other customized dimension. How do I create a more complex reclassification?

For example, if I want to reclass a value of GL account to another GL account which only applicable for certain entity and interco?

Thanks in advance.

[former_member186338 · Accepted solution]

If you look on the help: Account-based Calculations as Script Logic - SAP Business Planning and Consolidation, version for SA...

You will see the sample script with:

RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

CURRENCY = %CURRENCY_SET%

TID_RA = %TIME_SET%

CALC=A

OTHER = [ENTITY=%ENTITY_SET%]// or OTHER=[ENTITY=C1000] or [ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%...]

*ENDRUN_PROGRAM

In OTHER you have to use real dimensions names!

Vadim

[Former Member · Accepted solution]

so if I have :

Entity A  => Business Rule1 => Logic script A1

Entity B => Business Rule2 => Logic script 2B

each scoping will have it owns business rule and it's own logic script(which call the business rule), and it's own data package... Is my understanding correct?

[former_member186338 · Accepted solution]

Looks a bit theoretical...

But if you want to have different calculations for different entities you can even combine multiple *RUN_PROGRAM CALC_ACCOUNT with different OTHER=  in a single script.

*RUN_PROGRAM CALC_ACCOUNT

...

CALC=A1

OTHER=[ENTITY=A]

*ENDRUN_PROGRAM

*RUN_PROGRAM CALC_ACCOUNT

...

CALC=A2

OTHER=[ENTITY=B]

*ENDRUN_PROGRAM

Vadim

[Former Member]

Hi,

At present there is no complex reclassification functionality available in BPC. The script logic procedure is a best option.The account based calculation is very useful in cases where the source system does not contain those values such as ECC or you need some quick realignment of data.It's a straight summarization of group of accounts, it simply reads and aggregates the values and posted to specific combination of accounts.

For complex scenario of reclassification logic script is the best solution.

Khokan

.

[Former Member]

Hi U-one,

For example, if I want to reclass a value of GL account to another GL account which only applicable for certain entity and interco?

--> You can use Account Based-Calculation business rule as normal, and simply add XDIM_MEMBERSET to limit the data region you want to run for this rule. For example:

================================

XDIM_MEMBERSET ENTITY=AAA

XDIM_MEMBERSET INTERCO=BBB

*RUN_PROGRAM CALC_ACCOUNT

.........................

*END_PROGRAM

============================

Best Regards,
Arjen

[former_member186338]

Hi Arjen,

Not sure that scoping the region before *RUN_PROGRAM CALC_ACCOUNT will have any effect on *RUN_PROGRAM execution...

Vadim

[Former Member]

Hi,

use script logic.

BR,

Arnold