Rules

Currency conversion rules are created automatically and should only be changed through Designer.

To automatically create currency conversion rules, select Infor Budgeting and Planning > Configuration > Planning Settings. On the Common Settings tab, click the Browse button of the Currency Conversion field. You can select one of these options:

  • Create rules for the currency conversion
    Note: Rules were redesigned in the 11.0 release. After updating, verify all settings and recreate any custom rules.
  • Create rules for no currency conversion

Depending on the chosen option, two different rule sets for currency conversation are created.

If you select Create rules for the currency conversion, this message is shown: 

Changing the type of the currency conversion will recreate all system currency conversion rules. All rules under the main currency conversion folder will be deleted and recreated. Do you really want to recreate the rules?

To activate the currency conversion, click Yes. A message shows that the currency conversion rules were recreated successfully. Click OK.

To check the created rules, select System > Rules in the Designer tree.

This table lists active currency conversion rules for the BPCMAIN, CFCCASHFLOW, and WBCMAIN cubes:

Name Cube Description
BPCMAIN_ADVANCED_CURRENCY_CONVERSION BPCMAIN All system internal currency conversion rules.
BPCMAIN_ ADVANCED_CURRENCY_CONVERSION_EUR BPCMAIN System rule for currency EUR.
BPCMAIN_ADVANCED_CURRENCY_CONVERSION_GBP BPCMAIN System rule for currency GBP.
BPCMAIN_ADVANCED_CURRENCY_CONVERSION_JPY BPCMAIN System rule for currency JPY.
BPCMAIN_ADVANCED_CURRENCY_CONVERSION_USD BPCMAIN System rule for currency USD.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION CFCCASHFLOW All system internal currency conversion rules.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION_EUR CFCCASHFLOW System rule for currency EUR.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION_GBP CFCCASHFLOW System rule for currency GBP.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION_JPY CFCCASHFLOW System rule for currency JPY.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION_USD CFCCASHFLOW System rule for currency USD.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION WBCMAIN All system internal currency conversion rules.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION_EUR WBCMAIN System rule for currency EUR.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION_GBP WBCMAIN System rule for currency GBP.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION_JPY WBCMAIN System rule for currency JPY.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION_USD WBCMAIN System rule for currency USD.
This table lists the currency conversion rules in ACTUAL_CONS for the BPCMAIN, CFCCASHFLOW, and WBCMAIN cubes:
Name Cube Description
BPCMAIN_ADVANCED_CURRENCY_CONVERSION BPCMAIN All system internal currency conversion rules.
BPCMAIN_ ADVANCED_CURRENCY_CONVERSION_EUR_ACTUAL_CONS BPCMAIN System rule for currency EUR.
BPCMAIN_ADVANCED_CURRENCY_CONVERSION_GBP_ACTUAL_CONS BPCMAIN System rule for currency GBP.
BPCMAIN_ADVANCED_CURRENCY_CONVERSION_JPY_ACTUAL_CONS BPCMAIN System rule for currency JPY.
BPCMAIN_ADVANCED_CURRENCY_CONVERSION_USD_ACTUAL_CONS BPCMAIN System rule for currency USD.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION CFCCASHFLOW All system internal currency conversion rules.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION_EUR_ACTUAL_CONS CFCCASHFLOW System rule for currency EUR.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION_GBP_ACTUAL_CONS CFCCASHFLOW System rule for currency GBP.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION_JPY _ACTUAL_CONS CFCCASHFLOW System rule for currency JPY.
CFCCASHFLOW_ADVANCED_CURRENCY_CONVERSION_USD_ACTUAL_CONS CFCCASHFLOW System rule for currency USD.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION WBCMAIN All system internal currency conversion rules.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION_EUR_ACTUAL_CONS WBCMAIN System rule for currency EUR.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION_GBP_ACTUAL_CONS WBCMAIN System rule for currency GBP.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION_JPY_ACTUAL_CONS WBCMAIN System rule for currency JPY.
WBCMAIN_ADVANCED_CURRENCY_CONVERSION_USD_ACTUAL_CONS WBCMAIN System rule for currency USD.

You can add to customize your application. The rules must be added to the table manually.

This table lists the rules for the allocation calculation on the BPCMAIN, CFCCASHFLOW, and WBCMAIN cubes. As the basis for the allocation calculation, the input value is transferred as is (the TOTAL_INPUT element is weighted at 0).

Name Cube Description
BPCMAIN_ALLOCATION BPCMAIN All allocation rules.
BPDLEVEL:TOTAL_INPUT_ALLOCATION BPCMAIN Copies TOTAL_INPUT values to TOTAL_INPUT_ALLOCATION
BPDLEVEL:TOTAL_INPUT_ALLOCATION_DP BPCMAIN Copies TOTAL_INPUT values to TOTAL_INPUT_ALLOCATION_DP
CFCCASHFLOW_ALLOCATION CFCCASHFLOW All allocation rules.
CFCCASHFLOW _BPDLEVEL_COPY_INPUT_TO_ALLOCATION CFCCASHFLOW Copies TOTAL_INPUT values to TOTAL_INPUT_ALLOCATION
CFCCASHFLOW _BPDLEVEL_COPY_INPUT_TO_ALLOCATION_DP CFCCASHFLOW Copies TOTAL_INPUT values to TOTAL_INPUT_ALLOCATION_DP
WBCMAIN_ALLOCATION WBCMAIN All allocation rules.
WBCMAIN_BPDLEVEL_COPY_INPUT_TO_ALLOCATION_DP WBCMAIN Copies TOTAL_INPUT values to TOTAL_INPUT_ALLOCATION_D
WBCMAIN_BPDLEVEL_COPY_INPUT_TO_ALLOCATION WBCMAIN Copies TOTAL_INPUT values to TOTAL_INPUT_ALLOCATION

This table lists the rules that handle currency differences on the CFCCASHFLOW cube for configured accounts:

Name Cube Description
CFCCASHFLOW_CURRENCY_DIFFERENCES CFCCASHFLOW All system internal currency differences rules.
CFCCASHFLOW_CURRENCY_DIFFERENCES_EUR CFCCASHFLOW System rule for the currency differences EUR.
CFCCASHFLOW_CURRENCY_DIFFERENCES_GBP CFCCASHFLOW System rule for the currency differences GBP.
CFCCASHFLOW_CURRENCY_DIFFERENCES_JPY CFCCASHFLOW System rule for the currency differences JPY.
CFCCASHFLOW_CURRENCY_DIFFERENCES_USD CFCCASHFLOW System rule for the currency differences USD.

This table lists the rules for opening balance calculations:

Name Cube Description
BPCMAIN_REMOVE_PL_FROM_CALCULATION BPCMAIN Removes P&L account from the opening balance calculation
BPCMAIN_CALCULATION_OF_RETAINED_EARNINGS BPCMAIN Calculates retained earnings
BPCMAIN_OPENING_BALANCE BPCMAIN Opening balance rule

This table lists the files for global sign (GSCSIGNDEFINITION):

Name Cube Description
GLOBAL_SIGN_CONFIG_RULES GSCSIGNDEFINITION System rule for global sign definitions
GLOBAL_SIGN_CONFIG_MULTIPLICATOR GSCSIGNDEFINITION System rule for OLAP enhancements for calculation of multiplier