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

Limit order quantity for customer

(1) Share

Report

Posted on by LA-17050840-0

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

Categories:

Dynamics 365 Business Central

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 74,280 Super User 2024 Season 2 on at

Like (0)

Report

Limit order quantity for customer

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
Alexander Drogin 16 on at

Like (0)

Report

Limit order quantity for customer

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

Valentin Castravet 25,058 Super User 2024 Season 2 on at

Like (0)

Report

Limit order quantity for customer

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Suggested answer

Khushbu Rajvi. 5,611 on at

Like (1)

Report

Limit order quantity for customer

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

Jun Wang 7,467 Super User 2024 Season 2 on at

Like (0)

Report

Limit order quantity for customer

you should be able to achieve this by setting up a workflow for sales order, triggered by customer, and qty
Suggested answer

Ramiz 402 on at

Like (1)

Report

Limit order quantity for customer

Hi,

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

Regards
Ramiz
xgaronnat 13 on at

Like (0)

Report

Limit order quantity for customer

A customization/development is required.