My client also wants the sales tax to be correct for every zip code in NY State, which is what they say they are required to do. I have also downloaded an updated table with sales tax rates in NY...
My question is could I use the existing tax rule, which already has 2 conditions: The first is that the shipping State = NY, and the second that an additional field in my database which tells me if they have a resale certificate on file = N (for no). Couldn't I just use that same rule, only change the calculation to that session variable you are talking about?
Why does the recordset on the page have to be conditional on the proper State being selected if tax is only applied based on that condition already?
Am I making this too confusing? And why isnt everyone worried about this problem? Are most States the same tax for the whole State?