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 document describes 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 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 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 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 LP 02a Actual Local GF – Enter Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 414. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule LP 02a Actual Local GF – Enter Definitions This schedule is only used on “xxx_LocalGroupFiler” workflows and must be completed before you can enter tax rates for Local JD’s in schedule 01. The first column in this CV is hidden and uses a dynamic UD8 member (TXP_LocalFiler) which populates a “1” on any rows that contain Annotations (cell text). This is required for the suppression to work because suppression only works on data and not on cell text. Dashboard Name SchLP02a_Local Group Filings (TXP) UD1 Jurisdiction (JD) No jurisdictions are showing up in the drop-down box: Parameter used: UD1_JD_WFText3_P1_TXP defined as: U1#XFBR(TXP_ParamHelper, GetWFText3, Position=1) WF Text 3 – needs to have the country level Local jurisdiction . Base (i.e. U1#TXP_US_Local.Base) Entity No entities are showing up in the rows of the CV: E#XFBR(TXP_ParamHelper, GetWFText2, position=1, Sort=Yes) Local Filer Entity (Column 1) No entities are showing up in the drop-down list: The account used in this column is “TXP_LocalFiler”. Only entities that have a Text 7 that contain “LocalFiler=Yes” with display in the list. The Cell Type is defined as a “Combo Box”. Tax Rates Used (Column 2) Only when the Entity and the Filer Entity (UD7) are the same will you be able to select the type of rate used. The account used in this column is “TXP_LocalFilerType”. You must make a selection in column 1 first and then save it before column 2 is available for a selection. Two options are available: Filer Rates or Individual Rates. The Cell type is defined as a “Combo Box”. No Input rules are used to limit when you can make a selection in column 2.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 LP 01a Actual Nat GF – Enter Definitions
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: "Troubleshooting the Schedules" Schedule LP 01a Actual Nat GF – Enter Definitions This schedule is only used on “xxx_NatGroupFiler” workflows and must be completed before you can enter tax rates for the National JD in schedule 01. The first column in this CV is hidden and uses a dynamic UD8 member (TXP_NatFiler) which populates a “1” on any rows that contain Annotations (cell text). This is required for the suppression to work because suppression only works on data and not on cell text. After this schedule has been completed, click on the populate icon to execute a BR (TXP_NatFilerCalc) that then populates a trigger account in the 2nd cube view. This is used to facilitate other National BR’s (specifically – Schedule 05_06NationalBenefitLocalCurrency). Dashboard Name SchLP01a_Nat Group Filings (TXP) UD1 Jurisdiction (JD) No jurisdictions are showing up in the drop-down box: Parameter used: UD1_JD_WFText3_P1_TXP defined as: U1#XFBR(TXP_ParamHelper, GetWFText3, Position=1) WF Text 3 – needs to have the country National jurisdiction (i.e., U1#TXP_CA) Note: Only one National JD is available per country. Entity No entities are showing up in the rows of the CV: E#XFBR(TXP_ParamHelper, GetWFText2, position=1, Sort=Yes) National Filer Entity (Column 1) No entities are showing up in the drop-down list: Account used in this column is “TXP_NatFiler” Only entities that have a Text 7 that contain “NatFiler=Yes” with display in the list. The Cell Type is defined as a “Combo Box” Tax Rates Used (Column 2) Only when the Entity and the Filer Entity (UD7) are the same will you be able to select the type of rate used. The account used in this column is “TXP_NatFilerType”. You must make a selection in column 1 first and then save it before the second column is available for a selection. Only “Filer Rates” is available for National GF. The Cell type is defined as a “Combo Box”. No Input rules are used to limit when you can make a selection in column 2. Lower Cube View In order for the Populate copy BR to execute and populate the lower CV, the National jurisdiction for the country in question must have a text 2 of “NatGF=Yes”. The BR looks for this setting to execute the BR: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 LP 12a ActualRTP Local GF – Enter Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 417. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule LP 12a ActualRTP Local GF – Enter Definitions This schedule is only used on “xxx_LocalGroupFiler” workflows and must be completed before you can enter tax rates for Local JD’s in schedule 01. The first column in this CV is hidden and uses a dynamic UD8 member (TXP_LocalFiler) which populates a “1” on any rows that contain Annotations (cell text). This is required for the suppression to work because suppression only works on data and not on cell text. The first two columns for TXP_Actual are there for informational purposes and are read-only. Dashboard Name SchLP12a_Local Group Filings (TXP) UD1 Jurisdiction (JD) No jurisdictions are showing up in the drop-down box: Parameter used: UD1_JD_WFText3_P1_TXP defined as: U1#XFBR(TXP_ParamHelper, GetWFText3, Position=1) WF Text 3 – needs to have the country level Local jurisdiction . Base (i.e. U1#TXP_US_Local.Base) RTP Year No RTP Years showing up in the drop-down box: Parameter used: |!RTPYears_TXP!|M12 Defined as: XFBR(TXP_ParamHelper,RTPYears) Available years are: >= Seed Year and < Workflow Year Entity No entities are showing up in the rows of the CV: E#XFBR(TXP_ParamHelper, GetWFText2, position=1, Sort=Yes) Local Filer Entity (Column 3) No entities are showing up in the drop-down list: Account used in this column is “TXP_LocalFiler” Only entities that have a Text 7 that contain “LocalFiler=Yes” with display in the list. The Cell Type is defined as a “Combo Box” Tax Rates Used (Column 4) Only when the Entity and the Filer Entity (UD7) are the same will you be able to select the type of rate used. The account used in this column is “TXP_LocalFilerType”. You must make a selection in column 3 first and then save it before the fourth column is available for selection. Two options are available: Filer Rates or Individual Rates. The Cell type is defined as a “Combo Box”. No Input rules are used to limit when you can make a selection in column 2. Changed (Column 5) This column uses a BR to determine if there is a difference between columns 1 & 2 when compared to columns 3 & 4. It is only used for informational / analytical purposes. The Cell type is defined as a “Combo Box”. The parameter is defined as: This column uses a dynamic calc U8 member: “TXP_LocalFiler_Changed_ActualRTP”.Troubleshooting - Schedule LP 11a ActualRTP Nat GF – Enter Definitions
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 411. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Troubleshooting the Schedules" Schedule LP 11a ActualRTP Nat GF – Enter Definitions This schedule is only used on “xxx_NatGroupFiler” workflows and must be completed before you can enter tax rates for the National JD in schedule 01. The first column in this CV is hidden and uses a dynamic UD8 member (TXP_NatFiler) which populates a “1” on any rows that contain Annotations (cell text). This is required for the suppression to work because suppression only works on data and not on cell text. The first two columns for TXP_Actual are there for informational purposes and are read-only. Dashboard Name SchLP11a_Nat Group Filings (TXP) UD1 Jurisdiction (JD) No jurisdictions are showing up in the drop-down box: Parameter used: UD1_JD_WFText3_P1_TXP defined as: U1#XFBR(TXP_ParamHelper, GetWFText3, Position=1) WF Text 3 – needs to have the country National jurisdiction (i.e., U1#TXP_CA) Note: Only one National JD is available per country. RTP Year No RTP Years showing up in the drop-down box: Parameter used: |!RTPYears_TXP!|M12 Defined as: XFBR(TXP_ParamHelper,RTPYears) Available years are: >= Seed Year and < Workflow Year Entity No entities are showing up in the rows of the CV: E#XFBR(TXP_ParamHelper, GetWFText2, position=1, Sort=Yes) National Filer Entity (Column 3) No entities are showing up in the drop-down list: The account used in this column is “TXP_NatFiler”. Only entities that have a Text 7 that contain “NatFiler=Yes” with display in the list. The Cell Type is defined as a “Combo Box” Tax Rates Used (Column 4) Only when the Entity and the Filer Entity (UD7) are the same will you be able to select the type of rate used. The account used in this column is “TXP_NatFilerType”. You must make a selection in column 3 first and then save it before the fourth column is available for a selection. Only “Filer Rates” is available for National GF. The Cell type is defined as a “Combo Box” No Input rules are used to limit when you can make a selection in column 2. Changed (Column 5) This column uses a BR to determine if there is a difference between columns 1 & 2 when compared to columns 3 & 4. It is only used for informational / analytical purposes. The Cell type is defined as a “Combo Box”. The parameter is defined as: This column uses a dynamic calc U8 member: “TXP_NatFiler_Changed_ActualRTP”.
