Issue of handling Multiple Price lists

Dear Team,

We have a requirement where in we define price lists for every category / location say for (e.g) we have Juices as well as Creams etc.... The Tax rate for creams and Juices varies from state to state

and by this the Price also changes. Not only that there are other customers for Modern Trade for whom we are using a different price list where in the margins are completely different Now the issue

we keep on creating N number of price lists.and it is very cumbersome to maintain the same for us

We tried approach of Advanced Pricing using discounts but didin't serve our purpose