15.6.1.3.4 GL Level Reconciliation (If GL Level is selected in the Settings Tab)

This section describes settings in the Target Parameters tab if the GL Level option is selected in the Settings tab.

1. Select the following details:
   Target Entity

   • Target Entity Name: Select the name of the entity that contains the data from the drop-down list.
   • GL Reconciliation Column: Select the reconciliation column from the drop-down list. The selected column name appears as a card with Target Parameters, Filters, and Delete icons.
   • Threshold Currency: Select the Threshold Amount of currency from the drop-down list.
2. On a selected GL Reconciliation Column card, click the Target Parameters icon.
3. Provide the following Target Parameter details:
   Target Parameters

   • Threshold Specification: Select Percentage or Absolute from the drop-down list. If you select Percentage, the Threshold Currency field is disabled.
   The threshold value can be in either absolute or percentage at a PP level. However, If the selection in all the PPs is percentage, the Threshold Currency field is disabled.

   • Negative Threshold: Specify the negative threshold value. These values are used to identify the breach types, categorized as:
     • Negative Percentage Threshold (NPT)
     • Positive Percentage Threshold (PPT)
     • Negative Absolute Threshold (NAT)
     • Positive Absolute Threshold (PAT)
     • Not Breached (NB)
   The breach type is identified at run time during the reconciliation process and audit trail entries are posted with this information. For GL Level reconciliation, values can be updated at different PP levels. For Map Level reconciliation, you have to manually enter only one value for all the PPs.

   • Adjustment Entry Floor: Specify the value required to pass an adjustment entry. If the (GL-PP) difference is less than the Adjustment Entry Floor value specified here, the calculated difference is not eligible for the adjustment, and the entry is not logged in the Adjustment Entry table.
   • Positive Threshold: Specify the Positive Threshold value. These values are used to identify the breach types, categorized as:
     • Negative Percentage Threshold (NPT)
     • Positive Percentage Threshold (PPT)
     • Negative Absolute Threshold (NAT)
     • Positive Absolute Threshold (PAT)
     • Not Breached (NB)
   The breach type is identified at run time during the reconciliation process and audit trail entries are posted with this information. For GL Level reconciliation, values can be updated at different PP levels.
   Filter: Select the currency to specify the Threshold Amount. Additionally, click the Filter pane to add more details to the additional dimensions selected.
   You can also add filters to the optional dimensions (product, business unit, and so on) defined in the Settings tab. A comparison between the GL source system and PPs is based on the filters set on these dimensions. See the following steps to add filters:

   1. Click the Filters from the drop-down list.
   2. Select the relevant dimension from the Filters pane.
   3. Click the selected dimension, which enables a second drop-down list to select the relevant members for the dimension under consideration.
4. Click Next.