Create a List That Shows the Last Purchase Price of an Item Based on Vendor Bill Instead of Item Receipt

Scenario

Create a list that shows the Last Purchase Price of an Item based on Vendor Bill instead of Item Receipt. Last Purchase Price field shown on the Item record is determined by the most recent transaction for the Item that added an inventory, such as a purchase receipt, inventory transfer or positive inventory adjustment. 

Solution

1. Navigate to Transactions > Management > Saved Searches > New
2. Click Transaction
3. Search Title: Enter Title
4. Click Criteria
5. Click Standard
6. Filter:
• Select Type 
• Select Bill
• Select Main Line 
• Select No
• Select Tax Line 
• Select No
• Select Shipping Line 
• Select No
• Select COGS Line 
• Select No
7. Click Results
8. Click Columns
9. Field:
• Select Date 
• Summary Type: Select Maximum
• Select Item 
• Summary Type: Select Group
• Select Item Rate 
• Summary Type: Select Maximum
• Function: Select Absolute Value
• When Ordered By Field: Select Date 
• Custom Label: Enter Unit Rate
• Select Quantity
• Summary Type: Select Maximum
• Function: Select Absolute Value
• When Ordered By Field: Select Date
• Custom Label: Enter Quantity Billed
• Select Amount
• Summary Type: Select Maximum
• Function: Select Absolute Value
• When Ordered By Field: Select Date
• Custom Label: Enter Billed Amount
10. Click Add
11. Click Save & Run