Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Rules

A number of rules are created during setup. These rules provide standard functionality tied to the default hierarchies. Additional rules may be added to the system, but need to conform to the numbering convention in order to avoid possible loss of custom rules during an upgrade.

Rule ID Convention

The rule ID convention is:

  • Rule IDs are seven digits long
  • The first digit indicates the rule type:
    • 1 for validation rules
    • 2 for model rules
    • 3 for rollup rules
    • 4 for model rules
    • 5 for event rules
  • The next digit indicates the time structure the rule applies to:
    • 0 for actual
    • 1 for forecast
    • 2 for budget
    • 3, 4 reserved for future use
    • 5-9 reserved for custom use (to avoid conflicts with future Solutions Framework rules, use this range for the second digit)
  • The next two digits represent the year the rule applies to (normally this applies to query rules only). 00 indicates no specific year, which could be confused with 2000 or 3000, but can be clarified by looking at the time period setting in the actual rule.
  • The next three digits are used to specify the rule number. Different types of rules have specific conventions around these three digits, but in general the last three digits start at 010 and increment by 10.

Event rule convention for last three digits:

  • xx0 is the manual trigger rule
  • xxn is a data trigger rule

Example:

5000010 is the manual trigger rule for actual beginning cash

5000011 is the data trigger rile for actual beginning cash

Event rule merging is used to merge the related rules.

Example:

Rule merging for the rules in the previous example would be configured as:

5000010,5000011

Validation rules

The Solutions Framework contains a number of validation rules tied to the initial hierarchies. Each validation rule targets a specific account under the symbol ACCOUNTS_ValRep

The exact accounts in the system depend on which time structures were selected during setup. The list above represents all time structures being selected. Each symbol is tied to a specific validation rule.

Account

Rule

Description

VR_1000010

1000010

Balance sheet is in balance? (Actual)

VR_1000020

1000020

Ending cash matches cash balance? (Actual)

VR_1000030

1000030

Open retained earnings matches opening balance (Actual)

VR_1000040

1000040

Ending roll forward balance matches trial balance (Actual)?

VR_1000050

1000050

Ending P&L variance matches P&L bridge (Actual)?

VR_1000060

1000060

P&L base variances have been explained (Actual)?

VR_1100010

1100010

Balance sheet is in balance? (Forecast)

VR_1100020

1100020

Ending cash matches cash balance? (Forecast)

VR_1100030

1100030

Open retained earnings matches opening balance (Forecast)

VR_1100050

1100050

Ending P&L variance matches P&L bridge (Forecast)?

VR_1100060

1100060

P&L base variances have been explained (Forecast)?

VR_1200010

1200010

Balance sheet is in balance? (Budget)

VR_1200020

1200020

Ending cash matches cash balance? (Budget)

VR_1200030

1200030

Open retained earnings matches opening balance (Budget)

VR_1200050

1200050

Ending P&L variance matches P&L bridge (Budget)?

VR_1200060

1200060

P&L base variances have been explained (Budget)?

VR_Intercompany

N/A

Any symbol attached to the this structure should be set up to hold validation rule data for a specific intercompany account.

For more information, see “System setup, intercompany validations” in the Solutions Administrator Guide.

Model rules

The Solutions Framework contains a number of model rules tied to the initial hierarchies. The rules added depend on the time structures selected during setup.

Rule

Description

2000010

Ending Cash, Actual

2000020

Ending Roll Forward Balance, Actual

2000030

Working Capital, Actual

2000040

Copy Intercompany Schedule Data, Actual

2000041

Copy Ownership Percentage for Investment Eliminations, Actual

2100010

Ending Cash, Forecast

2100030

Working Capital, Forecast

2200010

Ending Cash, Budget

2200030

Working Capital, Budget

Rollup rules

The Solutions Framework contains a number of rollup rules tied to the initial hierarchies. The rules added depend on the options selected during setup.

Rule

Description

3000010

Prevent Rollup of Balance Sheet to Trailing 12 Months

3000020

Prevent Rollup of Cash Flow to Trailing 12 Months

3400010

Prevent Rollup of Cash Flow to Cash Flow Basis

Query rules

The Solutions Framework contains a number of query rules tied to the initial hierarchies. The rules added depend on the options selected during setup.

Rule

Description

4000010

PA Beginning Cash, Actual

4000011

YTD Beginning Cash, Actual

4000020

PA Beginning Roll Forward Balance, Actual

4000021

YTD Beginning Roll Forward Balance, Actual

4100010

PA Beginning Cash, Forecast

4100011

YTD Beginning Cash, Forecast

4200010

PA Beginning Cash, Budget

4200011

YTD Beginning Cash, Budget

Note: Additional rules will be added as years are added to the system.

Event rules

The Solutions Framework contains a number of event rules tied to the initial hierarchies. Each event ties to a specific symbol for manual triggering, found in the EVENT_TRIGGERS hierarchy under the ACCOUNTS_System root. Each symbol is tied to a specific event rule.

Account

Rule

Description

EVNT_5000010

5000010

Calculate Actual Beginning Cash, Open

5000011

Calculate Actual Beginning Cash, Open (Data Triggered)

EVNT_5000020

5000020

Calculate Actual Beginning Cash

5000021

Calculate Actual Beginning Cash (Data Triggered)

EVNT_5000030

5000030

Calculate Actual Cash Flow Activity

5000031

Calculate Actual Cash Flow Activity (Data Triggered)

5000032

Calculate Actual Roll Forward Cash Flow Activity (Data Triggered)

EVNT_5000050

5000050

Calculate FX Impact on Actual Cash Flow

5000051

Calculate FX Impact on Actual Cash Flow (Data Triggered)

EVNT_5000060

5000060

Calculate Actual Roll Forward Beginning Balance, Open

5000061

Calculate Actual Roll Forward Beginning Balance, Open (Data Triggered)

EVNT_5000070

5000070

Calculate Actual Roll Forward Beginning Balance

5000071

Calculate Actual Roll Forward Beginning Balance (Data Triggered)

EVNT_5000080

5000080

Calculate FX Impact on Actual Roll Forward Balance

5000081

Calculate FX Impact on Actual Roll Forward Balance (Data Triggered)

EVNT_5000090

5000100

Calculate Equity Pickup

5000101

Calculate Equity Pickup (Data Triggered)

EVNT_5100010

5100010

Calculate Forecast Beginning Cash, Open

5100011

Calculate Forecast Beginning Cash, Open (Data Triggered)

EVNT_5100020

5100020

Calculate Forecast Beginning Cash

5100021

Calculate Forecast Beginning Cash (Data Triggered)

EVNT_5100030

5100030

Calculate Forecast Cash Flow Activity

5100031

Calculate Forecast Cash Flow Activity (Data Triggered)

EVNT_5100050

5100050

Calculate FX Impact on Forecast Cash Flow

5100051

Calculate FX Impact on Forecast Cash Flow (Data Triggered)

EVNT_5200010

5200010

Calculate Budget Beginning Cash, Open

5200011

Calculate Budget Beginning Cash, Open (Data Triggered)

EVNT_5200020

5200020

Calculate Budget Beginning Cash

5200021

Calculate Budget Beginning Cash (Data Triggered)

EVNT_5200030

5200030

Calculate Budget Cash Flow Activity

5200031

Calculate Budget Cash Flow Activity (Data Triggered)

EVNT_5200050

5200050

Calculate FX Impact on Budget Cash Flow

5200051

Calculate FX Impact on Budget Cash Flow (Data Triggered)

EVNT_5400000

5400000

Run Allocations - Actuals

5400001

Run Allocations - Forecast

5400002

Run Allocations - Budget

EVNT_5401000

5401000

Calculate P&L Variance

Published:

Rules

A number of rules are created during setup. These rules provide standard functionality tied to the default hierarchies. Additional rules may be added to the system, but need to conform to the numbering convention in order to avoid possible loss of custom rules during an upgrade.

Rule ID Convention

The rule ID convention is:

  • Rule IDs are seven digits long
  • The first digit indicates the rule type:
    • 1 for validation rules
    • 2 for model rules
    • 3 for rollup rules
    • 4 for model rules
    • 5 for event rules
  • The next digit indicates the time structure the rule applies to:
    • 0 for actual
    • 1 for forecast
    • 2 for budget
    • 3, 4 reserved for future use
    • 5-9 reserved for custom use (to avoid conflicts with future Solutions Framework rules, use this range for the second digit)
  • The next two digits represent the year the rule applies to (normally this applies to query rules only). 00 indicates no specific year, which could be confused with 2000 or 3000, but can be clarified by looking at the time period setting in the actual rule.
  • The next three digits are used to specify the rule number. Different types of rules have specific conventions around these three digits, but in general the last three digits start at 010 and increment by 10.

Event rule convention for last three digits:

  • xx0 is the manual trigger rule
  • xxn is a data trigger rule

Example:

5000010 is the manual trigger rule for actual beginning cash

5000011 is the data trigger rile for actual beginning cash

Event rule merging is used to merge the related rules.

Example:

Rule merging for the rules in the previous example would be configured as:

5000010,5000011

Validation rules

The Solutions Framework contains a number of validation rules tied to the initial hierarchies. Each validation rule targets a specific account under the symbol ACCOUNTS_ValRep

The exact accounts in the system depend on which time structures were selected during setup. The list above represents all time structures being selected. Each symbol is tied to a specific validation rule.

Account

Rule

Description

VR_1000010

1000010

Balance sheet is in balance? (Actual)

VR_1000020

1000020

Ending cash matches cash balance? (Actual)

VR_1000030

1000030

Open retained earnings matches opening balance (Actual)

VR_1000040

1000040

Ending roll forward balance matches trial balance (Actual)?

VR_1000050

1000050

Ending P&L variance matches P&L bridge (Actual)?

VR_1000060

1000060

P&L base variances have been explained (Actual)?

VR_1100010

1100010

Balance sheet is in balance? (Forecast)

VR_1100020

1100020

Ending cash matches cash balance? (Forecast)

VR_1100030

1100030

Open retained earnings matches opening balance (Forecast)

VR_1100050

1100050

Ending P&L variance matches P&L bridge (Forecast)?

VR_1100060

1100060

P&L base variances have been explained (Forecast)?

VR_1200010

1200010

Balance sheet is in balance? (Budget)

VR_1200020

1200020

Ending cash matches cash balance? (Budget)

VR_1200030

1200030

Open retained earnings matches opening balance (Budget)

VR_1200050

1200050

Ending P&L variance matches P&L bridge (Budget)?

VR_1200060

1200060

P&L base variances have been explained (Budget)?

VR_Intercompany

N/A

Any symbol attached to the this structure should be set up to hold validation rule data for a specific intercompany account.

For more information, see “System setup, intercompany validations” in the Solutions Administrator Guide.

Model rules

The Solutions Framework contains a number of model rules tied to the initial hierarchies. The rules added depend on the time structures selected during setup.

Rule

Description

2000010

Ending Cash, Actual

2000020

Ending Roll Forward Balance, Actual

2000030

Working Capital, Actual

2000040

Copy Intercompany Schedule Data, Actual

2000041

Copy Ownership Percentage for Investment Eliminations, Actual

2100010

Ending Cash, Forecast

2100030

Working Capital, Forecast

2200010

Ending Cash, Budget

2200030

Working Capital, Budget

Rollup rules

The Solutions Framework contains a number of rollup rules tied to the initial hierarchies. The rules added depend on the options selected during setup.

Rule

Description

3000010

Prevent Rollup of Balance Sheet to Trailing 12 Months

3000020

Prevent Rollup of Cash Flow to Trailing 12 Months

3400010

Prevent Rollup of Cash Flow to Cash Flow Basis

Query rules

The Solutions Framework contains a number of query rules tied to the initial hierarchies. The rules added depend on the options selected during setup.

Rule

Description

4000010

PA Beginning Cash, Actual

4000011

YTD Beginning Cash, Actual

4000020

PA Beginning Roll Forward Balance, Actual

4000021

YTD Beginning Roll Forward Balance, Actual

4100010

PA Beginning Cash, Forecast

4100011

YTD Beginning Cash, Forecast

4200010

PA Beginning Cash, Budget

4200011

YTD Beginning Cash, Budget

Note: Additional rules will be added as years are added to the system.

Event rules

The Solutions Framework contains a number of event rules tied to the initial hierarchies. Each event ties to a specific symbol for manual triggering, found in the EVENT_TRIGGERS hierarchy under the ACCOUNTS_System root. Each symbol is tied to a specific event rule.

Account

Rule

Description

EVNT_5000010

5000010

Calculate Actual Beginning Cash, Open

5000011

Calculate Actual Beginning Cash, Open (Data Triggered)

EVNT_5000020

5000020

Calculate Actual Beginning Cash

5000021

Calculate Actual Beginning Cash (Data Triggered)

EVNT_5000030

5000030

Calculate Actual Cash Flow Activity

5000031

Calculate Actual Cash Flow Activity (Data Triggered)

5000032

Calculate Actual Roll Forward Cash Flow Activity (Data Triggered)

EVNT_5000050

5000050

Calculate FX Impact on Actual Cash Flow

5000051

Calculate FX Impact on Actual Cash Flow (Data Triggered)

EVNT_5000060

5000060

Calculate Actual Roll Forward Beginning Balance, Open

5000061

Calculate Actual Roll Forward Beginning Balance, Open (Data Triggered)

EVNT_5000070

5000070

Calculate Actual Roll Forward Beginning Balance

5000071

Calculate Actual Roll Forward Beginning Balance (Data Triggered)

EVNT_5000080

5000080

Calculate FX Impact on Actual Roll Forward Balance

5000081

Calculate FX Impact on Actual Roll Forward Balance (Data Triggered)

EVNT_5000090

5000100

Calculate Equity Pickup

5000101

Calculate Equity Pickup (Data Triggered)

EVNT_5100010

5100010

Calculate Forecast Beginning Cash, Open

5100011

Calculate Forecast Beginning Cash, Open (Data Triggered)

EVNT_5100020

5100020

Calculate Forecast Beginning Cash

5100021

Calculate Forecast Beginning Cash (Data Triggered)

EVNT_5100030

5100030

Calculate Forecast Cash Flow Activity

5100031

Calculate Forecast Cash Flow Activity (Data Triggered)

EVNT_5100050

5100050

Calculate FX Impact on Forecast Cash Flow

5100051

Calculate FX Impact on Forecast Cash Flow (Data Triggered)

EVNT_5200010

5200010

Calculate Budget Beginning Cash, Open

5200011

Calculate Budget Beginning Cash, Open (Data Triggered)

EVNT_5200020

5200020

Calculate Budget Beginning Cash

5200021

Calculate Budget Beginning Cash (Data Triggered)

EVNT_5200030

5200030

Calculate Budget Cash Flow Activity

5200031

Calculate Budget Cash Flow Activity (Data Triggered)

EVNT_5200050

5200050

Calculate FX Impact on Budget Cash Flow

5200051

Calculate FX Impact on Budget Cash Flow (Data Triggered)

EVNT_5400000

5400000

Run Allocations - Actuals

5400001

Run Allocations - Forecast

5400002

Run Allocations - Budget

EVNT_5401000

5401000

Calculate P&L Variance

For an optimal Community experience, Please view on Desktop