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.

Meet Ahmed Rafik - MCT from Egypt - Microsoft Feed - My Interview

You can read my Whole interview now on my Blog, The link of the interview is broken now, hope they fix it soon. Thanks for reading the whole interview.

1.       Tell us who you are?

I am Ahmed Rafik from Cairo-Egypt, Graduated from Faculty of Commerce, Ain-Shams University Bsc. In Accounting & Finance 2004, Achieved a Professional diploma in Accounting & Finance from American University In Cairo (AUC) ,  I worked as senior accountant for 4 years, then granted a Scholarship in ERP from Microsoft on “MS Great Plains 9.0”  funded by the Ministry of Communication & Information Technology,  I have been working as Microsoft ERP Consultant in the past 3 years. Founder of ERP-AXAPTA , which helps understanding what is ERP, by writing articles and making downloadable presentations and going in depth in MS Dynamics AX.

My philosophy, ERP is not a consulting Service, It is a Coaching Service. I like playing football, Tennis, Swimming and photographing, 

2.       Tell us about your MCT history, when were you first awarded, your competency?

Helping others online or offline is my desire, so I searched for my hidden talents and guess what; I am a trainer by nature, so I started deliver trainings for individuals & groups from 2008, My competences are MS Dynamics Great Plains 10, MS Retail Management System 2.0, MS Dynamics AX 2009 & MS Sure Step 2010.

3.       What do you do in order to keep up with latest tools and technologies?

As I am a Researcher Type, I don’t stop making searches over the Internet, User groups, Communities, Blogs & White Papers, and shared it with my colleagues, coping with the new technology to satisfy customer’s needs. 

1. What does being an MCT mean to you?

MCT means sharing, contribution, learning others and delivers Microsoft latest technology with a standard methodology and professional training.

5.       If you could ask Steve Ballmer one question about Microsoft, what would it be?

I would also ask Steve, "What makes Microsoft such a great place to work and an inspiration to come to work each day?"

6.       Had a chance to attend “MCT Summit”? When and how was your experience?

I don’t have the chance to attend MCT Summit

8.       What is in your computer bag?

Laptop, Charger, Headphones, Wireless Mouse, External HD, Self-Development Book, and a lot of papers and documents.

9.       If you get a chance to suggest one conference in your region? What would it be and why?

ERP Cloud Computing (SaaS) Software as a Service with MS Dynamics GP & AX to deliver the latest technology in ERP field.

10.   Which was the last book you read?

It was a technical book in a hard copy “SQL Reporting Services”, & Business Analysis Body of Knowledge “BABOK “.

If there was one place you could travel to, right now, where would it be and why?

San Francisco to attend MCT Summit 2011.

11.   Any Message you want to give to the readers of MicrosoftFeed?

Thanks for reading my interview, please feel free to contact me if you need any feedback regarding ERP Coaching and MS Dynamics AX.

"A person can succeed at anything for which there is enthusiasm." - Charles M. Schwab

kindly provide your contact information here

Website – www.ahmedrafik.com or http://arafik.blog.com

Blog - http://erpaxapta.blogspot.com

Email – Rafik139@hotmail.com

Twitter –  http://twitter.com/rafiko139

Facebook –  http://facebook.com/rafiko

LinkedIn – http://eg.linkedin.com/in/arafik

Conducted Seminar "Introduction to Microsoft Dynamics Family"

This was a little seminar conducted for sales executives on Microsoft Dynamics Family, Looking to help anyone interested in Microsoft Dynamics Family. I love it.
Photo have been taken by one of my friends and make little effects in the photo to seem to be old.

Workbook for Elicitation Techniques in Business Analysis:Download Free

I just need to share this information with you all, After along time of reading, researching and practicing, I decided to create this worksheet to summarize for you the information needed to understand what is Business Analysis, I hope this will help not only the Business Analysis Consultants but also the ERP Consultant.

I Noticed that this topic have a little resources in Arabic language, so i preferred to summarize it with the same language i read it.

Before going to the next sheets i just want to give you notes concern the business analysis itself. The argument is not the techniques and methods that you will conduct, Business analysis  depends on You.

Why You? ... Anyone can have all the books related to "Business Analysis" and read it, and also practice & conduct these techniques, but this is not the issue,  Books can offer the information needed and provide the guideline for you but will never give you the SKILLS.

You  have to consider your self as an instrument of change first, for all BA's and ERP consultants ,Your main Big Picture that you must have in any project or task is "CHANGE".  You are making a change in Organizations, Business, People's life and work, so you have to prepare yourself first to gain and develop your Interpersonal  skills, and then practice the techniques and methods that are mentioned in "UCD" Sheet. Business Analysis is only for Skilled people.

If you want to proceed in this sheet, i will give you few notes that can help you to be a Professional Business Analysis Consultant.

1- You cannot master something if you don’t understand what it is.

The International Institute for Business Analysis (IIBA™) defines business analysis as “The set of tasks and techniques used to work as a liaison among stakeholders in order to understand the structure, policies, and operations of an organization, and recommend solutions that enable the organization to achieve its goals.”

2-  Know Your Audience

Every human being communicates slightly differently. The successful BA understands that the first task on any new project is to get to know all of the significant participants and analyze their communication needs. Understanding people is the key to successful communication.

3- Know Business First

BAs work to understand the business environment of each project and be an advocate for the business people. The title Business Analyst is used to ensure the business focus.

You have to know the minimum understanding  and information for the common business fields

4- Know the Technology

Every BA & ERP Consultant  working on projects that touch technolgoy, so you have to know the application first, methodologies , life cycle & implementation methods

5- Know Your Analysis Techniques

And this is the practical guide for business analysis that we summarize here, and for more information you can refer  to "Guide to the Business Analysis Body of Knowledge® (BABOK® Guide).

Thanks and enjoy reading...

Download Now