Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

(0) Share

Report

Posted on by Ahmed Saad

Hello All

When I'm trying to create a purchase order from released purchase order --> consolidation opportunities .

I got this error - [ Cannot edit a record in Purchase orders (PurchTable).
An update conflict occurred due to another user process deleting the record or changing one or more fields in the record. ]

this error only shown up when I select any vendor have an purchase agreement.

Can any one help please ?

All responses (12)

Answers (0)

Suggested answer

Maged Abd ElSalam 5 on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

search for any update() or delete() methods and add reread() method before it for example:

purchTable.reread(); //--> try this before update method

purchTable.selectForUpdate(true);

ttsBegin;

purchTable.update(); //Update method

ttsCommit;
Suggested answer

Xusheng on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

Try to debug to code to find which process will update purchtable.

BTW , you also can log a service request to working with Microsoft support team to find the RCA together
Suggested answer

Xusheng on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

Try to debug to code to find which process will update purchtable.

BTW , you also can log a service request to working with Microsoft support team to find the RCA together
Ahmed Saad 25 on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

there's no code and customization at this cycle, also it's only happened when I choose any vendor having a purchase agreement only.

but with any vendor doesn't have purchase agreement it's working normally
Ahmed Saad 25 on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

There's no any customization there for this cycle.
Xusheng on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

Did you try to debug the code to find the RCA? Does this happened for all purchase orders?
MuthukumaranAX 2,907 on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

are there any customization done ? can you check is there any update code written?
Ahmed Saad 25 on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

Hello Ludwig,

Yes, we using the latest version and all of latest hotfixes are installed.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

Hello Ahmed,

Are you running the latest AX2012 version and have all of the latest hotfixes been installed?

Best regards,

Ludwig
MuthukumaranAX 2,907 on at

Like (0)

Report

RE: Cannot edit a record in Purchase orders (PurchTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

Yes, the blog is described about sales order scenario. please look at the provided sample and take necessary measures accordingly.

let me know if that helps to resolve the issue