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

Discount

(6) Share

Report

Posted on by CU26090923-0

132

How do I limit discount percentage in business central. How do I set a maximum discount whereby a user cannot exceed the value set.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

SP-29040942-0 235 on at

Like (2)

Report
You can set up an approval workflow in Business Central and add a condition based on the Line Discount % or Invoice Discount % field.

🛠️ Example Use Case:

If a user enters a Line Discount > 20%, the document automatically goes for approval.

Only a manager or authorized user can approve and post it.

🧩 Steps (Summary):

Go to Workflows.

Create or edit a Sales Document Approval Workflow.

Add a condition in the workflow trigger like: "Line Discount %" is greater than 20

Assign the approval user group.

This ensures that users can enter the discount, but they can’t post or send the document without approval if it exceeds the allowed percentage.

Let me know if you want help writing that condition or setting it up!

Was this reply helpful? Yes No
Suggested answer

Ahmad Subhani 585 on at

Like (1)

Report

Go to the Workflows and in the Condition add the Percentage in Line Discount Field:

Was this reply helpful? Yes No
Suggested answer

Kamal Khakhkhar 1,282 on at

Like (2)

Report

Hii there,

some times in some company not using approvals so in that case you can add a validation on field of Line if Line Discount % > LimitPercentage then error
sample code is attached Below you can Update as per your requirement.

[EventSubscriber(ObjectType::Table, Database::"Purchase Line", OnBeforeValidateEvent, "Line Discount %", false, false)]

local procedure MyProcedure(var Rec: Record "Purchase Line")

begin

if not rec.IsTemporary then

if rec."Line Discount %" > 20 then Error('You can not give discount More then 20 %');

end;

if you found answer mark it answered.

Thank You,

Kamal Khakhkhar

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

I agree with the Experts that you can add the Workflow for the same OR else you can Custom the AL Code for Allow Max. Percentage of Discount.

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report

Hello,

There is no built in functionality available for limit discount percentage in business central. As suggested by other professionals you can manage it either with an approval workflow or you can go for AL Customization.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Agreed with @Mansi Soni Suggestions & @Kamal Khakhkhar AL Code

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,190 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

I agree with my colleagues. There is no standard functionality that allows this, you can rely on flow or development.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No