Trying to build a Saved Search Price list to show ...
# generalm
markderrick
07/26/2020, 11:48 AMTrying to build a Saved Search Price list to show Customer Pricing, but for each Item, I also want to show the Base Price - however, looks like (despite setting the currency in the criteria) Base Price is always shown in the base currency, not the customer's currency. Anyone found a workable way around this?
👀 1
d
David B
07/27/2020, 1:57 AMI have custom item fields for each trading currency and set them via script (user event)
Keen to hear if there's a smarter way
David B
07/27/2020, 2:03 AMSorry, I omitted that if you use the "Pricing… Unit Price" join on a saved search, you end up excluding anything without at least one price set.
The workaround is to use a SuiteAnalytics Workbook; but for use in Saved Search I use the custom fields mentioned above
m
markderrick
07/27/2020, 7:15 PMDoing the same thing, but running into the issue of Matrix Child Items not triggering the workflow when their prices are updated via the parent Item. 😞