Finance | Project Operations, Human Resources, ...

Edit a field in a record

(0) Share

Report

Posted on by mohamd.dhaif

Hi Team,

I just have a question with regards to the un-editable fields in records that belongs to forms which has a workflow on it, one case that I faced is that a user has submitted a record in a certain form which later he requested to edit a field in that record and since it's submitted I can't edit the filed in that record to the correct value.

This case happen in the production environment, and as you know we cannot access the DB in the production environment.

I come across a solution which I heard but I'm not sure how the implementation of it how it goes in X++, what I heard is that to edit a record in the production environment, you have to use "Batch Jobs" to trigger a runnable class in which this will help to edit the specified field in that record to be updated with the desired value needed.

Another solutions for this which I heard and it was implemented in the newer versions of Dynamics365 F&O is by using something called "Custom Scripts" which is provided within "System Administration" Module.

My question is: How to achieve this?, is there a tutorial for this case? or if you can guide me with the way of doing it and the x++ code used to achieve this.

Thanks

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

omesh 141 on at

Like (1)

Report

Hi Mohamd,

Please check below link. Which explains how to run the custom scripts. Hope this will help you.

https://d365fokartik.home.blog/2022/06/03/run-custom-x-scripts-with-zero-downtime-d365-finance-and-operation

Thank You,

Umesh.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (1)

Report

Hi mohamd,

Check whether you can achieve this by using open in excel functionality.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Dinaz 115 on at

Like (1)

Report

Hi,

If the workflow is not approved. The reviewer can reject it for the user to re-edit the fields.

You can also customize few fields and make it editable even after its approved in this way you can maintain the database log.

Was this reply helpful? Yes No
mohamd.dhaif 50 on at

Like (0)

Report

Hi omesh

Thank you so much for your response, I tried the tutorial offered on the link you provided, I tried it and it works for me and I saw the changes on the record targeted, but after I click: "Purpose resolved"

This message appears to me and it rolls back the changes made.

What is the issue?

Thanks again

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,109 Most Valuable Professional on at

Like (1)

Report

The error is about your code, you must be using the tts wrongly.

Maybe you should share your code used to update the record.

Please use rich formatting ->insert -> code , while pasting your code here.

Was this reply helpful? Yes No
mohamd.dhaif 50 on at

Like (0)

Report
This code is written to update "Courses groups" table.

public static void main(Args _args) { HcmCourseTypeGroup courseTypeGroupTutorial; if (curExt() != 'BH') { throw error("This script must run in the BH Company!"); } select forupdate courseTypeGroupTutorial where courseTypeGroupTutorial.CourseTypeGroupId == 'Testing Course'; if(courseTypeGroupTutorial.RecId) { ttsbegin; Info("Processing start"); courseTypeGroupTutorial.CourseTypeGroupId="TGroup-Edited2"; courseTypeGroupTutorial.doUpdate(); Info("Processing end"); ttsbegin; } }

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,109 Most Valuable Professional on at

Like (0)

Report
Hi,

In your code, you have ttsbeggin twice without a ttscommit. In addition, you should enclose your operation in between the beggin and the commit.

public static void main(Args _args) { HcmCourseTypeGroup courseTypeGroupTutorial; if (curExt() != 'BH') { throw error("This script must run in the BH Company!"); } ttsbeggin; select forupdate courseTypeGroupTutorial where courseTypeGroupTutorial.CourseTypeGroupId == 'Testing Course'; if(courseTypeGroupTutorial.RecId) { Info("Processing start"); courseTypeGroupTutorial.CourseTypeGroupId="TGroup-Edited2"; courseTypeGroupTutorial.doUpdate(); Info("Processing end"); } ttscommit;

Was this reply helpful? Yes No
mohamd.dhaif 50 on at

Like (0)

Report

Thank you Komi Siabi,

Might be the tutorial I've followed they put this for the purpose of not modifying data for who's trying to test the code provided, I'll be testing it and get back to you confirming.

Was this reply helpful? Yes No