Greetings Community, we would want to show Item Record > Sales / Pricing Tab > "Different Price Level in CAD & USD" like this (highlighted Green)
And we would like to use Item Saved Search. And we already got bit ahead by selecting Columns like:
- Name
- Formula (Currency) > {pricelevel2}
- Formula (Currency) > {pricelevel6}
Wherein 2 , 6, etc. is Internal ID of the Price Levels
Now the problem is this Saved Search is only showing CAD Prices.
And Columns like "Base Price" & "Other Prices" are giving CAD Prices Only.
Please Note, we would like to AVOID the Solution where there is Grouping & Pricing Fields are put in Formula like : CASE WHEN {pricing.currency} = 'CAD' AND {pricing.pricelevel} = 'Retail Price' THEN {pricing.unitprice} END
Please let us know if there is any workaround {pricelevel2}, {pricelevel6}.
Or if Grouping can be avoided in Item Saved Search.
Thank You for your Time & Efforts 😊