SageForum for UK versions of Sage 50- Help and support.

Hi
is it possible to put and MOQ on a certain product that flags up if an order is processed below that amount?
We have certain items we make that are bespoke and want to set a 200 Litre limited but haven't been able to work out a way for the system to do this
Thanks

MOQ = Minimum Order Quantity.

I am assuming you want to set a minimum quantity on the sales of a product.

There is no way to set a minimum quantity when selling a product.

There are ways to mitigate this.

1/ Use deep discounting and a qty level so that if you order less than the discount break you pay a fortune.

2/ Make the product into 200l then sell it as multiples of 200l e.g. 220l is 1.1 units

3/ Write a report/ Excel sheet to find any products that are below minimum qty and raise an alert. You could embed the minimum selling quantity in the product record somewhere and in the case of an Excel solution, run it as a scheduled task every so often and email warning to someone using some VBA

4/ If you are manufacturing this, then you could make this a check before placing the works order to make the stuff.

5/ With the minimum selling quantity embedded in a product record, you can print a big red warning on the Sales Order confirmation or the Works order or both.

6/ There are probably other ways, but would need to understand the issues better.