http://ax2012exceldataimport.blogspot.com/2012/01/dynamics-ax-2012-customers-import-using.html
Assumption: The assumption is that appropriate reference data such as customer groups, etc. was created in advance.
Customers
[Description: image]
Walkthrough:
Connection
[Description: image]
Add Data
[Description: image]
Dynamics AX Error
[Description: image]
Add Tables
[Description: image]
Field Chooser
[Description: image]
CustTable
Field Name
Field Description
Currency
Customer account
Customer group
Name.Party ID
[Description: image]
Customer account - Number sequence
[Description: image]
DirPartyTable (Person)
Field Name
Field Description
Name
Party ID
Party type
Display as
[Description: image]
Address book ID - Number sequence
[Description: image]
LogisticsLocation
Field Name
Field Description
Location ID
Name or description
Postal address
[Description: image]
DirPartyLocation
Field Name
Field Description
Effective:
Location.Location ID
Name.Party ID
Expiration:
Postal address
[Description: image]
DirPartyLocationRole
Field Name
Field Description
Location role.Role
Party location relationships.Effective:
Party location relationships.Location ID
[Description: image]
LogisticsPostalAddress
Field Name
Field Description
Country / region
Effective:
Location.Location ID
State
County
City
District
Street
ZIP / postal code
Expiration:
[Description: image]
LogisticsElectronicAddress
Field Name
Field Description
Effective:
Location.Location ID
Type
Contact number / address
Expiration:
[Description: image][Description: image]
Sequence:
1. DirPartyTable - Publish Selected
2. LogisticsLocation - Publish Selected
3. DirPartyLocation - Publish Selected
4. DirPartyLocationRole - Publish Selected
5. LogisticsElectronicAddress - Publish Selected
6. LogisticsPostalAddress - Publish Selected
7. CustTable - Publish Selected
Result:
Dynamics AX - Address book
[Description: image]
Dynamics AX - Address book Address
[Description: image]
Dynamics AX - Address book Contact information
[Description: image]
Dynamics AX - Customer
[Description: image]
Dynamics AX - Customer Address
[Description: image]
Dynamics AX - Customer Contact information
[Description: image]
SQL Trace:
Summary: For the purposes of small or medium data migration (data conversion) where performance is not a concern Excel can be used for import of customers into Microsoft Dynamics AX 2012. Although Customer AIF Web Service (CustCustomerService) can't be used at the moment in Excel for import of customers, appropriate tables can be used instead. Excel template can be created and used for import of customers.
Posts
2 comments:
I read a lot of stuff and i found that the way of writing to clearifing that exactly want to say was very good so i am impressed and ilike to come again in future.Microsoft Dynamics Consulting
Greate! intersting information, this is really helpful for Microsoft Dynamics AX Support Consultant You always provide best information for your viewers. Thank you so much for sharing this with us.
Post a Comment