Saved Search: show all price breaks (per item per line)

Hi all,

Saved Search: show all price breaks (per item per line)

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:

Saved Search: show all price breaks (per item per line)

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:

Saved Search: show all price breaks (per item per line)

Has anyone done something differently to get this? or is there a workaround? TIA!


Rookie Asked on September 11, 2020 in Items.
Add Comment
1 Answer(s)

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.

Beginner Answered on September 11, 2020.

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.


on September 11, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor