Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
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...
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.
We are having the same problem. How can we get the hotfix?
Hi Tor,
You have to call your partner in order to get the hotfix. The hotfix did not work for me!!
Hi all,
If the Hotfix did not resolve this issue for you please open a support request so the support team can investigate further.
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.
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.
Dave B
How to change the index not to be unique on both Customer and Vendor tables? I am facing same error.
Thanks.