Error: inter-company balances are not netted off in group accounts in Accounts Production Advanced

Create consolidation credit and debit codes to allow you to net off inter company balances.

Scenario

Group accounts do not show the inter-company balances netted off in Accounts Production Advanced.

Solution

  1. Open the group company.
  2. Select
    Financial Period
    ,
    Configuration
    , then
    Accounts
    .
  3. Select
    New
    .
  4. Create a new code
    687.03
    and name it:
    Consolidation credit
    .
  5. Select
    OK.
  6. Create a new code
    687.04
    and name it:
    Consolidation debit
    .
  7. Select
    OK
    , then
    OK
    again.
  8. Select the
    Import / Account Assignment
    tab.
  9. Select the
    Account Assignment (Entity) Maintenance
    link.
  10. In the Entity Specific Account Assignment window, select
    Group entity
    from the
    Entity
    dropdown list.
  11. If the category codes are not shown, select
    Display category code
    from the
    Display
    dropdown list.
  12. Select code
    687.03
      and drag it to within category
    CA 2 3 – Receivables from related parties
    .
  13. Select code
    687.04
    and drag it to within category
    CL 1 3 1 – Amounts owed to group undertakings and undertakings in which the company has a participating interest
    .
  14. Select
    OK.
  15. Select the
    Account Assignment (Master) Maintenance
    link.
  16. Repeat steps 12 to 14.
  17. Select the
    Journals
    tab.
  18. Select
    New
    .
  19. In the new journal, use the
    Entity
    ellipsis button to select the group entity, then select
    OK.
  20. Post the inter-company journal debit to code
    687.04
    and the credit to code
    687.03
    to net off the amounts due to related parties.
  21. Select
    Close.