Maintaining rollover and scenario setup
You can use the Rollover and Scenario Setup editor to manage what data movements occur when running rollovers and during time period initialization through a series of process steps. Your Longview system will come preconfigured to rollover the out-of-box environment, but additional process steps can be added.
Using the Rollover and Scenario Setup editor you can:
- Create specific data movements for period end, year end, and return rollovers and Scenario Initialization.
- Enable or disable data movements for standard period end, year end and return rollover.
- Enable or disable data movements established for the scenario initialization
The types of rollovers and initializations depending on this editor consist of:
- Period end rollover will apply settings from the period end rollover column.
- Year end rollover will apply settings from the year end rollover and return rollover columns.
- Scenario initialization will apply settings from the scenario initialization or period end rollover columns.
This section provides information on these main topics:
- “Adding rollover and scenario initialization process steps”
- “Modifying rollover and scenario initialization process steps”
- “Copying process settings for Rollover and Scenario Setup”
- “Exporting process steps to Microsoft Excel”
Adding rollover and scenario initialization process steps
You can add additional process steps to either rollovers or scenario initialization.
To add a rollover or scenario process step:
- In the Tax Provision navigation pane, click Administration.
- Expand Rollover and then click Rollover and Scenario Setup. The Rollover and Scenario Setup editor opens, displaying the process steps and their settings.
- Select the row under the appropriate parent for the process step, and do one of the following:
- To add a process step, click Process.
- To add a group parent, click Group.
A new row appears.
- Complete the following fields:
Field Description Name Type a name for the process step. The process name can have a maximum of 31 characters. Description Type a description for the process step. The description can have a maximum of 100 characters. Sort Order Specify a numeric value from 1 and up representing the order of the symbol with respect to its parent. By default, the sort order for added symbols is 10 higher than the last child of the same parent symbol. If you specify a value of 0, the symbol appears at the bottom of the list. - For Parent, type the name of the parent symbol for the process step, or select a parent in the drop-down list. Alternatively, you can use the symbol selector.
- Complete the following fields:
Field Description Period End Rollover Select this option for the process step to be applied during a period end rollover and during selected scenario initialization. Year End Rollover Select this option for the process step to be applied during a year end rollover and during selected scenario initialization. Return Rollover Select this option for the process to be applied during a year end rollover and during selected scenario initialization. Scenario Initialization Select this option for the process step to be applied during selected scenario initialization. Method Select one of the following: - Copy – Use this value to move data from one period to another without any change.
- Transfer – Use this value to move data from one period to another with a movement across accounts and/or elements.
- Custom – Use this value to indicate a configured process has been developed for data movements that cannot be performed using copy or transfer.
Note: The configured process must be placed in the dataserver directory of applications\Longview Tax\Tax Rollover\Code\Configured using a procedure of the same name as the process in the Rollover and Scenario Setup editor.
This field is mandatory.
Target Account Specify the target account for the transfer. You can only specify one leaf symbol. Target Element Specify the target element for the transfer. You can only specify one leaf symbol. Source Accounts Specify the source accounts for the process step. You can only specify one parent or leaf symbol using the symbol selector when a Target Account has been selected. When Target Account is cleared more than one parent or leaf symbol can be specified using the symbol spec selector. This field is mandatory when the Method is Copy or Transfer. Source Elements Specify the source element for the process step. You can only specify one parent or leaf symbol using the symbol selector when a Target Element has been selected. When Target Element is cleared more than one parent or leaf symbol can be specified using the symbol spec selector. This field is mandatory when the Method is Copy or Transfer. Source Entities Specify the source entities for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. Source Details Specify the source details for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. Source Currencies Specify the source currencies for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. Source Segments Specify the source segments for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. Source Controls Specify the source controls for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. - Click OK. The process step appears in the hierarchy.
- When you are finished, click Save.
Modifying rollover and scenario initialization process steps
You can modify the process step settings for existing rollover and scenario initializations.
Note: When modifying a preconfigured process step you can update the Rollover and Initialization flags, but the process step will need to be copied as a new step and the content modified if there is a need to change the settings while the original process step can then be set to false. For how to copy process settings see "Copying process settings for Rollover and Scenario Setup"
To modify a rollover or scenario process step:
- In the Tax Provision navigation pane, click Administration.
- Expand Rollover and then click Rollover and Scenario Setup. The Rollover and Scenario Setup editor opens, displaying the process steps and their settings.
- Do one of the following:
- To edit the process name, description, sort order, or parent, select the process step, and click Properties. The fields become available. Continue to the next step.
- To edit other settings, continue to step 6.
- Edit the following fields as necessary:
Field Description Name Type a name for the process. The process name can have a maximum of 31 characters. Description Type a description for the process. The description can have a maximum of 100 characters. Sort Order Specify a numeric value from 1 and up representing the order of the symbol with respect to its parent. By default, the sort order for added symbols is 10 higher than the last child of the same parent symbol. If you specify a value of 0, the symbol appears at the bottom of the list. - For Parent, type the name of the parent symbol for the process, or select a parent in the drop-down list. Alternatively, you can use the symbol selector.
- Edit the following fields as necessary:
Field Description Type Select the type of rollover process the step will apply to:
- Provision: For a step that will apply when the rollover is executed for tax provision.
- Pillar Two: For a step that will apply when the rollover is ececuted for Pillar Two.
Period End Rollover Select this option for the process to be applied during a period end rollover and during selected scenario initialization. Year End Rollover Select this option for the process to be applied during a year end rollover and during selected scenario initialization. Return Rollover Select this option for the process to be applied during a year end rollover and during selected scenario initialization. Scenario Initialization Select this option for the process to be applied during selected scenario initialization. Method Select one of the following: - Copy – Use this value to move data from one period to another without any change.
- Transfer – Use this value to move data from one period to another with a movement across accounts and/or elements.
- Custom – Use this value to indicate a configured process has been developed for data movements that cannot be performed using copy or transfer.
Note: The configured process must be placed in the dataserver directory of applications\Longview Tax\Tax Rollover\Code\Configured using a procedure of the same name as the process in the Rollover and Scenario Setup editor.
This field is mandatory.
Target Account Specify the target account for the transfer. You can only specify one leaf symbol. Target Element Specify the target element for the transfer. You can only specify one leaf symbol. Source Accounts Specify the source accounts for the process step. You can only specify one parent or leaf symbol using the symbol selector when a Target Account has been selected. When Target Account is cleared more than one parent or leaf symbol can be specified using the symbol spec selector. This field is mandatory when the Method is Copy or Transfer. Source Elements Specify the source element for the process step. You can only specify one parent or leaf symbol using the symbol selector when a Target Element has been selected. When Target Element is cleared more than one parent or leaf symbol can be specified using the symbol spec selector. This field is mandatory when the Method is Copy or Transfer. Source Entities Specify the source entities for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. Source Details Specify the source details for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer.
Source Currencies Specify the source currencies for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. Source Segments Specify the source segments for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. Source Controls Specify the source controls for the process step. You can specify more than one parent or leaf symbol. This field is mandatory when the Method is Copy or Transfer. - Click OK.
- When you are finished, click Save.
Copying process settings for Rollover and Scenario Setup
If a Process step should have similar settings as an existing step, you can copy settings to the Process step.
To copy Process step settings:
- In the Tax Provision navigation pane, click Administration.
- Expand Rollover and then click Rollover and Scenario Setup. The Rollover and Scenario Setup editor opens, displaying the process steps and their settings.
- Select the Process step you want to copy settings to, and click Copy Process Settings. The Copy Process Settings dialog opens.
- Type the name of the process to copy settings from, or select the process in the drop-down list. Alternatively, you can use the symbol selector.
Note: You must select a leaf process.
- Click Copy. The settings are copied to the specified process.
- When you are finished, click Save.
Exporting process steps to Microsoft Excel
You can use the Rollover and Scenario Setup editor to export information from all process steps in the editor to Microsoft Excel.
To export process steps to Microsoft Excel:
- In the Tax Provision navigation pane, click Administration.
- Expand Rollover and then click Rollover and Scenario Setup. The Rollover and Scenario Setup editor opens, displaying the process steps and their settings.
- Click Export to Excel. A dialog opens.
- Select one of the following:
- To export all process steps fully expanded, click Expanded View.
- To export only the process steps visible in the current hierarchy expansion state, click Current View.
- The Save As dialog opens.
- Navigate to the location where you want the file to be saved.
- Type the name of the file you want the process information to be exported to.
- Click Save. The file opens in Microsoft Excel.