Product Unit of Measure Conversions

Product Unit of Measure Conversions

Submitted by Nathan Clouse on 09/21/15.

Provides a simple list of all items with unit conversions and what those conversions are.

AX Version: 

Module: 

CREATE VIEW [dbo].[vw_inventItemUnitofMeasureConversion] 
AS 
  SELECT it.partition, 
         it.dataareaid, 
         IT.itemid, 
         uomc.factor, 
         'fromUnit' = FUOM.symbol, 
         'toUnit' = tuom.symbol 
  FROM   inventtable it 
         JOIN unitofmeasureconversion UOMC 
           ON uomc.partition = it.partition 
              AND uomc.product = it.product 
         LEFT JOIN unitofmeasure fuom 
                ON fuom.partition = UOMC.partition 
                   AND fuom.recid = uomc.fromunitofmeasure 
         LEFT JOIN unitofmeasure tuom 
                ON tuom.partition = UOMC.partition 
                   AND tuom.recid = uomc.tounitofmeasure 

go