How to display Back Order Quantity for Work Orders on Saved Search

AI generated answer (using internal Slack threads):

To display Back Order Quantity for Work Orders on Saved Search in NetSuite, you can create a formula field in your saved search. The backorder quantity is essentially the remaining quantity that is yet to be committed. Here's how you can do it: 1. Go to your saved search and add a new field in the Results tab. 2. Set the type of this field to "Formula (Numeric)". 3. In the formula field, enter

{quantity}-NVL({quantitycommitted},0)

. This formula subtracts the committed quantity from the total quantity. The NVL function is used to handle cases where nothing is committed yet, it will replace null values with 0. 4. Label this field as "Back Order Quantity" or something similar. This will give you the backorder quantity for each line in your saved search. Please note that this will only show the backorder quantity for the lines where there is a backorder. If you want to show it for all orders, you might need to adjust your search criteria. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******