Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Item Saved Search | Different Price Level & Currency in 1 Row
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
Tagged:
0