What is the best practice with regard to location based sales pricing? Can't change the business process. We have over 100 locations now. I was thinking of using price levels but it's too much. Should it be an entirely custom solution?

why is price level too much

Is having 50+ price levels not too bad?

No. I've seen it when required. It is a pain to update pricing if required, but was just part of the game.

Got it. How did you implement the auto-population of the pricing in the transactions based on the location selected? Scripting?