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
Add comment