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

Limit order quantity for customer

(2) ShareShare
ReportReport
Posted on by 64
Hello all, I got a question from customer: Is there a possibility, to limit order quantity for an item for specific market? Example: Customer from Slovenia orders 200p of item A, but we set a limit of 50p for Slovenia, so BC only allows 50p on sales order. It this possible todo in standard or is development needed here?
Thanks
I have the same question (0)
  • xgaronnat Profile Picture
    40 on at
    A customization/development is required.
  • Suggested answer
    Ramiz Profile Picture
    597 on at
    Hi,

    As far as I know, standard doesnt offer this kind of functionality and requires customization.



    Regards
    Ramiz
  • Suggested answer
    Jun Wang Profile Picture
    8,202 Super User 2025 Season 2 on at
    you should be able to achieve this by setting up a workflow for sales order, triggered by customer, and qty
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,647 Super User 2025 Season 2 on at
    limiting the order quantity for a specific customer or market (such as a country) is not a standard feature out of the box. However, you can achieve this with custom development.
  • Suggested answer
    Valentin Castravet Profile Picture
    31,505 Super User 2025 Season 2 on at
    As mentioned this is not standard functionality. You could either customize the system to do it, or set up approval workflows where every order will need to be sent for approval, and the workflow will check the quantities. 
  • Alexander Drogin Profile Picture
    262 on at
    Community opinion has split on this one - we have "custom development" and "workflows" options. And probably both are correct. :-)
    It is possible to setup a workflow for this kind of scenario, but devil is in the details, and we don't know all the details of the task you have at hand.
     
    Create a new workflow from a template, select the "Sales Order Approval Workflow". You can tweak the parameters to filter orders where Bill-to or Ship-to Country Code is Slovenia and lines include "Item A" in quantity exceeding 50 pcs. So you can set it up to automatically reject any orders within the filter and approve everything else.
    So far so good. But this is only one country and one item. If these conditions must apply to hundreds of items in a dozen different countries, you'll have to set up a separate workflow for each of them. Probably not a configuration you want to implement and maintain. In this case it will be a customisation.
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,748 Super User 2025 Season 2 on at
    Agree with Alexander.
    If you use the standard features, you can use the Credit Limit (LCY)...It will send a warning but will not block the process.
     
    Hope this helps as well.
    Thanks.
    ZHU

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,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans