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

15.6.1.3.10 Adjustment Attributes

Here is an example that briefly explains the Adjustment Attributes functionality.

Sample data has dimensions lv code, ccy code, and gaap code. The ownership type attribute is used as an Adjustment Attribute.

v_account_number v_lv_code v_ccy_code v_gaap_code n_eop_bal v_ownership_type v_default_1
Acc01 LE1 USD USGAAP 4000 IND A
Acc02 LE1 USD USGAAP 2000 JOINT B
Acc03 LE1 USD USGAAP 3000 JOINT C

Assuming the source balance is 9300, the following are the differences created are as follows.

Source Balance Target Balance Difference
9300 9000 300

The following adjustments are posted considering the ownership type column into the granularity.

Two unique values, IND and JOINT are used to split the differences and create adjustments.

For Adjustment 1, ownership type is IND and the balance is (4000/9000)*300.

For Adjustment 2, ownership type is JOINT and the balance is ((2000+3000)/9000)*300.

v_account_number v_lv_code v_ccy_code _gaap_code n_eop_bal (diff) v_ownership_type v_default_1
GL_01 LE1 USD USGAAP 133.33 IND

A
GL_02 LE1 USD USGAAP 166.66 JOINT A