Saved Search that Displays Back Ordered Quantity and Amount or Dollar Value

To create a saved search that displays backordered quantity and back ordered amount of sales orders, perform the following:

1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Click Transactions.
3. Under Criteria tab and Standard subtab, set the following:
4. Type = Sales Order
5. Tax Line = False
6. Shipping Line = False
7. Status = is any of Sales Order:Partially Fulfilled, Sales Order:Pending Fulfillment
8. Under Results tab and Columns sub tab, set the following:
9. Formula (Numeric) = {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0)
10. Formula (Currency)= ({quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0))*{rate}
11. Enter a name for the custom search.
12. Click Save.