Create a Saved Search for Transfer Orders with Back Ordered Items

Scenario

Users would like to create a Saved Transaction Search to show transfer orders with back ordered items.

Solution

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

2. Select Transaction

3. Search Title: Enter Title
   Example: Transfer Orders with Back Ordered Items

4. Click Criteria

5. Click Standard
   
   
6. Filter:
   Always click Add once Filter is selected and adjusted as needed.
   

7. Click Results

8. Click Columns

9. Field:
   Note: For every required field, use drop-down menu to select it and once adjusted, click Add if needed.
   

   • Select Document Number
   • Select Date
   • Select Location
     
   • Select Item
   • Select Formula (Numeric)
     
     • Formula: Enter ABS(({quantity}+nvl({transferorderquantitycommitted},0))+nvl({transferorderquantityshipped},0))
     • Custom Label: Enter Backordered
   • Select Quantity (optional)
     
     • Function: select Absolute Value
   • Select Transfer Order Quantity Committed (optional)
   • Select Transfer Order Quantity Picked (optional)
   • Select Transfer Order Quantity Packed (optional)
   • Select Transfer Order Quantity Shipped (optional)

10. Click Save & Run