web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to add Unit price Discount in Business central

(3) ShareShare
ReportReport
Posted on by 336
Dear Members,
 

In Business Central, I have a sales line with a Unit Price = 4 and Quantity = 200, which gives a total of 800.I need to apply a unit price discount of 0.20 per unit, so the effective unit price becomes 3.80, and the line amount becomes 760.

However, when I use the standard Line Discount % / Line Discount Amount, Business Central shows the discount as a total line discount of 40, not as a per-unit discount.

 

My requirement is:

  • Unit Price should still display as 4

 

  • A separate column should show the unit discount (0.20 per unit)
     
  • Line amount should calculate as 760.

Is there any standard way in Business Central to display unit-level discount separately?




Thanks in advance,
Sneha

I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    6,351 on at
    Hello,
     
    Business Central supports only line-level discounts, not unit-level discounts. The Line Discount Amount is always stored and shown as a total for the line, and there is no standard field to display a per-unit discount (like 0.20 per unit). If you need a separate “Unit Discount” column while keeping Unit Price = 4 and Line Amount = 760, this requires a custom calculated field (Line Discount Amount ÷ Quantity). There is no out-of-the-box way to do this.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,603 Super User 2025 Season 2 on at
    Business Central does not support unit-level discount display in standard functionality. Discounts are always applied at line level. To show a separate unit discount column, customization is required.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans