الأحد، 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.

Elimination Transactions

Wow .... I am very excited now to share with this feature in AX 2009. Do you feel !!HOT!! now? Get the energy now to know about ELIMINATION Transactions.
Let's start ...

Elimination Rule. (Manual)
Elimination transactions are required when a parent company conducts business
With one or more subsidiary companies and uses consolidated financial reporting.
Some transactions that occur between the companies must be eliminated because
Consolidated financial statements must only include transactions that occur
between the consolidated entity and the other entities outside the consolidated group.

1.     Determine the Elimination Company.

The following procedures are:
-         Path: General Ledger > Setup > Parameters > Ledger Tab
o   Mark the "Elimination Company" checkbox.
o   Note: Elimination Company means to be the consolidated company.
o   Source company: The Company in which the amounts to eliminate reside.
o   Destination Company: The Company in which the elimination journal is created & posted.


2.     Create ledger elimination rule.

The following procedures are:
-         Path: General Ledger > Setup > Posting > Ledger elimination rule
1.     Click "New" or Ctrl+N to create new rule.
2.     Enter a unique identification in the "Rule" field.
3.     Enter a description for the new rule.
4.     Select the destination company.
5.     Enter range of dates that elimination will be effective from in the fields "Effective Start Date" & "Effective End Date".
6.     Mark "Active" checkbox.
7.     From "General Tab" select the journal name from Journal Setting field.
8.     Click "Line" Button to open new window, will appear as following:
a)     Click "New" or Ctrl+N.
b)    Select "Net Change" as an elimination method.
c)     Source Account: Enter the account the amount will be eliminated from.
d)    Destination Account: Select from drop down list "Source or User Specified"
e)     You can select also the destination dimension.

3.     Create elimination journal Proposal.

The following procedures to start elimination Process are:
-         Path: General Ledger > Journals > Elimination
-         The process of the elimination conducted from the consolidation company.
                                                                   i.            Click "New" or Ctrl+N to create new journal.
                                                                 ii.            Click the "Lines" button.
                                                              iii.            Click the "Proposal" button.
                                                              iv.            Click "Elimination Proposal".
                                                                 v.            Select the source company from Source company field.
                                                              vi.            Select the Elimination rule.
                                                            vii.            Enter the beginning and ending dates which ledger amounts will be retired for elimination.
                                            viii.            Enter the posting date of the elimination journal in posting date field.
                                                              ix.            Press "OK" button to run the consolidation.