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

Notifications

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 133 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,529 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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans