Ability to set minimum order quantities (MOQ) by vendor for items.

Question

Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility for specifying minimum order quantities by vendor. We have several items that we source from more than one vendor. Vendors have different MOQs for the same item. A partial solution is to set the warehouse minimum order quantity to the value specified by the primary vendor, but this then requires maintenance when switching primary vendors. Any advice will be appreciated. Thanks! 
 Doug

RoadRacer · Accepted Answer

Thanks, David. I followed your suggestion of creating a UDF in the IM_ItemVendor table and adding it to the Item Vendors Maintenance grid. I added the UDF to my Excel ODBC query report I provide to our buyer.

Erzsi_I · Answer

Hi RoadRacer, if the above suggested answer helped, please do mark it as verified for the benefit of others in this forum. Thank you!

David Speck · Answer

You could add a User Defined Field to the IM_ItemVendor table and then use Customizer to add the UDF to the grid used to maintain vendors for items. 
 Unfortunately, this UDF won't be used in any standard reorder logic but you could added it to reports. Also, if you want to see it during purchase order entry, you would need a script to retrieve it since the UDF can't be source from IM_ItemVendor surprisingly.

Sage 100

Ability to set minimum order quantities (MOQ) by vendor for items.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING