Skip to Content
-1

SAP BPC Script for CashFlow to reverse the result of 1 Company

Nov 20, 2017 at 06:53 AM

27

avatar image
Former Member

Hi Experts,

I have current script on Cashflow, but for consolidated cashflow, i need to reverse the result of 1 (one) company, that one company only used for elimination but i need to include that company into ownership and declare some percentage.

here is my existing script. (need to insert another line to reverse the result of 1 company or make it zero )

//Consolidation movements *RUN_PROGRAM CALC_ACCOUNT CATEGORY = %CATEGORY_SET% //GROUPS = %SCOPE_SET% CURRENCY = %CURRENCY_SET% TID_RA = %TIME_SET% CALC = CYNI OTHER = [COMPANY = %COMPANY_SET%] *ENDRUN_PROGRAM

//Consolidation movements *RUN_PROGRAM CALC_ACCOUNT CATEGORY = %CATEGORY_SET% GROUPS = %SCOPE_SET% CURRENCY = %CURRENCY_SET% TID_RA = %TIME_SET% CALC = CONSMVTS OTHER = [COMPANY = %COMPANY_SET%] *ENDRUN_PROGRAM

//Net variance and net movement calculation *RUN_PROGRAM CALC_ACCOUNT CATEGORY = %CATEGORY_SET% GROUPS = %SCOPE_SET% CURRENCY = %CURRENCY_SET% TID_RA = %TIME_SET% CALC = CMVTS OTHER = [COMPANY = %COMPANY_SET%] *ENDRUN_PROGRAM

//Cashflow calculation *RUN_PROGRAM CALC_ACCOUNT CATEGORY = %CATEGORY_SET% GROUPS = %SCOPE_SET% CURRENCY = %CURRENCY_SET% TID_RA = %TIME_SET% CALC = CF_FINAL OTHER = [COMPANY = %COMPANY_SET%] *ENDRUN_PROGRAM

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Nov 20, 2017 at 02:37 PM
0

First don't post script text without proper line breaks. The text is unreadable.

Second requirements are absolutely nor clear.

Share
10 |10000 characters needed characters left characters exceeded