The user is utilizing Multi-currency and would like to show the Transaction Foreign Item Rate and not the Base Currency Item Rate. They need to have a Transaction Saved Search that would show the Item Pricing Level, Item, Amount per customer.

1. Navigate toLists>Search>Saved Searches>New
2. ClickTransaction
3. Search Title:Enter Title
4. Filter:
   Note:Always click Add once Field selected and adjusted as needed.
   1. Select Type
      • Description: Select Invoice
   2. Select Main Line
      • Description: Select is false
   3. Select Tax Line
      • Description: Select false
   4. Select Shipping line
      • Description: Select false
   5. Select Customer (Main Line) Fields >
      • Description: Select Inactive > is false
5. Click onResults
6. Field:
   Note:Always click Add once Field selected and adjusted as needed.
   1. Select Name
      • Summary Type: Select Group
   2. Select Item
      • Summary Type: Select Group
   3. Select Price Level
      • Summary Type: Select Group
   4. Select Currency
      • Summary Type: Select Group
   5. Select Amount (Foreign Currency)
      • Summary Type: Select Group
   6. Select Quantity
      • Summary Type: Select Sum
   7. Select Formula (Currency)
      • Summary Type: Select Sum
      • Formula: Enter{fxamount}/ NULLIF({quantity},0)