How to Setup the Tax Provision Blueprint app in a Dev Environment (Step 2)
After you have completed Step 1: KB article "How to Import the Tax Provision Blueprint app in a Dev Environment (Step 1), you are now ready to update metadata and adjust some configurations to meet your specific application requirements. The following is a summary of the topics to be considered. Please see the attached Word doc. for more detail (the doc. is still being put together). (1) Update Metadata Update the imported scenarios XFW_TXP_Scenarios. Delete what is not required. Update the imported Flows XFW_TXP_Flows. Update UD1 (Jurisdictions) XFW_TXP_UD1: Remove countries & jurisdictions you are not using. Add countries & jurisdictions that are missing. Update UD2 (Data Type) XFW_TXP_UD2. Update the importedAccounts XFW_TXP_Accounts. Please see the KB article "Dimension Member Names - Renaming and Deleting". This will show you which dimension members can be renamed or deleted. (2) Update Cube Views Update Cube Views for the new accounts - specifically for Sch 02, 05, 06 and all the associated row templates. Update Cube Views for the any new UD2 members - specifically for Sch 07. (3) Update Parameters Review and update the following parameters: Tax_BaseLevelTimePeriods_TXP WFYearBasePeriods_ML_TXP TimeZone_Footer_TXP SourceFCSTScenarios_TXP FCSTScenarios_Sch1f_TXP Select_Report_Scenario_TXP Select_Report_FCSTScenario_TXP Tax_Countries_NoBase_TXP Tax_Entities_NatGF_TXP Tax_Entities_noNatGF_TXP UD7_Sch05c_NatGF_TXP (4) FX Rates Enter in all the appropriate FX rates. (5) Update the Schedule / Report PPT Help Files Each schedule and report has an associated PPT help file (click on the ? icon) that should be reviewed and updated to be client/application specific. (6) Confirmation Rules Review the Confirmation rules. Delete, update, rename and/or create new ones as necessary. (7) Security Createsecurity groups and attach them to the appropriate dimension members.What are the Necessary Activities to Start a New Tax Provision Year - "Forecast"
Attached is a Word document that highlights the steps necessary to start a new tax provision year for a Forecast scenario. Many of these steps will most likely be executed by the Admin. In the actual scenario, the admin will need to select the forecast scenario where the Interim Run rate will come from and once the Interim Run Rate has been calculated enter the Interim Run Rate. For each forecast scenario where a tax provision is calculated, the administrator will most likely be responsible for initializing the scenario with data from actuals for a set number of periods and then facilitating data copies within the forecast periods. Within the XFW_TXP_GLTaxAdmin workflow, there are dashboards to do the following: Forecast scenario – Prep tasks Forecast scenario – Initialize & Data copy tasks Forecast scenario – Data copy tasks (forecast periods) TXP_Actual scenario – Initialize tasks This is a summary of the detailed information that you can find in the "Instruction Guide" that comes with the Tax Provision Blueprint application.How to Import the Tax Provision Blueprint app in a Dev Environment (Step 1)
We strongly suggest that you first install the MarketPlace Tax Provision Blueprint in a Test environment / Test App as a stand alone app. From there, you can export the objects that you need into a recent copy of your Production app that is in your Dev environment. Why do we say this?The Tax Provision Blueprint installation includes test entities, related metadata, and workflows, all which will need to be removed. It is strongly recommended that this removal and the related addition of customer entities, metadata and workflows be performed in a development environment, and that the production migration be planned from this updated development environment. Here are the high level steps required to import & setup the Tax Provision Blueprint app into your Dev environment. This "Step 1" KB article will walk you through: Installing the MarketPlace app into a Test environment / Test app. This app will be your reference app with test entities and test workflow profiles. Export only the required objects from yourTest environment / Test app. Import the required objects into your Dev environment / Dev app. Configure the Tax Provision app in yourDev environment / Dev app. so that you have a working Tax Provision application. Note: Additional metadata updates and system configurations will still be required. Please see KB article "How to Setup the Tax Provision Blueprint app in a Dev Environment (Step 2)". (1) Download and Install the MarketPlace app in a TestEnvironment/App The app in this environment will be a complete install including test entities and test workflows. This will be your Tax Provision app to reference. Download the MarketPlace Tax Provision Blueprint app Create a test app Create the required FX Rate Types or load in the FX Rate Type file Load in the downloaded "xml" file Load in the SaveDataEventHandler BR (2) Export the Tax Objects from the Test Environment/App Only specific objects need to be exported then import into your Dev. app. Export Metadata - AllBusiness Rules, all Dimensions (except XFW_TXP_Entities, FIN_Entities_TXP), exclude Time Dimension Profiles & Cubes Export Cube Views - AllBusiness Rules, Groups & Profiles Export Form Templates - AllGroups & Profiles Export Data Management - All Groups Export Confirmation Rules - All Groups and Profiles Export Extensibility Rules - only the SaveDataEventHandler Export the Dashboards - All Business Rules, Workspaces, Profiles Export the new FX Rate Types - seven in total (3) Import The Tax Objects into your DevEnvironment/App This Dev app. should be a recent copy of your Production app. The following steps must be done in this order: Create the Tax Cube (XFW_TXP) -(to be configured later on) Load/Create the necessary FX Rate Types Import the Metadata file Import the Cube View file Import the Form Templates file Import the Data Management file Import the Confirmation Rule file (need the cube to be created) Import the Dashboard file If you already have a "SaveDataEventHandler" BR, copy in the Tax BR section. If there is no "SaveDataEventHandler" BR, then you can load in the file. (4) Configure Tax Provision in the DevEnvironment/App The Tax Provision Blueprint app comes with a very comprehensive "Instruction Guide" that we strongly encourage you to read. Create an Entity hierarchy for Tax or use an existing hierarchy (ie: Finance...). Configure the Entities. Add the "TXP_GLTaxAdmin" entity as a sibling of the Tax entity hierarchy. Make sure you update the proper properties. XFW_TXP Cube - Update the Cube Properties, the Cube Dimensions, the Cube References and Integration settings.See your Test environment / Test app for examples. Update the Application Properties, if necessary. Update the Global Setup Dashboard for the Entity dimension, the Tax Entity hierarchy and the security group access. Update the other settings if necessary. Update UD7 (Group Filing) XFW_TXP_UD7: Remove Blueprint entities. Remove countries you are not using. Add new countries and entities that are using Group Filing. Must be exactly as they appear in the Entity dimension. If you are not using Group Filing at all, remove all the Blueprint entities and countries. Remember to keep the minimum required members. Set a "Cube POV" for the XFW_TXP tax cube. There should be no "?" for any dimension member. Create "test" Workflow Profilesto validate the Schedules. See your Test environment / Test app for examples.What are the Necessary Activities to Start a New Tax Provision Year - "Actual"
Attached is a Word document that highlights the steps necessary to start a new tax provision year or a new tax provision for a period other than the first period in the year. Many of these steps will most likely be executed by the Admin. These are the following classifications of tasks: Global (applies to all entities) Executed only in the first period of the year. Executed once at the start of a tax provision period. Individual entity Executed only in the first period of the year. Executed once at the start of a tax provision period. This is a summary of the detailed information that you can find in the "Instruction Guide" that comes with the Tax Provision Blueprint application.