I have a sales order with one item This item has the quantity of 3 However, when I execute a SuiteQL command to check the quantity, I get 12 (or -12) Any idea why this is multiplied by 4? Here is my SuiteQL statement: Select * From transactionline Where transaction = 123

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the issue you're experiencing is related to the unit of measure (UOM) used in your transaction. In NetSuite, when you query the lines and return rate and quantity, it returns those values in base units, not transaction units. In your case, it seems like your item might be ordered in packs of 4, hence the multiplication by 4. To get the quantity and rate as shown on the sales order, you will need to convert to the transaction units using the

conversionrate

from

unitstypeuom

. Here is how you can do it: 1. Divide your quantity by

conversionrate

to get the quantity in transaction units. 2. Multiply your rate by

conversionrate

to get the rate in transaction units. You can find the

conversionrate

on

unitstypeuom

- the id of the units from your transaction is the

internalid

referenced on that table. You can find it under "uom" in the Units Type Records Catalog entry. Please note that you need to adjust your SuiteQL statement to include the

conversionrate

from

unitstypeuom

. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******