on ‎2017 Nov 20 6:53 AM
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
Request clarification before answering.
First don't post script text without proper line breaks. The text is unreadable.
Second requirements are absolutely nor clear.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 40 | |
| 9 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.