Item Receipt and Bill Variance Saved Search for Purchase Orders

Scenario

User may need to create a Saved Search that displays details of the Purchase Order and its related Item Receipts and Bills. Additionally include also the Receipt vs. Bill Variance column that shows the difference between the Item Receipt and Bill Amounts.

Solution

1. Navigate to Lists > Search > Saved Searches > New
2. Click Transaction Search Type
3. Search Title: Enter Title
4. Click Criteria tab
5. Click Standards subtab
6. Filter:
   Note: For every required field use the drop-down menu to select it and once adjusted click Set if needed.
   
   • Select Type
   • Type: Select any of
   • Select Purchase Order
   • Select Main Line
   • Main Line: Select No
   • Select Status
   • Status: Select any of
   • Select Purchase Order: Partially Received, Purchase Order: Pending Bill, Purchase Order: Pending Billing/Partially Received, Purchase Order: Fully Billed
7. Click Results tab
8. Click Columns subtab
9. Field:
   Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed. Select additional fields as required.
   
   • Select Vendor Fields…
   • Vendor Field: Select Name
   • Summary Type: Select Group
   • Custom Label: Enter Vendor Name
   • Select Date
   • Summary Type: Select Group
   • Custom Label: Enter Purchase Order (PO) Date
   • Select Document Number
   • Summary Type: Select Group
   • Custom Label: Enter PO #
   • Select Status
   • Summary Type: Select Group
   • Custom Label: Enter PO Status
   • Select Period
   • Summary Type: Select Group
   • Custom Label: Enter PO Period
   • Select Amount
   • Summary Type: Select Sum
   • Custom Label: Enter PO Amount
   • Select Amount (Foreign Currency)
   • Summary Type: Select Sum
   • Custom Label: Enter PO Amount (Foreign)
   • Select Fulfilling/Receiving Transaction
   • Summary Type: Select Group
   • Custom Label: Enter Item Receipt (IR) #
   • Select Fulfilling/Receiving Transaction Fields…
   • Fulfilling/Receiving Transaction Field: Select Amount
   • Summary Type: Select Sum
   • Custom Label: Enter IR Amount
   • Function: Select Absolute Value
   • Select Fulfilling/Receiving Transaction Fields…
   • Fulfilling/Receiving Transaction Field: Select Period
   • Custom Label: Enter IR Period
   • Select Billing Transaction
   • Summary Type: Select Group
   • Custom Label: Enter Vendor Bill (VB) #
   • Select Billing Transactions Fields…
   • Billing Transactions Field: Select Amount
   • Summary Type: Select Sum
   • Custom Label: Enter VB Amount
   • Function: Select Absolute Value
   • Select Billing Transactions Fields…
   • Billing Transactions Field: Select Period
   • Summary Type: Select Group
   • Custom Label: Enter VB Period
   • Select Formula (Currency)
   • Summary Type: Select Sum
   • Custom Label: Enter Receipt vs. Bill Variance
   • Formula: Enter ABS({fulfillingtransaction.amount}) - ABS({billingtransaction.amount})
10. Click Save & Run