Create a Saved Search to Show Back Ordered Items which do not Include Items Set to Do Not Commit

Scenario: To show back ordered items in Transaction Saved Search which do not include items set to Do Not Commit
Solution:

1.Navigate to Lists > Search > Saved Searches > New

2. Select Transactions
3. Search Title: Enter Title
4. Filter:
   Select Type
   Description: is Sales Order, Work Order, Transfer Order
   Select Item Fields…Type
   Description: is Inventory item
   Select Commit
   Description: is any of Available Qty, Complete Qty
   Select Status
   Description: is none of Sales Order: Pending Approval, Transfer Order: Pending Approval
5. Click Results tab
6. Field:
   Select Date
   Select Type
   Select Number
   Select Item
   Select Quantity
   Select Quantity Committed
   Select Quantity Fulfilled/Received Select Formula (Numeric)
   Formula: {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0)
   Custom Label: Back Order Qty
   Select Commit
7. Click Save & Run