Report for all Open Items in Purchase Order

Steps to create a saved search for the list of all open items on Purchase Orders:

1. Navigate to Transactions > Management > Saved Searches > New
2. Pull up Transaction search
3. On the Criteria tab > Standard sub tab, add:
Type = Purchase Order
Main Line = is false
Formula (Numeric) ---- case when {quantityshiprecv} = {quantity} then 0 else 1 end --- is 1
4. On the Results tab, have the following fields:
Date
Main Line Name
Number
Item
Status
Quantity
Quantity Fulfilled/Received
5. Put a name on the search
6. Hit Save and Run