using a saved search for a transaction, how do i get the quantity received for a line item?

AI generated answer (using internal Slack threads):

To get the quantity received for a line item using a saved search for a transaction, you can use the

{quantityshiprecv}

field. However, if you want to maintain a single line for each Purchase Order (PO) line item and get the sum of all item receipts in transaction units, you can use the formula

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

. This formula will give you the total quantity received in transaction units even if the item was received multiple times by partial deliveries. If you want to convert the quantity to the primary stock unit, you can use the formula

NVL(REGEXP_REPLACE({stockunit}, '[^0-9]'),1)

. This formula will give you the stock units conversion rate, which you can then divide the quantity in base units by to get the quantity in primary stock units. However, this approach requires that your units naming pattern includes the conversion rate. Unfortunately, Saved Searches are unable to pull conversion rate directly. If your naming pattern doesn't include the conversion rate, you might need to use SuiteAnalytics datasets, which do have access to conversion rate. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******