Could someone please provide the master data for Unit of Measure (UOM) conversion? Specifically, we need to know the table(s) in the database where this information is stored.
Hi @saennam - the Unit of Measure structure looks like this:
UnitsOfMeasure - this table is this of valid units of measure and a corresponding measure group (like Length, volume, or duration). This table can be navigated through the Units Of Measure menu option.
UnitOfMeasureConversions - This table is used to define the conversions between two different Units of Measure. Here there are 6 types of conversions that can be supported, Standard, Item-Specific, Supplier-Item Specific, Duration, Item Duration, or Supplier Item Duration. This table can be navigated through the Unit Of Measure Conversions menu option.
Then, one other table that is important for unit of measure conversions is the Items table. The Items table stores the Primary Unit Of Measure.
1 Like