Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
I can sucessfully import main accounts using the "MainAccount" entity.
In Addition to the level of main accounts "Chart of accounts" I'd like to Import data per legal entity (companies). Any idea how this can be done?
The company specific fields are included in the MainAccount entity. These field are handled by a method 'GenerateMainAccountLegalEntity' as you can see in the target mapping. I'm not sure if an option is missing.
Without creating a new entity for company specific fieds, you can use the MainAccount entity again and change the company before copying the data to the target.
Then the MainAccount itself will be updated (or leave these fields blank) and the data per legal entity should be imported into the correct company.
André Arnaud de Calavon | Microsoft Dynamics AX Solution architect | My blog | My company
This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.
thanks a lot for your hint. It helped.
IImportant: the flag "Run Business validations" has to be set - otherwise the data will not be inserted in the MainAccountLegalEntity table.
Also you need to charge the field COAType with value Yes into the source file to force the creation/modification of values in MainAccountLegalEntity.
Also works with dimensions.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics