Small and medium business | Business Central, N...

Set Status field of Purchase Order to editable

(0) Share

Report

Posted on by ankhbileg01

Hello I'm trying to create approval workflow using Power Automate. After approved it needs to change Status of Purchase order. I have no issue in updating other field, but Status field is read only and giving me error. How to set status field editable ?

I have the same question (0)

All responses (13)

Answers (0)

Marco Mels on at

Like (0)

Report

Hello,

There are out of the box approval workflows that do this job for you on your behalf.

Thank you.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

Hi

have you tried in the power automate flow when a record is approved to retrieve the row with the ROW ID with the Update Row (V2) block and update in the status field? it should work

IF YES ->SEND an EMAIL -> Update record (V2)

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, As far as I know this field cannot be modified directly, you may need to call the standard method.

"Release Sales Document".PerformManualRelease(Rec);

PS: How to run AL procedure in Power Automate (Add custom execute actions)

https://yzhums.com/20111/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
ankhbileg01 5 on at

Like (0)

Report

Yes, I tried that method and this gives me an error. "Status field is read only".

I've used Update record V3

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (1)

Report

hi

I ran a test on my sandbox, setting up an approval flow with Power automate

the flow that is created if successful already sets the Status field to Released on the Sales Order

My Example:

as you can see, my Status field was modified without my adding a line of code

DAniele Incalza

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Thanks Great information.

Was this reply helpful? Yes No
ankhbileg01 5 on at

Like (0)

Report

I tried exactly same, but it gives me an error.

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hallo,

Are you able to reproduce this error in a standard unmodified database without any extensions?

Thank you.

Was this reply helpful? Yes No
ankhbileg01 5 on at

Like (0)

Report

This is fresh new database just created from CDX. I didn't install any extension, or data

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Okay, when I am in the office again (tomorrow, w. europe standard time), I will setup a new CDX environment and try the scenario myself. As soon as I have a result, I will let you know.

Thank you.

Was this reply helpful? Yes No