Custom Saved Search to Display Sales Orders where All Items are Full Committed

1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Select Transaction in the list.
3. Rename the Search Title.
3. Under the Criteria tab, Standard subtab, set the following filters:

• Type is Sales Order
• Tax Line is false
• Shipping Line is false

4. Under the Criteria tab, Summary subtab, we have the following:

• Summary Type = Sum
• Field = Formula (Numeric)
• Formula = nvl({quantity},0)-nvl({quantitycommitted},0) 
• Formula Numeric = Equal to
• Value = is 0

5. Under the Results tab, Columns subtab, we set the following:

 where Formula = nvl({quantity},0)-nvl({quantitycommitted},0)

6. Click the Save and Run button.