Error while creating Purchase order in Dynamics AX 2012

(0) Share

Report

Posted on by Faisal Fareed

10,796 User Group Leader

Hi friends,

I have been facing the below error while creating new Purchase order in AX 2012. I don't know why it is happening but after digging more into code it crashed while writing code in IL. Some web services running in this may causing this issue please give me any pointer how can I track this as I don't have much idea web services in AX 2012.

NOTE: This error is coming in only one company and I am able to create PO in other companies.

Cannot create a record in Purchase orders (PurchTable). Purchase order: COM-0000XX, COM-00XXXX.

The record already exists.

Microsoft.Dynamics.Ax.Xpp.DuplicateKeyException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.DuplicateKeyException' was thrown.

at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)

at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.insert(IntPtr table)

at Microsoft.Dynamics.Ax.Xpp.Common.doInsert()

at Dynamics.Ax.Application.PurchTableType.Insert(Boolean _interCompanySilent, Date _accountingDate, Boolean , Boolean ) in PurchTableType.insert.xpp:line 21

at Dynamics.Ax.Application.PurchTable.Insert(Boolean _interCompanySilent, Date _accountingDate, Boolean , Boolean ) in PurchTable.insert.xpp:line 7

at Dynamics.Ax.Application.PurchTable.@Insert(Boolean _interCompanySilent, Boolean )

at Dynamics.Ax.Application.PurchTable.Insert(Boolean _interCompanySilent)

at Dynamics.Ax.Application.PurchCreateOrderForm.writeOnServer(Object[] _params) in PurchCreateOrderForm.writeOnServer.xpp:line 25

at PurchCreateOrderForm::writeOnServer(Object[] )

at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)

at Dynamics.Ax.Application.SysDictClass.invokeStaticMethod(Object[] _params) in SysDictClass.invokeStaticMethod.xpp:line 26

at SysDictClass::invokeStaticMethod(Object[] )

at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)

at Microsoft.Dynamics.Ax.Xpp.PredefinedFunctions.runAsInvoke(String className, String staticMethodName, Object[] parms, Object[]& exportInfolog)

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Tim Schofield on at

Like (0)

Report

Check the setting on the purchase order number sequence. If it's set to continuous - switch that off

Was this reply helpful? Yes No
Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

Thanks for your reply. Number sequence is not set to continuous.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Did you find reason behind this? I have same type of error but different table.

Was this reply helpful? Yes No
Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

Randy, please create your own thread and explain your problem there (with all details that you omitted here).

Was this reply helpful? Yes No
jgracak on at

Like (0)

Report

Hi Faisal,

Did you check the SystemSequences recID for purchase orders? I had the same problem of corrupted RecId and the system trying to create the same RecId for documents that already existed.

Kind regards,

Josip

Was this reply helpful? Yes No
Anton Venter 20,345 Super User 2025 Season 2 on at

Like (0)

Report

Hi Faisal, are there any custom indices on the table that might be causing this? If not then it's probably the purchid or recid values that already exist in the table. To find out, check the highest values of these fields and compare them to the number sequence and the sydtemsequence.

Was this reply helpful? Yes No
Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

Guys, Faisal created this thread in year 2012; I don't think he is still waiting for your answers.

Was this reply helpful? Yes No
Verified answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

Hi All,

I created this thread in 2012 and I don't recall what was the actual issue and how did I resolve it exactly. It was not related to RecId and indexes in system, for these points I am sure as I checked these points before posting the question. As per my gut feelings this was related to CIL genertion issue.

If anyone is having such type of issue please raise start new thread as Martin suggested.

Was this reply helpful? Yes No