NSC | Saved Search > Purchase Order > Quantity Unbilled

Here's a sample Saved Search with a formula to determine the Quantity Unbilled of a Purchase Order.

1. Navigate to Lists > Search > Saved Searches > New
2. Select Transaction
3. Rename the Saved Search
4. Under the Criteria tab, add the following filters:
   1. Type is Purchase Order
   2. Main Line is false
5. Under the Results tab, add the following fields:
   1. Field: Document Number | Summary Type: Group
   2. Field: Applying Transaction : Amount | Summary Type: Sum | Function: Absolute Value
   3. Field: Formula (Numeric) | Summary Type: Sum | Formula:  {quantity}-{quantitybilled}
   4. Note: Add other fields as necessary.
6. Click Save & Run

I hope this helps! ❤ Feel free to share your own tips and tricks under