Sales Order Process – Microsoft Dynamics GP SKU quantity management

  • Sales Order Process – Microsoft Dynamics GP SKU quantity management

    Posted by Jill Valerio on February 20, 2024 at 2:24 pm

    Sales Order Process – Microsoft Dynamics GP 2021 (18.4 1384)

    We have many SKU’s with different quantity order minimum requirements. Is there a way within GP to have this managed at order entry level? Example if you enter a SKU and the quantity ordered by the Customer doesn’t meet the correct divisible shelf pack minimum can the system warn you? Further information if SKU# XYZ must ordered in quantities of 12 and the Customer orders 10 or maybe 15 the system will warn you ?

    Chris Donnelly replied 3 months ago 2 Members · 1 Reply
  • 1 Reply
  • Chris Donnelly

    February 26, 2024 at 12:17 pm


    There are many solutions for this challenge. Here is one way that may work for you “out-of-the-box” (uses GP functionality without an add-ons or customizations):

    Use the unit-of-measure schedule and price list functions to limit sales entry to particular units-of-measure. For instance, setup a unit-of-measure of Case12 and Case15 which are 12 each and 15 each respectively. Set the prices at these unit-of-measures only and do not allow overrides of prices.

    Good luck!


Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!