Actually no, J_boo.. If you continue your research around BOE, you'll find, as I did, that they actual provide CSV files with the data already in a configurable format, so that you don't have to manually type all of that into a usable format. I found the files, compiled them with the USPS zipcodes, then found out that the zipcodes had no value, because they wander across county lines ??
I also just read a couple of tutorials in ZC that lead me to believe that ZC only works with one tax rate, as DWells explained above. All of us hire carriers to take our packages to our customers. Our transaction is in the county and/or city that we have our warehouse or store within ? Correct ?
Unless someone wants to write a couple of lines to grab the 'ENTRY_SUBURB' data out of the 'ZEN_ADDRESS_BOOK' to trigger the tax rates to work with individual county tax rates, I'm not going to fight it any more. Until the Tax man comes out and says that I need to collect taxes based on each county that I ship to, I will be satisfied with my single rate.
The attachments are by request for Cheryl11 and anyone else who may find value to them.
In the combination file, there are 1546 Cities listed for California, with their associated counties, the zipcodes used for each location, including multiple zips for the larger metro areas and the tax rates for each and all. ( NOTE: It turns out this file is too big to attachment, send me a direct email and I will return it to you : Toby at BetterThanNaked dot net )
There are 58 county only tax rates in their seperate file.
There are 93 cities listed in their seperate file, which have the higher tax rates, than the county they reside in. I think this is where the mod from LadyHLG "Local_Sales_Tax" may work best ? Upcharge what you can and eat the rest ? We all need writeoffs anyway.
I hope I confused none, I hope it helps some ?
-Toby
Bookmarks