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 ?

All responses (13)

Answers (0)

Suggested answer

YUN ZHU 81,183 Super User 2025 Season 1 on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

Hi, just adding some info.

Microsoft Power Automate template (For example, Request approval for sales order)

https://yzhums.com/8295/

Hope this can give you some hints.

Thanks.

ZHU
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

For my two cents I think manually changing the status on purchase orders in our sales orders is a bad idea. There are functions within the system that are supposed to happen that will change that status it is a control point and it’s just not a good thing to make that field editable so that it can be changed by users or other processes
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

Hello,

Instead of Create a flow, you should use Manage Flows. You can then use a template, search Business Central and choose "Request approval for Dynamics 365 Business Central purchase order".

This will give you same experience as the others here have including me as I just tested the scenario.

Hope it helps.
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

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.
ankhbileg01 5 on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

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

Marco Mels on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

Hallo,

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

Thank you.
ankhbileg01 5 on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

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

Nitin Verma 21,544 Moderator on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

Thanks Great information.
Suggested answer

DAnny3211 9,276 Moderator on at

Like (1)

Report

RE: Set Status field of Purchase Order to editable

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
ankhbileg01 5 on at

Like (0)

Report

RE: Set Status field of Purchase Order to editable

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

I've used Update record V3