Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

MOQ on a product

Sage 50 general help forum - Free help and support for all general issues
Post Reply
SharonW
User
User
Posts: 1
Joined: 10 Oct 2019, 14:15
Sage Version: Other

MOQ on a product

Post by SharonW » 10 Oct 2019, 14:18

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: MOQ on a product

Post by brucedenney » 10 Oct 2019, 14:39

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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 23 guests