How to Solve “update not allowed for field” Error with Data Entries in Dynamics 365 Finance and Operations

By Jeremy Dobler | October 3, 2022

While working with a Data entity for Dual-write and Data migration recently, I came across this error: “Results. update not allowed for field ‘’Personnel number(PersonnelNumber)””

Picture1

Luckily, I was able to identify a workaround to help deal with this error.

First, I'll take a step back and show you the setup of my entity. The primary datasource in this entity is the Customer table with a read-only reference to the HCM worker table based on the RecIds.

Picture2

This is a normal setup you see in any entities within Finance and operations. People will never know the actual RecID, so we create a link to the referenced table and expose the reference primary key field (in my case it is the Personnel Number). The internal logic will then query the correct value and set the RecId for you when inserted into the database.

In researching this issue, I found that the “Personnel Number” field is set to Allow Edit No. This is why I get the error within my data entity even though it is read-only.

Picture3

The workaround for this issue is rather simple. In my data entity, I simply set the Allow Edit property to Yes for my PersonnelNumber field.

Picture4

As soon as I made that property change the field validation passed and my entity executed properly. This change is a very low risk given the data source is read-only.

Picture5

I hope this guide helps you if you encounter this issue during your development.

Questions?

Please reach out to us! We have a team of experts ready to help you.


Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.

Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!