Knowledgebase: Tutorials
[QODBC-Desktop] How to get Conversion Ratio information from UnitOfMeasureSetRelatedUnit Table in QODBC
Posted by Jack - QODBC Support on 26 October 2015 05:59 AM

How to get Conversion Ratio information from UnitOfMeasureSetRelatedUnit Table in QODBC

Conversion ratio information is stored in a table called UnitOfMeasureSetRelatedUnit.

Problem:

How to get Conversion Ratio information from UnitOfMeasureSetRelatedUnit Table in QODBC.

Solution:

We can get conversion ratio information by using INNER JOIN on SalesOrderLine Table.

We can get conversion ratio information by comparing UnitOfMeasureSetRelatedUnit.ListID and SalesOrderLine.ListID

Please refer below mentioned query for conversion ratio information:

Select S.RefNumber,S.TxnDate,S.SalesOrderLineItemRefFullName,S.SalesOrderLineQuantity,
S.SalesOrderLineRate,U.UnitOfMeasureType, U.Name, U.BaseUnitName,U.RelatedUnitName,
U.RelatedUnitConversionRatio From UnitOfMeasureSetRelatedUnit U
INNER JOIN SalesOrderLine S ON S.SalesOrderLineOVerrideUOMSetRefListID = U.ListID

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).