Monday, December 24, 2018

Display Item's Last Purchase Order Price on Saved Searches regardless of Purchase Order Status


1. Navigate to Lists> Search> Saved Searches> New> Item
2. On the Criteria tab> Standard sub tab, set the following:
    - Transaction : Type is Purchase Order
3. Navigate to Results tab >Columns subtab select the following:
  Field | Summary Type | Formula
  -Name | Group
  -Formula (Currency) | Maximum | MAX({transaction.rate}) KEEP(dense_rank last order by {transaction.trandate}, {transaction.datecreated})

4. Enter Search Title and click Save & Run button

No comments:

Post a Comment