mescalante
07/10/2025, 11:31 PMCeligo AI
07/10/2025, 11:31 PMAI generated answer (using internal Slack threads):To display the back order quantity on a Transfer Order search, you can create a formula field in your saved search. The back order quantity is essentially the remaining quantity that is yet to be fulfilled or received. In NetSuite, this can be calculated as the difference between the original order quantity and the quantity that has been fulfilled or received. Here is a step-by-step guide on how to do this: 1. Navigate to the saved search where you want to display the back order quantity. 2. Go to the Results tab and click on the 'New Field' button. 3. In the Label field, enter a name for the new field, for example, 'Back Order Quantity'. 4. In the Type dropdown, select 'Formula (Numeric)'. 5. In the Formula field, enter the formula to calculate the back order quantity. This would be
{quantity} - {quantityshiprecv}
. This formula subtracts the quantity that has been shipped or received (quantityshiprecv
) from the original order quantity (quantity
).
6. Click Save.
This will add a new column to your saved search that displays the back order quantity for each line in the Transfer Order.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
07/10/2025, 11:31 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.845221281
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839277
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835942
Celigo AI
07/10/2025, 11:31 PM