FX Rates
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 48. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Create New FX Rate Types" FX Rates TXP_YTDAverageRate – YTD Average Rate is the FX Rate Type that is used with the Tax Provision Blueprint application for revenue and expense (activity) currency translation for the TXP_Actual and TXP_ActualRTP scenarios. In addition, Tax Provision Blueprint leverages monthly Closing Rates for asset and liability translation. Tax Provision Blueprint uses the Rule Type of Periodic for translation of revenues and expenses, and the Rule Type of Direct for translation of assets and liabilities. There are three forecast FX average rates and three forecast FX closing rates that are used with these forecast scenarios: TXP_FCST_M5 TXP_FCST_Q2 TXP_FCST_Q3 Cube Setup: Actual Scenario Setup:Create New FX Rate Types
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 25. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "FX Rates" Create New FX Rate Types When the Development application is refreshed from the Production application, the Administrator must manually create the seven new FX Rate Types in the target OneStream application before beginning the installation and file import processes. The FX Rate Type contains a unique GUID identity code for each application at the time it is created, alleviating potential conflicts caused by importing the FX Rate Type with a conflicting GUID from another application. To create a new FX Rate Type: From the application tab, click Cube > FX Rates. On the FX Rates tab, click Create or Edit FX Rate Type and type the following information: Name: TXP_YTDAverageRate Description: YTD Average Rate Click OK. Repeat the process for the other FX rates as follows: After you have successfully added all these FX Rate Types, import the Tax Provision Blueprint “zip” file. Important! These seven FX rate types must exist in the app before you can successfully load in the application zip file. Attached is a file that contains the additional FX Rate Types that are used in the Tax Provision Blueprint application. This file allows you to load in the FX Rate Types rather than manually creating them. This must be done prior to loading in the XML file. This file contains the 7 additional FX Rate Types.SaveDataEventHandler BR
Attached is the SaveDataEventHandler business rule that is used in the Tax Provision Blueprint application. You can only have one SaveDataEventHandler BR per application. You will overwrite the existing Business Rule if loaded directly into the system. For this reason, it is not included in the “zip” Package and must be uploaded manually for the solution to work properly. The BR can be obtained in the Tax Provision Blueprint app in one of two ways. 1) On the Application Dashboards tab, click Dashboard Maintenance Units > XFW Tax Provision (TXP) > Files > 01 SaveDataEventHandler_BR_for_TXP.zip. In the General (File) pane, click the Download File icon in the Content File row and select a location to save the file locally. 2) The file can also be located on the Settings dashboard under Detailed Implementation Files:
