Product documentation
In This Topic
    Multiple is mandatory
    In This Topic

    When selling items in a different unit of measure than the inventory unit of measure you often want to ensure that you are selling in a multiple of this inventory unit. In standard Microsoft Dynamics 365 for Finance and Operations it is possible to setup these multiples in the default order settings on the item.

    When you enter a qty on the order that is not an exact multiple of this qty the user gets a dialog with the question whether he wants to apply the multiple instead.

    In standard Microsoft Dynamics 365 for Finance and Operations there is no way to enforce this choice to be mandatory and this can lead to unexpected discrepancies between the sales quantities and the inventory quantities in the inventory transaction table.

    Example:

    Setup an item with inventory unit pcs and default sales unit of pcs and with a unit conversion of 1 m2 is 3 pcs. Create a sales order and change the unit to m2.

    When you try to sell 1m2 there is no problem, the inventory transaction quantity will be 3 pcs.

    But when you try tie sell 1,5 m2 you will endup with a rouding issue as pcs has been setup with zero decimals. The inventory qty will be calculated as 4,5 pcs and is rounded to 5 pcs.

    To prevent this from happening you have to setup a multiple of 1 pcs in the default order settings. Pcs as this is the default sales unit. When you now try to enter 4,5 m2 on the order line the system will ask "The order quantity must be a multiple of 0.33. Do you want to round up the order quantity to 1.67?"

    With the new field “Multiple is mandatory” on the default order settings of the released product active, the system will not open the dialog but applies the multiple from the default order settings automatically to the order line.

    Setup

    Product and information management > Released products > Manage inventory > Default order settings (Purchase order / Inventory / Sales order)

    Field Description
    Multiple is mandatory The multiple will always be applied, manual override is not possible