I would like to copy a company in AX 2012. In 2009 it was under, Administration > Common Forms > Company Accounts > Duplicate.
It is deprecated. Quote from depreceated features doc:
Reason for deprecation: The underlying architecture of Microsoft Dynamic
AX 2012 was modified, and these modifications
required the duplicate company feature to be
Replaced by another feature: No. The feature is no longer available, and there
is no replacement feature.
Although there is no replacement duplicate
company feature, a company can still be used as
a template to create other companies. By using
the import and export feature, users can create
duplicate reference, setup, and master data by
copying data between two companies. For demo
data, the import and export feature can be used
to replicate a company from one environment in
another environment, or in the same
environment. Users can also make further
changes to create an appropriate demo scenario
in the new company.
Something missing in the answers to this question is "What options should be used in the Import / Export functionality to properly copy a company"? I have had difficult time trying to figure this out. Every time I try to copy a company from another environment, I end up messing up my data and need to re-install to get it working agian. If you don't choose the correct options, then shared table information will be missing or overwritten. It would be nice if MS would write a white paper outlining how to do this properly. Perhaps a definition group could be provided with all of the nessasary tables to copy a company.
There is a suggestion how to do this in the introduction to AX 2012 training materiel chapter 5 page 20 but this is just not working with the new AX 2012 architecture. I would really appreciate that MBS prepared a whitepaper regarding this issue.
There was a blog post released yesterday that explains the process, you can access it via this link: community.dynamics.com/.../copy-company-data-in-ax-2012.aspx
Note - the area of the application referenced in the blog post is located within system administration > Common > Data Export/Import
The blog post gives a general idea of how to do the copy but does not provide specifics on eactly which parameters to choose when exporting and importing (ie. Import system tables). Be very careful using this approach to copying companies and ensure that you perform a database backup first. The process can corrupt your database entirely.
I know this is an old post, but I stubled over it because is 'AGAIN' was searching to see if anybody found a working solution to duplicate a company :)
The fact is that there is not, the reason for this is that in AX2012 there are many tables that have the property savedPerCompany set to No, but at the same time a lot of these tables have a record record for each company (indicated by a new added field holding the company Id, this field is called Name and the extended datatype for it is LedgerName), an example of this is the table 'Ledger', but there are many more tables structured the same way.
So the problem when exporting data from a company in an AX instance and importing it into another company in the same instance, is that you have to import WITHOUT shared tables, but the result of that is that all tables that are structured the way I just mentioned will now be missing a record for the the company you imported into, i.e. the table LEdger should have a record with the companyId of the company you imported into in the Name field, but it doesn't. Now you could of course manually create this record (like I saw in another post that somebody recommended), but there are so many other tables with the same problem and you would have to find a way of doing the same to all those.
You can't do this in AX 2012.
I would try creating additional partition and then copy data from old partition to newly created one. In this case all companies would be copied to new partition. I haven't done partition-> partition copy in practice, but it shouldn't be very hard. There are article called "Copy Data From One Partition To Another Using The Data Import Export" but I would go with Test Data Transfer Tool ;-)
UXC Eclipse has actually built this exact functionality and are now offering it as an add-in. We have customers with more than 80 subsidiaries with new legal entities being created all the time. These customers need the ability to spin up new companies quickly based on a template configuration. There is a user interface similar to the old company copy in AX 2009 and prior, but of course requires slightly more setup due to the data model changes in AX 2012. Please reach out if you would like to know more.
Is it the same functionality as described here?
Not the same functionality.
UXC Eclipse add-in has been done differently. It leverages entities concept.
The one on my blog is a little crude by using dat/def. It is making a lot of assumptions. Read the blog post carefully.