Cannot edit a record in Inventory transactions (InventTrans). 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 Gary Woodcock

260

AX 2012 R2

When I start the following process > Inventory and Warehouse > Periodic > Close and Adjust > Recalculation

It never finishes and gets block so to speak with the following infolog message

"Cannot edit a record in Inventory transactions (InventTrans). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record"

This looks to be a major worry, looks to be data integrity is not there.

Any help on how to fix and importantly why I would be seeing this message.

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

André Arnaud de Cal... 299,923 Super User 2025 Season 2 on at

Like (0)

Report

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

Hi Gary,

I have not seen this error message before.

Are there some customizations? Which inventory model are you using?

Do you have one AOS or more? On which AOS does this job run?

Do you run this task in batch? How many helpers did you specify? What is the setting for batch threads on the server (setting within AX)?

Is it the first time you run this task or did it run correctly before?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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

Hi Every body, I got exactly the same error in AX 2012 R2 CU7.

Cannot edit a record in Inventory transactions (InventTrans).

An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

I found this

Solution 742864 Error when recalculate stock (update conflict)

AX VERSION

Microsoft Dynamics AX 2012

PROBLEM

When running Inventory recalcuation, the following error message is being displayed:“Cannot edit a record in Stock transactions (InventTrans). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.”

MITIGATION

1. This error might be caused by locking. On the InventTrans table, the Property “OCCEnabled” is currently set to “Yes”. Temporarily set this property = “No” and run the Recalculation when there is minimal activity on the system. Preferably, get all users to logoff and then re-run the Recalculation. By setting this property = “No”, locking will still occur but the system will prevent other users from updating the record until you have released your lock. After running the Recalculation and if the error no longer occurs, you can reset this parameter to its original value.

2. The error message that you receive: “Cannot edit a record in Inventory transactions (InventTrans). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record” might be caused by Marking when you have a receipt transaction marked to multiple issue transactions. Please check if you have Marking on any of the concerned items. Then remove the marking on this item and re-run the Recalculation.

3. Restart the AOS to clear any caching issues that may be causing this error.

4. Cancel the previous Recalculation and then run again together.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

I suggest you need to check if you have any customization related inventory management.

try to analyse the customization.

it seems the customization is not working properly

Please verify and update with your finidngs

Was this reply helpful? Yes No
Gary Woodcock 260 on at

Like (0)

Report

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

Hi Guy’s

Sorry for the late reply and thanks for your input – much appreciated.

We are running with just one AOS, we have no modifications (apart from Reporting) – we went with a total Vanilla approach. We are 8 months in from go-live and will be looking at development work some time later. The task is run manually.

The problem actually fixed itself when we moved our support to a new company as I’m now more advanced in AX I believe that they were “fudging” the table to fix an issue we had at the time with Catch Weights.

FYI – Dynamics AX has a small footprint in New Zealand compared to the rest of the world and it seems we have a lack the broad skillset; the company I am dealing with at the moment is recruiting offshore skills to try and fill that gap.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,923 Super User 2025 Season 2 on at

Like (0)

Report

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

Hi Gary,

Thanks for the feedback. I'm glad it is solved. Fudging in inventory transactions is very tricky when you don't have the expertise of the storage logic and datamodel. I have seen many wrong customizations, some bugs and wrong correction on this area. I think the company you are dealing with is wise to find the knowledge needed outside their company. That's worth a "thumb-up".

Was this reply helpful? Yes No
Choon Fatt Ho 425 on at

Like (0)

Report

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

Hi,

May I know where actually you found this because I cannot find this from Internet.

Thank you.

Was this reply helpful? Yes No
Leor 5 on at

Like (0)

Report

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

This solved my problem:

2. The error message that you receive: “Cannot edit a record in Inventory transactions (InventTrans). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record” might be caused by Marking when you have a receipt transaction marked to multiple issue transactions. Please check if you have Marking on any of the concerned items. Then remove the marking on this item and re-run the Recalculation.

Problem is to find the exact transaction. I found 2 orderlines marked to the same produktion order, and only partley marked. Clearing the mark and remark solved my problem.

Was this reply helpful? Yes No
DimanC 113 on at

Like (0)

Report

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

you can find it in LCS.

fix.lcs.dynamics.com/.../Solution

not all sites are google-indexed, especially partner-specific :)

Was this reply helpful? Yes No
Swathi Sampath 45 on at

Like (0)

Report

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

The second step worked for me. Thanks a ton.

Swathi Sampath

Was this reply helpful? Yes No
BAIBOY 40 on at

Like (0)

Report

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

Hi guys,

Good day!

I just want to know if the provided answer is applicable in all cases of the same issue? because I have a problem also with the same issue appeared however my case is different from the Recalculation. I wanted to post the consumption and do the issuance of the items but the error appeared stated that: "Cannot edit a record in inventory journal table (InventJournalTable). An update conflict occured due to another user process deleting the record or changing one or more fields in the record."

I already tried to check the said table but I don't know if what specific lines where i'm gonna check. Please help me with this. Thank you so much

Was this reply helpful? Yes No