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).