Skip to main content

Posts

Showing posts with the label Virtual companies

Dynamics Ax Virtual Company & Table Collections

This article describes how Dynamics Ax Virtual Company and Table Collection work. We will also discuss how to move data from normal company to virtual company when you introduce virtual company in existing Ax implementation. Virtual Company: Dynamics Ax stores data as per company in tables. But there might be occasions when you want to share data across companies, like country, state, zip codes data. This sharing of data is achieved by creating a virtual company and storing data in this virtual company. Normal companies are then configured to read/write data from this virtual company. The only purpose of virtual company is to share data across companies, you cannot log into this virtual company. Before seeing how to do virtual company setup, I would like you to show another trick that can be used to share data across Ax. There is a property on Ax tables called " SaveDataPerCompany ", you can use this property to save data globally in Ax. To share data set ...

Cleaning up your Virtual companies

Often consultants create virtual companies and forget to trough away the old data. This can become an issue when migration to a newer version of dynamics AX gets involved. For example if the CustTable & VendTable become virtual, have the old data no PartyID number and the unique index on this column can’t be enabled. The easiest way for removing these obsolete records is using sql script. I have added an example. Imagine a table collection with CustTable and VendTable. This table Collection is used in Virtual Company DMOV. Company DMO1 and DMO2 uses this virtual company. In case the records in CustTable and VendTable were not deleted for company DMO1 and DMO2, the next SQL script will help you: delete FROM [AX2009_SP1_Dev] . [dbo] . [CustTable] where DATAAREAID in ( 'DMO1' , 'DMO2' ) delete FROM [AX2009_SP1_Dev] . [dbo] . [VendTable] where DATAAREAID in ( 'DMO1' , 'DMO2' ) But what happens if the customer decides not to use...