[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 QODBCConversion 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, | |
|