Knowledge Base Article

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:

 

Updated 9 months ago
Version 4.0
No CommentsBe the first to comment