Showing posts with label DataareaId. Show all posts
Showing posts with label DataareaId. Show all posts

Thursday, 14 February 2013

Company or Legal entity (DataAreaID) in Dynamics Ax



In Dynamics AX we can use same the information for different Companies (or legal entities). Even though all the data is stored in same physical database, Axapta will determine which data is associated with which company:
·                     Axapta manages this by using the system field dataAreaId to define which company the data belongs to.
·                     Company or a legal entity can be said as a record in the CompanyInfo table.
·                     dataAreaId field will be found in each and every table which is used to store data create/updated from an Axapta form.
·                     And whenever a new record is added, dataAreaId is automatically initialized to the current company id.
·                     Whenever a user requests to view data from forms and reports or when the application fetches data using a select statement, Axapta will always return data from the current company, as a filter for dataAreaId is automatically added by the kernel.
·                     All the created companies will be stored in System Table name DataArea.

The below are few areas where multiple companies is useful:

1.            If we wish to train new staff, we can create a new ‘test’ company to perform various examples at the same time the ‘live’ data is not damaged.
2.            You may wish to have a ‘planning’ or ‘budget’ company where you can prepare future business models.
3.      You may have more than one physical company that handles completely different business, but uses the same systems functionality. You can have separate information to support each company