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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Business Central Sales...
Small and medium business | Business Central, N...
Suggested Answer

Business Central Sales Price restriction

(0) ShareShare
ReportReport
Posted on by weiching 247

Hello, 

I would like to control the Unit Price from Sales Price List or Item Price restrict user modify unit price from Sales entries such as Sales Quote, Order, Invoice etc.

On the Sales page, managed to see the unit price but cannot override.

I would appreciate if someone could advise or share on the experience.

Thank you.

Best Regard, 

Wei Ching

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 150 on at

    Two patterns I’ve seen adopted. One you have a field on the user setup to enable specific users to change prices. Acts as a manager override feature. Second is you have another field on the line level to display if a price has been changed. This then acts as a reporting feature to review by how much a sales representative altered the price to get the deal. Granted that this was in industries where the margin wasn’t wafer thin. If margins are sensitive you have wish to make the unit price field on the sales subform pages have an editable value of false.

    All of the described are done with modifications. Appsource may have a ready to go solution but do your research and trial it.

  • Suggested answer
    SRIJA Profile Picture
    SRIJA 5 on at

    Hello, Wei Ching

    I too have the same question regarding this topic. I would thanks for your advice if anybody helps.

    Regards,

    Srija,

    Microsoft CRM Developer

  • Kevin56936 Profile Picture
    Kevin56936 10 on at

    i think this article gives you the best answer for you questions on Business Central Sales Price restriction https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extending-best-price-calculations 

    Good Luck

    Thanks and Regards

    Kevin 

    Microsoft Dynamics Developer

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,583 on at

    The other option is to use the following app which can be utilize for this purpose. 

    https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.fenwicksoftware%7CAID.fg03%7CPAPPID.9c635c18-e65b-4aba-b78c-e35552de4c60?tab=Overview

  • Suggested answer
    natasha258 Profile Picture
    natasha258 5 on at

    this gives you the best info about price restrictions  community.dynamics.com/.../business-central-sales-price-restriction

    thanks

    MSBI Training In Chennai

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,821 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,122 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans