Saved search to show back ordered quantity of items on sales order

1. Navigate to Reports > Saved Searches > All Saved Searches > New 
2. Select Transaction 
3. Search Title: Enter Title 
4. Click Criteria 
5. Click Standard 

• Select Type 
• Type: any of 
• Select Sales Order 
• Select Status 
• Type: any of 
• Select Sales Order: Partially Fulfilled, Sales Order: Pending Billing/Partially Fulfilled, Sales Order: Pending Fulfillment 
• Select Main Line 
• Select False 
• Select COGS Line 
• Select False 
• Select Shipping Line 
• Select False 
• Select Tax Line 
• Select False 
• Select Formula (Numeric) 
• Formula: Enter {quantity}-nvl({quantityshiprecv},0)-nvl({quantitycommitted},0) 
• Formula (Numeric): greater than 
• Value: 0 

6. Click Results 
7. Click Columns 

• Select Document Number 
• Select Item 
• Select Customer/Project fields… 
• Customer/ProjectSelect: Select Name 
• Select Quantity 
• Custom Label: Enter Ordered 
• Select Quantity Fulfilled/Received 
• Custom Label: Enter Fulfilled 
• Select Formula (Numeric) 
• Formula: Enter {quantity}-nvl({quantityshiprecv},0)-nvl({quantitycommitted},0) 
• Custom Label: Enter Backordered 
• Select Item fields… 
• Item: Select On Hand 
• Custom Label: On Hand 
• Select Item fields… 
• Item: Select On Order 
• Custom Label: Enter On Order 

8. Click Save & Run 

Criteria 

Results