Does anyone else here do business in New York? We're running into trouble doing anything actionable with the "Sales Tax Liability by Tax Item" report from NetSuite, since NetSuite breaks it down by individual tax code (

NY_BGGY - 0.38%

,

NY_NASSAU CO - 4.25%

,

NY_NY - 4.00%

), however New York's sales tax filing system accepts amounts by total within a county (

Nassau County - 8.625%

). I can't seem to get NetSuite to break down the

NY_NY

code by county it's in.

I’ve always pulled out into excel to merge state into each county in the report