الأحد، 25 مارس، 2012

Consolidation AX 2009



1-    Create a new consolidated company named "CON".
"The Parent Company"

The following procedures:
-         Path: Administration > Common Forms > Company Accounts.
a-     Click "New" or Ctrl+N to create the new consolidated company.
b-    Enter the code & the name of the new company.
c-     Click "Save" Button.

2-    Setup Consolidated Company Accounts

  
The following procedures:
-         Path: General Ledger > Setup > Parameters.
-         Mark consolidated company accounts checkbox "Parent Company"

3-    Setup currencies in Consolidation Company.

 The following procedures:
-         Path: General Ledger > Setup > Exchange Rates.
a-     Click "New" or Ctrl+N to create the all new currencies.
b-    Enter Currency code, Name and symbol of the currencies.
c-     Click "Save" button to save all you did in this window.

4-    Setup the basic currency of the consolidation company.
  
The following procedures:
-         Path: Basic > Setup > Company Information.
1.     Click "Other" Tab in the windows appeared.
2.     Click currency drop box and select the desired basic currency.
3.     Click "Save" button to save all you did in this window.

5-    Match subsidiary accounts to the consolidation company accounts


The following procedures are made in the subsidiary companies:
-         Path: General Ledger > Chart of Accounts > General Tab.
o   All accounts of subsidiary companies are linked to the accounts of Consolidation Company.
o   From General tab, go to consolidation account field and enter the account code in the consolidation company.
o   Click "Save" button to save all you did in this window.
6-    Run the consolidation

The following procedures are:
-         Path: General Ledger > Periodic > Consolidation > Consolidation Online
o   Before you going to run the consolidation, you have to make sure of the following:
                                                                         i.      All accounts of the subsidiary companies and the consolidation company are linked correctly.
                                                                       ii.      All accounts are linked with each other with the same account type in all companies.
                                                                    iii.      All accounts are unmarked with "Locked in Journal".
                                                                    iv.      Backup all companies before running the consolidation.

o   From Criteria tab select the following:
a.     Select Range of accounts that will be consolidated.
b.     Select date range to determine the period to be consolidated.
c.      Mark "Consolidation Account" checkbox.
d.     Click Company Tab to select the companies that will be involved in consolidation.
o   Click "OK" button to run the consolidation.