Is there a way to add country based prices to a pricelist item and conditionally retrieve the price from the column based on a filter. For eg. I have only 3 priceists in 3 different currencies. But within 1 pricelist say, I have 5 prices for each item for 5 different countries. I want to avoid building so many pricelists as it will eat up our storage and will lead to performance issues. If the user specifies the country at Quote entity as USA, the quoteproduct should fill the price from Price(USA) field, or if canada it should take from Price(Canada). Is this achievable?
*This post is locked for comments