formula to show {quantityshiprecv} in transaction unit in netsuite

AI generated answer (using internal Slack threads):

To show

{quantityshiprecv}

in transaction unit in NetSuite, you can use the following formula:

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

This formula divides the quantity shipped/received by the ratio of the quantity to the quantity in transaction units. This will give you the total quantity received in transaction units. If you want to convert the quantity to the primary stock unit, it's a bit more complex. If your units naming pattern includes the conversion rate, you can use this formula to get the stock units conversion rate:

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

Then, you would divide the quantity in base units by this conversion rate. However, if your naming pattern doesn't include the conversion rate, it's unfortunately not possible to pull the conversion rate using Saved Searches. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******