Recent Content
-- START HERE -- Links to the "Key" KB articles -- Tax Provision
Here is a list of "KEY"KB articleswith 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.3.0 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" 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 Feature0likes0CommentsBug - Translation Issue with Account "TXP_TxRperGL"
This relates to releasePV7.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 releasePV7.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",,)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 Profiles: 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: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.0likes1CommentDimension Member Names - Renaming and Deleting
Attached is a 10 tab Excel file that shows which member names can be renamed, deleted or not changed at all. It also indicates if the member name is used in CV's, BR's, Dashboard objects or in Data Management. It looks at the following dimensions: Scenario Entities Accounts Flow UD1, UD2, UD3, UD4, UD7 and UD80likes2CommentsForm Templates
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 147. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Form Template Groups & Profiles" Form Templates The Tax Provision Blueprint Form Templates are used for Tax Forms/Schedules and are used in the Workflow Profiles. Several Form Template Groups are used to break down the schedules into smaller groups so that several specific Form Template Profiles can be created and attached to the different types of workflows that are possible. All the Form Templates are of the Form Type “Dashboard”. Dashboards allow greater flexibility in how the schedules are rendered to the user.0likes2CommentsSample Excel Formulas
Attached is a 4 tab Excel file that has many sample Excel formulas. It shows you how to reference the 18 dimensions in order to pull or push data as well as pull in metadata attributes. Areas of examples include: XFSetCell / XFGetCell / XFGetMemberProperty / XFGetRelationshipProperty / XFGetMemberInfo. This is an excellent file to help you get up and running quickly using Excel formulas.0likes1CommentIs Tax Provision Compatible with Version 8 (v8)?
The most currently release of Tax Provision Blueprint (PV7.3.0 SV100) is compatible with version 8 (v8). Tax Provision releases prior to PV7.3.0 SV100 (PV6.2.0 SV300): Release PV6.2.2 SV300 is not compatible with version 8 (v8). Based on our testing, prior releases would only need a minor tweak in your business rules (BR's) where you reference a "Literal Parameter". You would first need to upgrade your OneStream platform to version 8. From there, you will need to compile all your business rules (BR's). A list of error messages will be generated. For Tax Provision, you should get the following "Warning" message: CASE 1: As long as when you upgraded your OneStream platform to version 8, you let the Tax Provision Dashboard default to the following location: Workspace / Default / Maintenance Units / XFW Tax Provision (TXP) The fix is to replace all the "old" references to get a literal parameter as follows: The default workspace is just an empty Guid, so if you aren't using a custom workspace, Guid.Empty should work as the 3rd parameter while keeping everything else the same. CASE 2: If you are using a non-default workspace, the DashboardExtenderArgs has a property to get the workspace, for example using it like this: BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, false, args.PrimaryDashboard.WorkspaceID, "[YOUR DASHBOARD PARAMETER NAME GOES HERE]") Example: I want to get the literal parameter that is stored in a "non" Default Workspace. Note: The BR syntax that we are using below is only available starting in version 7.4.0 The syntax would be as follows: And if I write the "TestWorkspace" to the error log, I get the correct literal parameter: There will be several of these cases throughout all the business rule (BR) files. Note: If you have made additional customized enhancements to a prior release of Tax Provision, there may be other changes that are required to be v8 compatible.Bug - Schedule "06a Deferred Tax" - Input Open on Tax Losses and Tax Credits
This relates to releasePV7.3.0 SV100. 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. Reason: The column in the Cube View for Deferred Other 1 & 2 was renamed and we forgot to update the reference in the row template cube view where we override those columns. Before the Fix: Fix: Take the following column header name: Open the CV "Rows_Sch_06_TXP" Go to the following two rows and on theColumn Overridestab and add the ", TXP_DefOtherNonDscr_GI" on the row for "Column Range". It can be anywhere on the row. I put it just after the old column name. TXP_TaxLossesCF_Base TXP_TaxCreditCFTotal_Base And update these two rows: After the Fix:0likes0Comments