DM 10a Admin – Provision Data: National to National Group Filer

The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 192.

See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100"

See KB article: "Data Integration"

Dashboard DM 10a Admin – Provision Data: National to National Group Filer

• Select a WF entity, a National Jurisdiction, and a Group Filer entity (UD7) that you want the National Provision (Preparation) data to be copied into.
• If the “All Entities” check box is selected, then all the entities in the combo box and all the UD7 members associated to each entity will be copied or cleared. It does not matter what is in the POV; the check box supersedes the POV. We refer to this as a “bulk” copy or clear.
• If the “All Entities” check box is not selected, then only the POV selected in the combo boxes will be copied or cleared.
• The bottom section of the toolbar will update with a “timestamp” with the last time a “bulk” copy or clear was executed. The timestamp will not be updated if the “All Entities” check box is not selected.
• After a copy is completed, a 1 is entered to account TXP_Data_Copy_10a
• A Cube View is supplied in the dashboard to show the user which Entity and National Jurisdiction has been copied to which Entity, National Jurisdiction, Group Filer entity (UD7).
• In order to keep the data in balance, we have created a reversal UD7 member that is only populated / cleared with rules.
• There are two columns that show any variances. The first makes sure that there are no variances with the data that was copied and the second makes sure the reversal account is populated and that we are not double counting data.

• We have created a flow member called “TXP_ConfirmBal_001” that just holds the copied flow members. This parent member is strictly used to expand or collapse a row in the CV. The aggregated value is meaningless but shows you where there is data.

 

Here is an example of how the UD7 reversal members works: