We have the Sales Tax Mod installed, and now - sales tax is due (dum de dum dum). Up until now, we've just figured everything out by hand, but I was telling my partner about how ZenCart has all these great add-ons (like the Sales Tax mod, for instance.)

I added the Sales Tax report, but it just gives a total, broken down by month. NY State, in its infinite wisdom, wants you to break it down by county. I went through the trouble of actually putting every single county (over 60) and their respective sales taxes into the mod, so I know the info is in there - who ordered, what county, what they paid.

How the heck do I get it out?!? Looking at the list of tables, I don't even SEE a "sales" table, or anything like that which I could query by "state=ny".

Any thoughts on this would be greatly appreciated. Thanks!