NSC | Saved Search > Difference of Purchase Order and its Bill

Here's a sample Saved Search that will show the difference of the Purchase Order and its related Bill.

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. Applying Transaction : Type is Bill
   3. Main Line is false
5. Under the Results tab, add the following fields:
   1. Field: Transaction Number | Custom Label: Purchase Order Number
   2. Field: Amount | Custom Label: Purchase Order Amount
   3. Field: Applying Transaction : Transaction Number | Custom Label: Bill Number
   4. Field: Applying Transaction : Amount | Custom Label: Bill Amount
   5. Field: Formula Currency | Formula: abs{amount}-abs{applyingtransaction.amount}