using suiteQL how do i get the quantityreceived field for a transaction line?

AI generated answer (using internal Slack threads):

To get the

quantityreceived

field for a transaction line using SuiteQL, you can use the

quantityshiprecv

field in your SuiteQL query. This field represents the total quantity received for a line item. Here is a sample SuiteQL query:

sql
SELECT quantityshiprecv 
FROM transaction 
WHERE type = 'PurchaseOrder' AND mainline = FALSE

This query will return the

quantityshiprecv

for each line item in a Purchase Order. Please note that the

quantityshiprecv

field is in base units. If you want to convert it to transaction units, you can use the following formula:

sql
{quantityshiprecv} / ({quantity} / {quantityuom})

This formula divides the

quantityshiprecv

by the ratio of

quantity

to

quantityuom

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