AX / Dynamics 365 For Finance and Operations blog

D365FO – AX – How to resolve error “Cannot edit a record in ….. table (….). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.”

This error usually occurs when you are trying to update a table, but the table was previously updated by another operation.

In this case it is advisable to call the reread () method of the table before updating.

Something like that : 

journalTable.reread(); //--> try this before update method
journalTable.NumOfLines = any2int(journalTrans.recId);
journalTable.selectForUpdate(true);
ttsBegin;
journalTable.update(); //Update method
ttsCommit;

More Posts

2 responses to “D365FO – AX – How to resolve error “Cannot edit a record in ….. table (….). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.””

  1. Cannot edit a record in Sales Orders (SalesTable). An update conflict occured due to another user process deleting the record or changing one or fields in the record D365 FO – Dynamics 365 Finance Community

    […] post: https://d365ffo.com/2021/05/13/d365ffo-ax-how-to-resolve-error-cannot-edit-a-record-in-table-an-upda…Also, refer another […]

    Like

    Reply
  2. Udit Avatar
    Udit

    But what if this update is triggering from multiple places , can we use reread() at multiple places ?

    Like

    Reply

Leave a comment

Blog at WordPress.com.