If you have the Office add on,   use the AP -> TRANSFER function -> Custom Exports,

- Create a Export of the AP Invoices (choose the fields need to complete the task) , Criteria Date range (your fiscal year) and STATE, sort by ZIP code. - run report to EXCEL . There will be work to figure out the counties by your ZIPs Codes, use google to help, if you have the ZIP code list with Towns & counties, there are cool tools in excel "LOOKUP, XLOOKUP" that can add to your export and speed the process up.

Thank you.  I can't seem to get the break down between invoice amount and sales tax.  It's only showing the full payment amount.

NEUSE REGIONAL LIBRARY-

BusinessWorks does not have a sales tax report that is county specific.

Companies have to create and maintain their own Sales tax IDs.  For Sales Tax IDs, BusinessWorks only requires the following fields - Sale tax ID, Description, Account #, Sales tax rate, Cutoff amount.  There is no County designation.

 Depending on how creative you may have been when created your IDs, a possible work around could be to run a General Ledger report based on the GL Account # that you assigned for each ID.

A Business Partner may have ideas and reach out to you on this post to offer a custom report or export they can create for your company.

If you need more suggestions, you can use the Help, Live Chat from with in the program to reach out to a support analyst to discuss possible workarounds depending how you set up your company. 

Sincerely,

Coleen

I'm sorry. I assumed the data should be there.  I've done this before for the Customer side of things(CA? & NV), but not on the Vendor side.

For the future, you could use one of the 5 CUSTOM FIELDS in AP Vendors to mark the county in your State, the field name can also be altered in MAINTAIN A/P Parameters ->Custom Fields