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

Add or Remove permission

(2) Share

Report

Posted on by SS-24070826-0

Hello Guys

How to set the user cannot reopen Sales orders with Released status.
I want the setting to be able to reopen Sales Orders with Released status only certain people.

Thank you

Sungkono

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

You could use security filter permissions to create a permission set with filtered sales orders with a released status.

After creating that certain permission set, add that to the users who will need to be able to reopen sales orders with status released.

You can read more about the security filter functionality at the links below.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/security/security-filters

https://yzhums.com/10133/

Greetings

Was this reply helpful? Yes No
Sagar Dangar, MCP 799 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

There is no standard functionality available for this requirement. you can do below small customization, and it will work for you.

Solution:

Create new column "Allow reopen SO" in "User Setup" page.

When user click on SO> "ReOpen", give error message if allow reopen is not flagged.

Result:

Only user with "Allow reopen" can reopen sales order, other people can't reopen SO

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,909 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

In Business Central, there's no standard setting to restrict reopening Released Sales Orders, but you can control this using permissions or a simple AL extension.

You can create a custom permission set that allows only specific users to modify the Sales Header table, though standard permissions don't support filtering by status. For better control, a small AL extension can block the reopening action based on user ID or role.

Hope this will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Jinal P. 300 on at

Like (1)

Report

Hello,

You have to write custom code for this, because Business Central doesn't have a built-in, specific permission for just “reopening,” so this method limits general editing capabilities unless further customization is added.

You can try this below code:

Please make as a answered if you get your answer.

Thank You.

Was this reply helpful? Yes No
SS-24070826-0 73 on at

Like (1)

Report

Dear All,

Thank you for your best support

Best Regards

Sungkono

Was this reply helpful? Yes No
Sagar Dangar, MCP 799 Super User 2025 Season 2 on at

Like (1)

Report

Hey @SS-24070826-0,

Please let community know which solution you applied, and it help you to fulfill your requirement.

Mark it as answer if you applied any of below provided solutions

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (1)

Report
To restrict reopening Released Sales Orders:

Permission Setup:

Create a custom permission set without "Modify" access to Released Sales Orders (Table 36).

Assign it to restricted users.

Approach for Allowed Users:

Keep SUPER or Sales Manager roles for authorized users.

Optional: Use Event Subscriber (e.g., OnBeforeReopenSalesDoc) to add extra validation.

If this helps, mark as verified! 🚀

Was this reply helpful? Yes No
SS-24070826-0 73 on at

Like (0)

Report

Dear Guy

I have added 2 permissions, namely: MKI-Reopen-SO & MKI-Released-SO, but when clicking “Send Approval Request” the following error appears

Was this reply helpful? Yes No
SS-24070826-0 73 on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report
My Recommendation

Security filter if that works. All in your control. Apply it and test it.

Customization. Adding code will do with some additional validations and custom error messages but developer dependent.

Altogether a new roles and permission sets.

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No