Troubleshooting the Schedules
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 406. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Debugging a Dashboard" The attached Word documentdescribes the common issues that you may encounter with Schedules / Forms not rendering correctly. There are some key areas in the Tax Provision Blueprint setup that drive the majority of the Schedule POV’s. Each schedule has a link to a KB article. These key areas are: Entity attributes UD1 Constraint UD7 Constraint UD1 Default Text 7 (check the spelling / make sure a comma is used as a delimiter) – check the Scenario type Text 8 (all base and parent entities must have a Text 8 for the Tax rules to execute) – check the Scenario Type UD1 attributes Text 1 (all base JD’s must have a Text 1) Text 2 (base level National JD when you are doing National group filing) WF attributes Text 1 (required for a National Group Filer, Local Group Filer and WF Filers) Text 2 (position 1 is required, position 2 is sometimes required) Text 3 (position 1, 2 and 3 are required) – make sure a comma is used as a delimiter These text fields must be set at the “Tax” scenario type at both the Forms base level workflow and at the base level parent workflow for the TXP_Actual and TXP_ActualRTP scenarios. For the current year Forecast scenarios, we recommend using “ScenarioType8” as the scenario type. For multi-year Forecast scenarios, we have placed-marked “Scenariotype7” as the scenario type. We walk you through the following schedules (use the links for each schedule): Troubleshooting - Schedule LP 01a Actual Nat GF - Enter Definitions Troubleshooting - Schedule LP 11a ActualRTP Nat GF - Enter Definitions Troubleshooting - Schedule LP 02a Actual Local GF - Enter Definitions Troubleshooting - Schedule LP 12a ActualRTP Local GF - Enter Definitions Troubleshooting - Schedule 01 Tax Rates - Filer WF's Troubleshooting - Schedule 01 Tax Rates - WF Entity Troubleshooting - Schedule 02 Set the Return Year Troubleshooting - Schedule 02 RTP Troubleshooting - Schedule DM 01a Actual Nat GF - Copy Definitions Troubleshooting - Schedule DM01b Actual Nat GF - Summary of the Definitions Troubleshooting - Schedule DM 02a Actual Local GF - Copy Definitions Troubleshooting - Schedule DM 02b Actual Local GF - Summary of the Definitions Troubleshooting - Schedule DM 11a ActualRTP Nat GF - Copy Definitions Troubleshooting - Schedule DM 12a ActualRTP Local GF - Copy Definitions The POV combo boxes (drop down lists) that are displayed in the toolbar for most schedules, run in a specific order. The combo boxes execute from left to right. You must first select an Entity. That will then refresh and update the list box for the UD1 Jurisdiction. Once you select a UD1 jurisdiction, the combo box for the UD7 Group Filing will be refreshed as well as the label for the UD4 Tax Type will be refreshed. Lastly, select a Group Filing entity. The Entity drives the UD1 Jurisdiction. The UD1 Jurisdiction then drives both the UD7 Group Filing and the UD4 Tax Type. Do not mix different country entities in a Workflow Profile. Each WF Profile is country specific. Group Filing countries must have a UD7 country hierarchy. UD7 base members and UD7 parent country members must be the same name/label/member as what is in the Entity dimension. BR’s take the base UD7 member and uses it as the base level entity member.Troubleshooting - Schedule DM 12a ActualRTP Local GF – Copy Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 430. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule DM 12a ActualRTP Local GF – Copy Definitions This dashboard is only used on the XFW_TXP_GLTaxAdmin workflow. It is only used to do a complete copy of Local group filing definitions for the RTP year from the TXP_Actual scenario to the TXP_ActualRTP scenario for period M12 (Dec). No input is permitted in the schedule. Dashboard Name SchDM12a_Actual Local Group Filings (TXP) Entity No entities are showing up in the rows of the CV: E#XFBR(TXP_ParamHelper, GetWFText2, position=1, Sort=Yes) UD1 Jurisdiction (JD) No Jurisdictions are showing up in the rows of the CV: U1#|!UD1_JD_WFText3_P1_LV_TXP!| defined as: XFBR(TXP_ParamHelper, GetWFText3, Position=1) Difference column This column is defined with the following syntax: GetDataCell(BR#[BRName=TXP_CV_CompareAnnotation, FunctionName=Compare, SourceScenario=TXP_Actual, DestScenario=TXP_Actual, GF=Local, SourceTime=|!SourceTimePeriod_TXP!|, DestTime=|!DestinationTimePeriod_TXP!|]):Name(“Difference”) Row Suppress on the Top CV In order to have suppress working in this CV, we have a hidden column that is defined with a dynamic UD8 member (TXP_LocalFiler) that populates a “1” when there are cell text / annotations. Suppression does not work on annotations; therefore, we need this hidden column to dynamically populates a “1” so that row suppression will work. This UD8 member BR is defined as follows:Troubleshooting - Schedule DM 11a ActualRTP Nat GF – Copy Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 430. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule DM 11a ActualRTP Nat GF – Copy Definitions This dashboard is only used on the XFW_TXP_GLTaxAdmin workflow. It is only used to do a complete copy of National group filing definitions for the RTP year from the TXP_Actual scenario to the TXP_ActualRTP scenario for period M12 (Dec). No input is permitted in the schedule. Dashboard Name SchDM11a_ActualRTP Nat Group Filings (TXP) Entity No entities are showing up in the rows of the CV: E#XFBR(TXP_ParamHelper, GetWFText2, position=1, Sort=Yes) UD1 Jurisdiction (JD) No Jurisdictions are showing up in the rows of the CV: U1#|!UD1_JD_WFText3_P1_LV_TXP!| defined as: XFBR(TXP_ParamHelper, GetWFText3, Position=1) Difference column This column is defined with the following syntax: GetDataCell(BR#[BRName=TXP_CV_CompareAnnotation, FunctionName=Compare, SourceScenario=TXP_Actual, DestScenario=TXP_ActualRTP, GF=Nat, RTPYear=|!RTPYears_TXP!|]):Name(“Difference”) Row Suppress on the Top CV In order to have suppress working in this CV, we have a hidden column that is defined with a dynamic UD8 member (TXP_NatFiler) that populates a “1” when there are cell text / annotations. Suppression does not work on annotations. Therefore, we need this hidden column to dynamically populates a “1” so that row suppression will work. This UD8 member BR is defined as follows:Troubleshooting - Schedule DM 02b Actual Local GF – Summary of the Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 429. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule DM 02b Actual Local GF – Summary of the Definitions This dashboard is only used on the XFW_TXP_GLTaxAdmin workflow. It is only used to show the Local group filing definitions for all periods in the workflow year. It has several compare columns to show any differences from the prior period. No input is permitted in the schedule. It shows all entities for all Local JD’s with suppressed rows with no data turned on. Dashboard Name SchDM02b_Actual Local Group Filings (TXP) Entity Entities are based on the following parameter: |!Tax_Entities_AllParents_TopEntity_TXP!| Defined as: XFBR(TXP_ParamHelper, Entities_Sorted_AllParents, Sort_Entities_TF=|!Tax_Entities_Sorted_TF_TXP!|) The “Alpha Sort” check box is based on the following parameter: |! Tax_Entities_Sorted_TF_TXP!| Difference column This column is defined with the following syntax: GetDataCell(BR#[BRName=TXP_CV_CompareAnnotation, FunctionName=Compare, SourceScenario=TXP_Actual, DestScenario=TXP_Actual, GF=Local, SourceTime=|!WFYearPrior1_M12_LV_TXP!|, DestTime=|WFYear|M1]):Name(“Mth / Mth”)Troubleshooting - Schedule DM 02a Actual Local GF – Copy Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 427. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule DM 02a Actual Local GF – Copy Definitions This dashboard is only used on the XFW_TXP_GLTaxAdmin workflow. It is only used to do a complete copy of Local group filing definitions from one time period to another. No input is permitted in the schedule. Dashboard Name SchDM02a_Actual Local Group Filings (TXP) Entity No entities are showing up in the rows of the CV: E#XFBR(TXP_ParamHelper, GetWFText2, position=1, Sort=Yes) UD1 Jurisdiction (JD) No Jurisdictions are showing up in the rows of the CV: U1#|!UD1_JD_WFText3_P1_LV_TXP!| defined as: XFBR(TXP_ParamHelper, GetWFText3, Position=1) Difference column This column is defined with the following syntax: GetDataCell(BR#[BRName=TXP_CV_CompareAnnotation, FunctionName=Compare, SourceScenario=TXP_Actual, DestScenario=TXP_Actual, GF=Local, SourceTime=|!SourceTimePeriod_TXP!|, DestTime=|!DestinationTimePeriod_TXP!|]):Name(“Difference”) Row Suppress on the Top CV In order to have suppress working in this CV, we have a hidden column that is defined with a dynamic UD8 member (TXP_LocalFiler) that populates a “1” when there are cell text / annotations. Suppression does not work on annotations. Therefore, we need this hidden column to dynamically populate a “1” so that row suppression will work. This UD8 member BR is defined as follows:Troubleshooting - Schedule DM 01b Actual Nat GF – Summary of the Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 426. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule DM 01b Actual Nat GF – Summary of the Definitions This dashboard is only used on the XFW_TXP_GLTaxAdmin workflow. It is only used to show the National group filing definitions for all periods in the workflow year. It has several compare columns to show any differences from the prior period. No input is permitted in the schedule. It shows all entities for the National JD with suppressed rows with no data turned on. Dashboard Name SchDM01b_Actual Nat Group Filings (TXP) Entity Entities are based on the following parameter: |!Tax_Entities_AllParents_TopEntity_TXP!| Defined as: XFBR(TXP_ParamHelper, Entities_Sorted_AllParents, Sort_Entities_TF=|!Tax_Entities_Sorted_TF_TXP!|) The “Alpha Sort” check box is based on the following parameter: |! Tax_Entities_Sorted_TF_TXP!| Difference column This column is defined with the following syntax: GetDataCell(BR#[BRName=TXP_CV_CompareAnnotation, FunctionName=Compare, SourceScenario=TXP_Actual, DestScenario=TXP_Actual, GF=Nat, SourceTime=|!WFYearPrior1_M12_LV_TXP!|, DestTime=|WFYear|M1]):Name(“Mth / Mth”)Troubleshooting - Schedule DM 01a Actual Nat GF – Copy Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 424. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule DM 01a Actual Nat GF – Copy Definitions This dashboard is only used on the XFW_TXP_GLTaxAdmin workflow. It is only used to do a complete copy of National group filing definitions from one time period to another. No input is permitted in the schedule. Dashboard Name SchDM01a_Actual Nat Group Filings (TXP) Entity No entities are showing up in the rows of the CV: E#XFBR(TXP_ParamHelper, GetWFText2, position=1, Sort=Yes) UD1 Jurisdiction (JD) No Jurisdictions are showing up in the rows of the CV: U1#|!UD1_JD_WFText3_P1_LV_TXP!|.Where(Text1 Contains TXP_National) defined as: XFBR(TXP_ParamHelper, GetWFText3, Position=1) UD7 Group Filer Entity No UD7 are showing up in the rows of the 2nd CV: U7#XFBR(TXP_ParamHelper, GetWFText3, position=3) Difference column This column is defined with the following syntax: GetDataCell(BR#[BRName=TXP_CV_CompareAnnotation, FunctionName=Compare, SourceScenario=TXP_Actual, DestScenario=TXP_Actual, GF=Nat, SourceTime=|!SourceTimePeriod_TXP!|, DestTime=|!DestinationTimePeriod_TXP!|]):Name(“Difference”) TXP_NatFileCalc column No “1.00” are showing up after the “Copy” icon has been launched: In order for the following rule to execute (TXP_NatFilerCalc), the following metadata setup is required: Scenarios must be either “TXP_Actual” or “TXP_ActualRTP” UD1 Text 2 on the National JD must contain “NatGF=Yes” The top CV must have some definitions defined Row Suppress on the Top CV In order to have suppress working in this CV, we have a hidden column that is defined with a dynamic UD8 member (TXP_NatFiler) that populates a “1” when there are cell text / annotations. Suppression does not work on annotations. Therefore, we need this hidden column to dynamically populate a “1” so that row suppression will work. This UD8 member BR is defined as follows:Troubleshooting - Schedule 02 RTP
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 423. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule 02 RTP Dashboard Name Sch02_RTP (TXP) Entity No entity is showing up in the drop-down box. Parameter used: WF_TaxEntities_WFText2_P1_TXP Defined as: {TXP_HelperQueries}{GetEntityText7_byWFTime}{} WF Text 1 – needs to contain “LocalGroupFiler=Yes” or “NatGroupFiler=Yes” WF Text 2 – needs to have the country level entity .Base (i.e. E#TXP_US_Total.Base) Base level entities Text 7 must contain “LocalFiler=Yes” and/or “NatFiler=Yes” UD1 Jurisdiction (JD) No Jurisdictions are showing up in the drop-down box: Parameter used: UD1_JD_Master_LV_TXP Defined as: XFBR(TXP_ParamHelper, DetermineUD1, ScenarioName=|WFScenario|, EntityName=|!WF_TaxEntities_WFText2_P1_TXP!|) WF Text 3 – position 1 (i.e., U1#TXP_US_Local.Base)Troubleshooting - Schedule 02 Set the Return Year
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 422. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule 02 Set the Return Year Dashboard Name Sch02_SetRTP (TXP) Entity No entity is showing up in the drop-down box. Parameter used: WF_TaxEntities_WFText2_P1_TXP Defined as: {TXP_HelperQueries}{GetEntityText7_byWFTime}{} WF Text 1 – needs to contain “LocalGroupFiler=Yes” or “NatGroupFiler=Yes” WF Text 2 – needs to have the country level entity . Base (i.e., E#TXP_US_Total.Base) Base level entities Text 7 must contain “LocalFiler=Yes” and/or “NatFiler=Yes” UD1 Jurisdiction (JD) No Jurisdictions are showing up in the drop-down box: Parameter used: UD1_JD_Master_LV_TXP Defined as: XFBR(TXP_ParamHelper, DetermineUD1, ScenarioName=|WFScenario|, EntityName=|!WF_TaxEntities_WFText2_P1_TXP!|) WF Text 3 – position 1 (i.e., U1#TXP_US_Local.Base)Troubleshooting - Schedule 01 Tax Rates – WF Entity
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 421. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule 01 Tax Rates – WF Entity Dashboard Name Sch 01_TaxRates (TXP) Entity No entity is showing up in the drop-down box. Parameter used: WF_TaxEntities_WFText2_P1_TXP Defined as: {TXP_HelperQueries}{GetEntityText7_byWFTime}{} WF Text 3 – needs to have the WF entities (i.e., E#Root.WFProfileEntities) UD1 Jurisdiction (JD) No jurisdictions are showing up in the cube view: Parameter used:UD1_JD_WFText3_P1_LV_TXP defined as: XFBR(TXP_ParamHelper, GetWFText3, Position=1) WF Text 3 – needs to have the country National jurisdiction (i.e.: U1#TXP_UK) Note: Only one National JD is available per country.