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 positive inventory, such as a purchase receipt, inventory transfer or inventory adjustment.

To create a list that shows the last purchase price of an item based on recent Vendor bill instead of Item Receipt, the steps are as follows:

    - Navigate to Transactions > Management > Saved Searches > New > Transaction
    - Under the Criteria subtab enter the following:
        - Filter : Type | Description : is Bill
        - Filter : Main Line | Description : is false
        - Filter : Tax Line | Description : is false
        - Filter : Shipping Line | Description : is false
        - Filter : COGS Line | Description : is false
    - Under the Results subtab hit Remve All button and enter the following:
        - Field : Date | Summary Type : Maximum
        - Field : Item | Summary Type : Group
        - Field : Item Rate | Summary Type : Maximum | Function : Absolute Value | When Ordered By Field : Date | Custom Label : Unit Rate
        - Field : Quantity| Summary Type : Maximum | Function : Absolute Value | When Ordered By Field : Date | Custom Label : Quantity Billed
        - Field : Amount | Summary Type : Maximum | Function : Absolute Value | When Ordered By Field : Date | Custom Label : Billed Amount
    - Edit Search Title and hit Save and Run