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

Discount

(6) Share

Report

Posted on by CU26090923-0

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

All responses (7)

Answers (0)

Suggested answer

Andrés Arias 1,380 on at

Like (1)

Report

Discount

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
Suggested answer

Sohail Ahmed 4,829 on at

Like (1)

Report

Discount

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

Mansi Soni 5,684 on at

Like (3)

Report

Discount

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
Suggested answer

Jainam M. Kothari 10,094 on at

Like (1)

Report

Discount

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.
Suggested answer

Kamal Khakhkhar 858 on at

Like (2)

Report

Discount

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
Suggested answer

Ahmad Subhani 275 on at

Like (1)

Report

Discount

Go to the Workflows and in the Condition add the Percentage in Line Discount Field:
SP-29040942-0 141 on at

Like (2)

Report
Discount

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!