Updating the TAR Form Validations Member Formula

If a column was added to the TAR report, you need to update the TAR form to add the column. The Closing Balance (c) should equal the Ending Balance (a).

To update the TAR form with the Validations Member Formula:

  1. From the Home page, click the Navigator icon Navigator icon, and then under Create and Manage, click Dimensions.
  2. On the Dimensions tab, under Dimension, select the Movement dimension.
  3. Expand TRCS_System Validations, then select TRCS_TARValidations.
    Under Movement dimension, select TRCS_TARValidations
  4. Follow this Example when updating the formula.

    EXAMPLE: Adding Deferred Tax Closing Balance (c) for the PensionNCA column in TAR form.

    Create ELSEIF conditions based on the requirement in case of PensionNCA:

    "ELSEIF(@ISMBR("PensionNCA"))

    “<Source Temp diff Account"->"FCCS_ClosingBalance"->"TRCS_NonCurrentAssets";"

    Complete formula:

    @CALCMODE(BOTTOMUP);

    IF(@ISMBR("TRCS_TARF_Calc"))

    IF(@ISIDESC("TRCS_AllNational"))

    IF(@ISMBR("TRCS_TARFDeferredNonCurrentAssets") )

    "TRCS_NDefTaxNetVA"->"FCCS_ClosingBalance"->"TRCS_NonCurrentAssets";

    ELSEIF(@ISMBR("PensionNCA"))

    "Pension"->"FCCS_ClosingBalance"->"TRCS_NonCurrentAssets";

    ELSEIF(@ISMBR("TRCS_TARFDeferredNonCurrentLiabilities"))

    "TRCS_NDefTaxNetVA"->"FCCS_ClosingBalance"->"TRCS_NonCurrentLiabilities";

    ELSEIF(@ISMBR("TRCS_TARFDeferredVANonCurrent"))

    "TRCS_VATotal"->"FCCS_ClosingBalance"->"TRCS_Tax";

    ENDIF

    ELSEIF(@ISIDESC("TRCS_AllRegional"))

    IF(@ISMBR("TRCS_TARFDeferredNonCurrentAssets") )

    "TRCS_RDefTaxNetVA"->"FCCS_ClosingBalance"->"TRCS_NonCurrentAssets";

    ELSEIF(@ISMBR("TRCS_TARFDeferredNonCurrentLiabilities"))

    "TRCS_RDefTaxNetVA"->"FCCS_ClosingBalance"->"TRCS_NonCurrentLiabilities";

    ELSEIF(@ISMBR("TRCS_TARFDeferredVANonCurrent"))

    "[TRCS_RDefTaxNatTotal].[TRCS_RVATotal]"->"FCCS_ClosingBalance"->"TRCS_Tax";

    ENDIF

    ENDIF

  5. After updating the member formula, click Validate to ensure there are no errors.
  6. Click Save,
  7. Under Actions, select Refresh Database.

    Tip:

    If you notice a degradation in performance after adding multiple validation conditions, consider limiting the number of validation conditions.