How to best check existence of UOM conversion

(2) Share

Report

Posted on by CU29041349-0

626

Hello:

I have a requirement to create a report for our sales department of all items sold and invoiced. The issue is we have products in a variety of UOMs and they would like the conversion of all these various UOMs to tons. I know how it sounds, but please bear with me. Anyway, the concern is not that we can convert them to tons - there is a chart. The issue is, I have a bit of code to do the conversion of 'from unit' to 'to unit', but if a conversion is missing, then the report will fail. What I would like to do is check for the existence of a unit conversion (standard, intra, or inter), and if none exists, I would mark it on the report accordingly. Right now, I think I would have to do multiple check against the UnitOfMeasureConversion table looking for ones without Product for standard, then with Product but same UnitOfMeasureClass (intra) and different UnitOfMeasureClass (inter). Hoping someone knows if there's a more straightforward way to check.

I have the same question (0)