Microsoft Dynamics AX (Archived)

Customer not imported due to duplication, but it can't be found in AX

(0) Share

Report

Posted on by Community Member

as i have searched in ax, there is no such customer account exists

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: additional info---No customer account in ax

Ok, that is great, but what is the issue then?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: additional info---No customer account in ax

I have an issue when copying data to target in data import/export framework.

I get an error message that says Data written to target 'Customer' ('0' records created, '0' records updated)

additional info in infolog says record already exists but when i checked in A/R all customers as per my screenshot, there is no such customer account

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: additional info---No customer account in ax

Hi,

Have you double checked your import data especially the company to which you import them?

Best regards,

Ludwig

Was this reply helpful? Yes No
ax Financial 740 on at

Like (0)

Report

RE: additional info---No customer account in ax

Hi Jet_07,

In the import file the fields are not mapped correctly due this customer were not imported.

please check the import file and try once again importing the data from excel.

other wise muanally create the customer in AX 2012.

With Regards,

AX Financial

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

RE: Customer not imported due to duplication, but it can't be found in AX

Hi,

Please perform the following steps:

i. Check the data in the table custTable, to see if there is any record with the specified customer account exists.

If yes, delete it.

ii. Try to manually create the customer(the one which seems to have error) and see if you are able to create it.

If yes, check whether you are supplying all the mandatory fields in custTable entity to create the customer

through DIXF.

If no, check if there is any custom index (or) custom code in validateWrite/insert method on custTable, that is

blocking the creation.

iii. Give a try with different customer account through DIXF, see if it can be imported successfully.

If yes, then there is some data issue with your earlier customer account.

If no, then check if there is any custom validation/code present in that method insertUpdate of class

DMFCustomerEntityClass

iv. If none of the above steps work, debug the DMF by placing breakpoint in the code

\Classes\DMFCustomerEntityClass\insertUpdate.

Hope this helps you.

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No