Recent Content
-- START HERE -- Links to the "Key" KB articles -- Tax Provision
Here is a list of "KEY" KB articles with links. Many of the below KB articles contain links to other KB articles. Summary of the Tax Provision Functionality by Version What Types of Tax Provisioning Can Be Done Tax Provision Blueprint Instruction Guide - PV7.4.2 SV100 Miscellaneous Information - Package Content Naming How to Import the Tax Provision Blueprint app in a Dev Environment (Step 1) How to Setup the Tax Provision Blueprint app in a Dev Environment (Step 2) What are the Necessary Activities to Start a New Tax Provision Year - "Actual" What are the Necessary Activities to Start a New Tax Provision Year - "Forecast" How to Save your Tax Provision Cube POV Where are the Tax Reports? How do I Get to the Tax Reports? SAMPLE FORMS -- Links to all the Sample Forms KB articles Design Assumptions Glossary Tax Cube Setup - XFW_TXP Create New FX Rate Types Metadata Components - Overview Business Rules - Overview Home Page Reports Sample Reports - Overview Data Integration Dashboards Schedules & Reports - PPT Help Files Workflow Forms/Schedule Notes Workflow Profiles Form Templates Cube Views Parameters Security Troubleshooting the Schedules Debugging a Dashboard Error Message - Cannot Determine the CubeRoot Profile that Workflow Profile [XFW_TXP_NotUsed] Bug - Schedule "03 FC Tax Attributes" - Linked CV Bug - (v8.0 & v8.1) - Load/Extract Screen - Extract Exceeds File Size Limit Bug - Schedule "06a Deferred Tax" - Input Open on Tax Losses and Tax Credits Bug - Schedule 07 Tax Account Reconciliation Translation Rule Bug - Translation Issue with Account "TXP_TxRperGL" Bug - Report 40c1 (Sch 10) - Wrong Year Parameter Bug - Report 05c (Sch 02) and 05d (Sch 02) - Wrong Year Parameter Is Tax Provision Upgradeable? Is Tax Provision Compatible with Version 8 (v8)? How Do I Know What Version of Tax Provision I Am Using? Adding the Refresh Button To a Toolbar Using a Time Profile With Weeks Remove the Word "Blueprint" Data Copy - What Happens When Different Entity Currencies are Involved? How to Create a "Sort" Check Box in our Dashboards (used in schedules or reports) Activating the "In Use" Metadata Feature0likes0CommentsSummary of the Tax Provision Functionality by Version
Below are the versions of Tax Provision with it's associated functionality. There is an attached zip file that has all the Release Notes for each version. Note: Tax Provision Blueprint is not an upgradeable solution. PV430 SV100 - release date: Nov 30, 2018 (referred to as Dev01) Initial launch of Tax Provision. Feature Functionality National jurisdiction tax provision. PV511 SV100 - release date: Sep. 23, 2020 (referred to as Dev02) Feature Functionality The Tax Provision solution now supports the ability to compute Local Tax Provisions. UD1 now includes Local Jurisdictions. Business Rules now calculate both National and Local Jurisdictions. All Schedules have the ability to display either the National Jurisdiction or any one of the Local Jurisdictions. Added the ability for an entity to receive a National Tax Benefit from Local Jurisdiction(s). Where applicable, Schedules will suppress specific rows or columns that are not related to the selected Jurisdiction, allowing the same Schedule to be used for different purposes. See KB article: "Release Video - PV5.1.0 SV100" Additional Enhancements The Tax Provision Setup Instructions contain detailed information for all implementers and Administrators regarding the use of Schedules in both the Seed Year and the years after the Seed Year. There is now a Tax Provision Dashboard which includes a Home page. There is now a Settings page that is accessible from the Tax Provision Dashboard. The top line in each Schedule now shows the Calc Status. Schedule row and column descriptions now include data origination and destination. Also, specific data cells will display a colored box around them to indicate where data is expected. Analysis Cube Views were created and can be attached to a Workflow. The SaveDataEventHandler Business Rule now validates the years that a user enters into Schedules 2, 3, and 4. Error messages will pop up when trying to save or calculate incorrectly entered years. These messages contain corrective instructions. An Admin Cube View (available in OnePlace) is provided to help the Administrator pre-populate the Origin Year for Schedule 3. The Start Year is now referred to as the Seed Year. Form Templates are now created using Dashboards rather than Cube Views. The main Finance Business Rule (TXP_BusinessRules) has been re-organized and is better structured for understanding and maintenance. RTP - Return Year must be set and no longer defaults to the prior year. In Schedule 3, the data for UD2 member “CY > -19” no longer rolls off the schedule, but rather is added to the last year’s balance. PV620 SV100 - release date: Sep 24, 2021 (referred to as Dev03) Feature Functionality The Tax Provision solution now supports the ability to calculate a tax provision with or without Group Filings (GF): National and/or Local jurisdictions. Workflows are used extensively to facilitate the different tax provision setups for group filing or no group filing. The Entity dimension has 2 new Text 7 properties required for group filing: “NatFiler=Yes” and “LocalFiler=Yes”. The UD1 National JD has a Text 2 requirement for National GF: “NatGF=Yes”. The UD7 dimension is now being used to hold the group filing entities. New schedules have been created to allow the users to enter in Group Filing Definitions. The Finance BR “TXP_BusinessRules” has been updated for the UD7 dimension. See KB article: "Release Video - PV6.2.0 SV100" Additional Enhancements Additional UD8 members have been added for dynamic reporting. There are now ten Form Template Profiles to assist with the different types of workflows. The tenth one being the Admin profile. All schedules now have an attached PPT file. These files can be customizable to each application. Schedules no longer have an Instructions section below the POV / above the cube view. Instead, we now have a PPT help file with the instructions in it. This saves on the schedule’s real estate space. All schedules now include a vertical and horizontal moveable splitter bar. Five new copy schedules have been added – DM 10a, DM 10b1, DM 10b2, DM 30a and DM 30b. DM 10a is used to copy the National provision data to the National filer entity. Several new Data Management jobs have been created to assist with copying data and annotations. There are now Scenario formulas on both Actual scenarios that impact the first period of the following year when a calculate is done in period 12. These can be removed or changed based on your specific app. Four Forecast scenarios have been created for reference only. FX rates and Excel data files are included with sample data that can be loaded into the Tax Provision app. Schedules that start with a “DM” represents a Data Management job that copies data or cell text. Schedules that start with a “LP” represents Local Processing for local jurisdictions. PV620 SV200 - release date: Feb 28, 2022 (referred to as Dev04) Feature Functionality The Tax Provision solution now supports the ability to execute a bulk data copy: Allows National group filers to copy the national preparation data to the filer member. Allows copy from National to Local jurisdictions. The GLTaxAdmin workflow allows you to process all the different country bulk data copies from one workflow. A new Finance business rule was created called “TXP_CustomCalcs” which is used to calculate the new Time Stamp for the bulk data copy dashboards. Additional Enhancements Several reports now have a combo box selection to select the number of decimal places to display for percentages. The Tax Provision dashboard home page for reports is now divided into two panes – Report Groups and Reports. Several reports now have a check box to allow you to sort the entities in the combo box. Reports now let you select the time period (month) for the report and assumes the workflow year you are in. This means that the user does not have to be in a specific workflow period to run a report. PV620 SV300 - release date: Jul 10, 2023 (referred to as Dev05_Dscr) Feature Functionality The Tax Provision solution now supports Interim Reporting computations for the current year. Option to calculate a full year forecast for the current period. Ability to calculate the Interim Reporting Run Rate in the forecast scenario. Added classification of discrete items to facilitate Interim Reporting. Includes Losses Not Benefited computation. Consolidated Interim Reporting Run Rate is used to calculate and report the Applied Interim Reporting Effective Tax Rate. We have assumed that the workflow profiles are the same for Actual as well as for Forecast scenarios. Single year Forecast scenarios are set up to use the Scenario Type of “ScenarioType8”. Six new FX rate types have been added that are used on forecast scenarios. New sets of schedules have been created for Forecast scenarios. New Forecast Tax Reviewer reports have been created. We added the ability to do a bulk copy of last year’s CY tax rates & last year’s Deferred tax rates into the current year. This is only done in period 1. See KB article: "Tax Provisioning Blueprint Overview - PV6.2.0 SV300" See KB article: "Release Video - PV6.2.0 SV300" Additional Enhancements Added parent account TXP_TIBeforeLosswNatBen to allow the National Benefit Deduction to be included when creating a tax loss. We added a new Global Setting page option for a security group. All schedules and Reports now have a “Refresh Data” button in the toolbar. We added the “Sticky POV” concept on the schedules. This will hold your POV as you go from schedule to schedule. Reports will now automatically hold your POV (same as the Sticky POV concept). Schedule column headers now indicate if there are linked CV’s in that column. Additional Actual Tax Reviewer reports have been created. Multi-year Forecast scenarios are set up to use the Scenario Type of “ScenarioType7”, but we have not explored that avenue in this release. PV730 SV100 - release date: Jan 15, 2024 (referred to as Dev06) Feature Functionality Lots of new reports were created and updated. Additional Enhancements Added the UD1 "Total Local" member to the toolbar combo boxes. Added monthly, quarterly & yearly confirmation rules for forecast scenarios. BR's - changed the reference for "RemoveZero" to "RemoveNoData" - specifically for forecast scenarios. FX calculations were updated to include local FX due to multiple translations. Documented which dimension members can be "renamed", "deleted" or not touched. The Waterfall graph (80a) no longer uses BR’s for the graph. There is now a new Advance Chart called “Waterfall” that has the same functionality as the BR. PV742 SV100 - release date: Aug 08, 2025 (referred to as Dev06 Bug Fixes) Feature Functionality No new functionality was added in this minor release. See KB article: "Tax Provisioning Blueprint Overview - PV7.4.2 SV100" Additional Enhancements Updated several rules to use “api” syntax rather than “BRapi” syntax. Additional groupings in BR’s (using #Region / #End Region) were added to help group larger sections of syntax for better usability. Within each DataBuffer, we changed from using the “api.data.calculate” to using a more efficient syntax that uses the “api.Data.SetDataBuffer”. This reduces the number of times that the BR’s write back to the database. The old rules remain in each section but are commented out for references purposes only. There were approximately 59 occurrences for this change. The Trend Reports and the Consolidating Reports all have the UD3 Source as a selectable option. Removed the semi-colon ( : ) from the Admin workflow profile names. Under certain circumstances, you can encounter issues loading in the “Workflow Profiles” file – either on its own or as part of the application zip file. For cube view “40c1 Sch 10 Nat Any Entity_TXP”, the year was referencing the WF Year – which is incorrect. It was changed to use the parameter |!Select_Year_TXP!| Bug - Report 40c1 (Sch 10) - Wrong Year Parameter | OneStream Community Bug – Translation Issue with Account “TXP_TxRperGL” The TXP_TxRperGL account (Ending GL Balance) translates all UD2 Balance Sheet members using the average rate on a Periodic basis. This means that the Balance Sheet UD2 members are translated incorrectly. This new rule translates using the closing FX rate. re: OneStream Support Case # CSRC0109897 Bug – Translation Issue with Account “TXP_TxRperGL” Bug – Schedule 07 Tax Account Reconciliation Translation Rule An extra line of code to help calculate the translated opening balance account was applied incorrectly. re: OneStream Support Case # CSRC0109262 Bug – Schedule 07 Tax Account Reconciliation Translation Rule Bug – Schedule 06a Deferred Tax – Input Open on Tax Losses and Tax Credits On Schedule "06a Deferred Tax Source Gross", input is available on the rows for Tax Losses and Tax Credits for the columns Deferred Other 1 and Deferred Other 2. Bug – Schedule 06a Deferred Tax – Input Open on Tax Losses and Tax Credits Bug – Schedule 03FC Tax Attributes – Linked CV On Schedule "03 FC Tax Attributes", the linked Cube Views do not appear when you right click in the column. Bug – Schedule 03FC Tax Attributes – Linked CVTax Provisioning Blueprint Overview - PV7.4.2 SV100
The following Blueprint is compatible with OneStream Platform v8 and will be moving to OpenPlace in July of 2024. The OneStream Tax Provision Blueprint provides a framework to streamline the tax provision computing national and local for both current and deferred taxes under US GAAP as well as providing related workflows and reporting, all within the OneStream Platform. It is a full application that provides an accelerated path to building out what will be a customized OneStream Financial Model. It allows companies to leverage the OneStream platform capabilities and existing OneStream data to automate tax provision related flows of data and reporting. In this release, we have added over 50 additional reports, added the UD1 Total jurisdiction member to the schedules for improved reporting, added sample forecast confirmation rules and fixed a few business rules. As the Blueprint provides the framework for the Tax Provision calculations, it is intended to provide a starting point in the creation of a custom implementation. This Blueprint is therefore NOT UPGRADEABLE. The Tax Provision Blueprint is installed with OneStream Financial Model Applications but utilizes its own distinct cube providing the ability to leverage Financial Model data already in OneStream while allowing organizations to manage separate and distinct data and Workflows. Tax Provision Blueprint takes advantage of the inherent capabilities of the OneStream Platform, including configurable workflow management, ability to trace data, flexible and powerful consolidation capabilities, flexible and accurate translation capability, and the ability to manage multiple levels of detail to support differing business needs. Tax Provision Blueprint also takes advantage of other capabilities of the OneStream Platform, which enable integration with other tax data sources, local ledgers, and other financial systems.0likes0CommentsRemove the Word "Blueprint"
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 457. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" This information is part of the "Instruction Guide" that comes with the Tax Provision Blueprint app as Appendix D. Remove the Word Blueprint We now refer to this app as the Tax Provision Blueprint. This section shows you all the places where we have added in the word “Blueprint” so that you can remove it in your application. Here is an overview where the word “Blueprint” appears: Dashboard: 0_Frame_TXP Dashboard Maintenance Group: Tax Provision OnePlace (TXP) Dashboard: OnePlace_TXP Dashboard Profile: Tax Provision (TXP) Parameter: ListOfGroupsHP_new_TXP Parameter: HelpAboutSolutionTitle_TXPH Cubes: XFW_TXP / Description Label: lbl_TitleMain3_TXP The above label is used in the following dashboard. If you remove this component, you will need to adjust the “Grid Layout Type” for the number of rows from “8” to “7”. Currently, it is laid out as follows:0likes0CommentsBug - Report 05c (Sch 02) and 05d (Sch 02) - Wrong Year Parameter
This relates to release PV7.3.0 SV100. You will need to apply this fix to the OpenPlace solution. Issue: The first two rows in each of these two cube views (05c Sch 02 Nat Consol_TXP and 05d Sch 02 Local Consol_TXP) uses the parameter "WFYear". This needs to be changed to the parameter "|!Select_Year_TXP!|". Cube View Changes: 1) Update the first two row headers for the time period. Replace "T#WFYear" with "T#|!Select_Year_TXP!|" Before: After:0likes0CommentsWorkflow Profiles Setup - Actual & Forecast
Attached is a 4 tab Excel file. Two tabs describes how Workflow Profiles for Actual and Forecast have been configured. One tab shows the questions that you would walk through to determine what type of workflow to setup. The remaining tab highlights how the base level workflows should be setup.0likes0CommentsBug - Report 40c1 (Sch 10) - Wrong Year Parameter
This relates to release PV7.3.0 SV100. You will need to apply this fix to the OpenPlace solution. Issue: Each column in the report (Cube View: 40c1 Sch 10 Nat Any Entity_TXP) uses the parameter "WFYear". This needs to be changed to the parameter "|!Select_Year_TXP!|". Cube View Changes: 1) Remove the Time Member reference in the POV - it is not needed. Before: After: 2) Update each column header for the time period. Replace "T#WFYear" with "T#|!Select_Year_TXP!|" Before: After:0likes0CommentsBug - Translation Issue with Account "TXP_TxRperGL"
This relates to release PV7.3.0 SV100. You will need to apply this fix to the OpenPlace solution. This fix was discovered by Julien Coudrette from Finit Solutions. Thank you Julien for bringing this to our attention. CSRC case # CSRC0109897 Issue: The TXP_TxRperGL account (Ending GL Balance) translates all UD2 Balance Sheet members using the average rate on a Periodic basis. This means that the Balance Sheet UD2 members are translated incorrectly. Metadata Setup: The Account member setup: Account Type: Asset The Flow member setup: (uses the Average rate and translates periodically - this is fine for the P&L accounts - UD2#TXP_TXRecTotalExpense.Base) The UD2 member setup: Need to provide a way to translate the Balance Sheet UD2 members using the Closing rate Fix: Go to the Finance rule "TXP_BusinessRules". Go to the section "Schedule07TaxAccountReconciliationTranslation". Add the following syntax at the bottom of the rule. Here is the actual code that you can copy into your BR's: '-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- '-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- '"per GL" Translation fix for Balance Sheet accounts (CSRC0109897) 'A#TXP_TxRperGL -> Account Type = Asset 'F#TXP_TXRec_Input -> Switch Type = True (uses the Average rate and translates periodically - this is fine for the P&L accounts - UD2#TXP_TXRecTotalExpense.Base) 'U2#TXP_TxRecBalanceSheet.Base -> Provide a way to translate the Balance Sheet UD2 members using the Closing rate api.Data.Calculate("V#YTD:A#TXP_TxRperGL:I#None:F#TXP_TXRec_Input:U5#None:U6#None:U8#None = RemoveNoData(V#YTD:A#TXP_TxRperGL:I#Top:F#TXP_TXRec_Input:C#Local:U5#None:U6#None" & _ ":U8#None * " & api.Data.DecimalToText(calcSession.Closingrate) & ")",,,,,"U1#TXP_TotalJD.Base","U2#TXP_TxRecBalanceSheet.Base","U3#TXP_SourceTotal.Base", _ "U4#TXP_TotalNatLoc.Base",,,"U7#TXP_GFEntities.Base",,) '-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- '--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------0likes0CommentsBug - Schedule 07 Tax Account Reconciliation Translation Rule
This relates to release PV7.3.0 SV100. You will need to apply this fix to the OpenPlace solution. This fix was discovered by Julien Coudrette from Finit Solutions. Thank you Julien for bringing this to our attention. CSRC case # CSRC0109262 Issue: An extra line of code to help calculate the translated opening balance account was applied incorrectly. Fix: Go to the Finance rule "TXP_BusinessRules". Go to the section "Schedule07TaxAccountReconciliationTranslation". The issue is with the first BR only. Remove the highlighted row. Your BR should look something similar to this: You can leave the old rule in place, but comment out the lines with a single quote ('). Note: Beware of the syntax - the 2nd line needs the "&" to be replaced with an "_". Here is the actual code that you can copy into your BR's: api.Data.Calculate("V#YTD:A#TXP_TxROpeningBal:I#None:O#Import:U5#None:U6#None:U8#None = " & _ " RemoveNoData(S#" & calcSession.OpenBalScenario & ":T#PovPriorYearM12:V#YTD:A#TXP_TxREndingBalance:O#BeforeAdj:U5#None:U6#None:U8#None)" _ ,,,,,"U1#TXP_TotalJD.Base","U2#TXP_TxRecBalanceSheet.Base","U3#TXP_SourceTotal.Base","U4#TXP_TotalNatLoc.Base",,,"U7#TXP_GFEntities.Base",,)0likes0CommentsDashboard Objects and Associated Parameters
Attached is a one tab Excel file that lists all the dashboards, with all the dashboard components and their associated parameters. This can be helpful to see where specific DB objects / parameters are used throughout our dashboards. Filtering has been turned on for the columns to assist with this activity.