1. Accounting Foundation Cloud Service Core Functions
  2. Balance Reconciliation
  3. Reconciliation Rules
  4. Define Reconciliation Rules
  5. Add a Reconciliation Definition
  6. Allocation

15.6.1.3.7 Allocation

The Allocation tab is not applicable for General Ledger to Management Ledger.

Configure the following Allocation settings:
  • Adjustment Allocation: Select Automatic if you want the application to pass automated adjustment entries, else select Manual.
  • Adjustment Posted to: Select the target table where the adjustments are to be posted, that is, select Product Processor if the adjustment entry must be posted to the Product Processor selected in the Product Processor Parameter window, else, select Other.
  • Target Entity: Based on the selections made in the preceding two fields, the Target Entity is disabled or enabled. Select the appropriate option.
  • Adjustment Rule: Select the Adjustment Rule .
  • Allocation Amount Column: Is enabled or disabled based on the Adjustment Posted To option selected. Balance Attribute.
  • Allocation Ratio: If adjustment entry is to be passed to more than one PP entity, specify the ratio at which this entry is to be passed.
  • Adjustment Attributes: Use this field to split the adjustments further based on the non-dimension columns of the Target table. The reconciliation definition differences that arise from the definition execution can be adjusted back to the target table, based on the values of non-dimension columns. This can be done apart from the dimension columns.
For post adjustments with more granularity, perform the following steps:
  1. Click the hierarchy icon under Adjustment Attributes.
  2. Click inside the box. Search and select the attributes from the list.
  3. Click Done.
  4. Click Save.
Do not select these attribute types from the Adjustment Attributes list:
  • Reconciliation Dimensions
  • Number Data Type Columns
  • Date Data Type Columns

Note:

Reconciliation differences are created based on reconciliation dimensions alone but not on the Adjustment Attributes selected.

Adjustment Attributes play a role in creating adjustments with the differences that are observed. The values in the selected Adjustment Attributes of the participating columns of aggregation are read and based on the unique combination of values in these attribute columns, adjustments are created and the same values default in the respective adjustments. The reconciliation definition differences are split among the adjustments based on the weighted average ratio of the participating target balance values.

For more information about Adjustment Attributes and an example, see 'Adjustment Attributes'.

Topics:
  • Map Level Reconciliation (if Map Level Reconciliation is selected in the Settings tab)
  • GL Level Reconciliation (if GL Level Reconciliation is selected in the Settings tab)