RE: Saved Search: show all price breaks (per item per line)
Hi all,
I would like to create a saved search that shows all the price break of one price level (Based Price) for all items. I know you can link the pricing table to the item saved search to show all the price breaks. However, it doesn’t give me one item per line in the saved search.
I used rank() to get to something very close. Unfortunately, rank() can’t be used in criteria/ grouping results in NS saved searches. It gave me an “unexpected error” message when I run the saved search.
This the result I got so far:
The last step I would need to do is to group the item names and show the max of each price break column. Again, that’s something not allowed in saved searches. Thus, I tried row_number(). It gives me the same error.
Here are the formulas I used:
Has anyone done something differently to get this? or is there a workaround? TIA!
Hey, you need to use CASE {pricing.minimumquantity} WHEN 0 THEN {pricing.unitprice} ELSE 0 END. Use this formula for each quantity column by changing the “0” for the tier’s quantity. Then select GROUP as Summary Type for Name, Type, Base Price. And MINIMUM for the formulas. I didn’t test this out so you might need to tweak the conditions.
Thanks for the reply! I thought about that too. However, I want to show all the items and all price tiers, then I would need to type out all the possible quality breaks which are 200+ in our system. Not all the items have the same price breaks. For example, some are 0-4, 5-9,10-14… but some are 0-9,10-19,20-59,…
That’s why I use rank() to avoid typing specific quantity numbers.
Thanks,
