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: