web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cannot Create a record...
Microsoft Dynamics AX (Archived)

Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

(0) ShareShare
ReportReport
Posted on by Mahmoud Dimassi 415

Hi,

Our Data was recently migrated from AX 4.0 SP2 to AX 2012. When i try to create a new customer for the first time, the customer gets created. If I try to create a new customer the second time the error pops up. If i go back and delete the customer I created. The customer gets deleted successfully. If i recreate the customer, the customer is saved but if i try to create a second customer the error pops up. This happens only when i create a new customer the secnd time around. I am creating the customer from the Accounts Receivable --> Common --> Customers --> All Customers. I don't have any duplications in the CUSTTABLE nor in the DIRPARTYTABLE. I also reset the user datausage which did not do anything. Any help would greatly be appreciated. Thanks... 

*This post is locked for comments

I have the same question (0)
  • David Bader Profile Picture
    David Bader on at
    Re: Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

    Hi Mahmoud,

    I believe that you are running into quality report 314169 which has to do with how SQL is handling the temp tables being used in the Customer creation process.

    In order to obtain the HotFix (KB2729982) related to this issue a support request will need to be created.  We are not able to give HotFix details out in the forums.

    I hope this information is helpful to you. Please post again if the Community can be of assistance.

    Have a great day!

    Dave B.

  • Tor Nyrén Profile Picture
    Tor Nyrén 60 on at
    Re: Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

    We are having the same problem. How can we get the hotfix?

  • Mahmoud Dimassi Profile Picture
    Mahmoud Dimassi 415 on at
    Re: Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

    Hi Tor,

    You have to call your partner in order to get the hotfix. The hotfix did not work for me!!

  • David Bader Profile Picture
    David Bader on at
    Re: Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

    Hi all,

    If the Hotfix did not resolve this issue for you please open a support request so the support team can investigate further.

    Have a great day!

    Dave B.

  • Tor Nyrén Profile Picture
    Tor Nyrén 60 on at
    Re: Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

    Hello,

    I have worked with Microsoft support, but they could not help me.

    I figured it out myself. Maybe it can help other customers/partners, so here is what I found:

    When migrating from AX4 using standard migration software (included in AX2012 release, we used CU3), the system creates a field on CustTable and VendTable called DEL_PartyId. The system fills this field with values when migrating. The system also creates a unique index on that field.

    When using standard AX2012 to enter customers or vendors, this field is left blank. This is why you can only enter one record. When trying to create the second record, it can not be done because of the unique index!

    I changed the index not to be unique on both tables, and now we can create customers and vendors without problems.

  • David Bader Profile Picture
    David Bader on at
    Re: Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

    Hi Tor,

    Thank you for posting your resolution to the error message Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists.  This is great information that will hopefully help other Community members out in the future.

    Have a great day!

    Dave B

  • Titus Issac Profile Picture
    Titus Issac 5 on at
    Re: Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

    Hi Tor,

    How to change the index not to be unique on both Customer and Vendor tables? I am facing same error.

    Thanks.

  • Customer Master Profile Picture
    Customer Master on at
    RE: Cannot Create a record in Customers (CustTable). Customer account:'ABC', 'ABC'. The record already exists

    I modify the table TaxInformationCustTable_IN found one blank row. delete this row and problem is solved

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans