Can users be prevented from creating "On The Fly" units of measure in Item Maintenance?

Question

For example, we have " EA " setup in our Units Of Measure Conversion Maintenance and the users should be selecting it from the UOM lookup but that doesn't always happen. 
 Over the years, inventory managers at different locations have entered items items as " each " in a UOM field or even typo'd a " ES " instead of " EA " in a couple of places. 
 Similar problems with cases, boxes, packs, pallets, etc... inconsistent data entry. 
 It looks like other Sage products (MAS300, X3) seem to prevent this by including a security option for " Only Use Defined UOM" but that feature is not in Sage100.... or am I not looking in the right place?

Thanks in advance for any help or suggestions!

BigLouie · Answer

You could always write a script and attach to field that reads what is entered and if it does not match a list then it does not accept the entry and tells the user they entered an incorrect UOM.

Kevin M · Answer

Advanced field settings are very unforgiving. Be absolutely sure you have all the required values entered into the UDT before you enable the validation or you might find that those fields will mysteriously become blank without warning. 
 Also watch for things like miscellaneous items, charge codes, and comment lines (which won't have UoM, so you must allow blanks). 
 Scripting allows more control, but AFS won't require scripting skills.

Sage 100

Can users be prevented from creating "On The Fly" units of measure in Item Maintenance?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING