Scenario
To create a saved search to run list of items that has backordered quantities for its work orders.
Solution
1. Navigate to List > Search > Saved Searches > New > Transactions
2. Under Criteria Standard Subtab:
* Summary Type: Sum | Field: Formula (Numeric) | Description: is greater than 0 | Formula: Max(Nvl({Quantity},0)) – Max(NVL({quantitycommitted},0))
3. Under Results Subtab:
*Field: Document Number | Summary Type: Group
*Field: Item | Summary Type: Group
*Field: Quantity | Summary Type: Group
*Field: Formula (Numeric) | Summary Type: Group | Formula: nvl({quantitycommitted},0)
*Field: Formula (Numeric) | Summary Type: Sum | Formula: Max(Nvl({Quantity},0)) – Max(NVL({quantitycommitted},0))
4. Edit the Search Title and Save.