Local Sales Tax Mod (with admin!) for testing

[LadyHLG]

bushkillfarms,
I think maybe there is a problem in the calculations. I just did some testing using 4% for state and 4% for local and the numbers are not totally correctly.
I'm not sure what is happening let me take a closer look and see if I can find the problem.

LadyHLG

[bushkillfarms]

Thanks for the offer. I just sent you a PM

Rob...

[LadyHLG]

Got it! Sent a reply.
I think we might be seeing a bug.
Doing some testing now and will get back you!

LadyHLG

[LadyHLG]

I think I found it!!

Replace the following file with the one attached below, give it a test and let me know if your numbers work out correctly.

includes\modules\order_total\ot_local_sales_taxes.php

LadyHLG

[bushkillfarms]

LadyHLG,

Gave it a shot, and the good news is the total is now correct.



BUT, now I have another problem. When I add a non-taxable item to the cart. In this example, a $10 item to the above example. The State Tax correctly stays the same, but the Local tax is incorrectly applied to it, and an extra Tax: $0.00 is displayed.

[LadyHLG]

Unfortunately this is where things start to get much more complicated. None of the previous local sales tax mods dealt with non-taxable items and since mine was built based on those it doesn't either. I'm not saying it isn't possible, its just going to take some time to figure out.

I will post back here when I have something.

LadyHLG

[dharper1988]

Hi i just finished my tax list for Florida by the County zip codes if someone wants it and if there are any errors can you tell me? This is from my backup.

[klept0]

Hi i just finished my tax list for Florida by the County zip codes if someone wants it and if there are any errors can you tell me? This is from my backup.

Ill be testing this tonight...I'll let you know...Ive been dreading this task but I decided to find the forums and hunt for help and your a godsend...so testing will commence tonight

[klept0]

works like a charm..thanks to all who have helped make this possible...for someone new @ this whole thing you guys sure made it easy and user friendly...thanks to ladyhlg for the original deal and thanks to dharper1988 for doing FL for all of us!

[LadyHLG]

I have uploaded a new version of the Local Tax Mod to the downloads section.

http://www.zen-cart.com/index.php?ma...roducts_id=623

This new version supports Tax Classes which in turn supports non-taxable items.
It also contains some bug fixes for previous calculation problems.

I STRONGLY RECOMMEND THAT EVERYONE UPDATES TO THE NEW VERSION.

Upgrading is easy, simply copy over the new Local Sales Tax Mod files (overwriting the old ones) and run the included database sql updates.

Also, because this new version supports tax classes, each local tax must now be associated with a zen cart tax class id. I have included an sql file to update all your local tax rates to a single tax class id. For most people this will be the default "Taxable Goods" (Tax Class ID 1) that was created with your zen cart install.

For any of you who have more than one type of tax class or have altered the tax classes you will need verify your tax class id before running the included sql file and update the id number if necessary.

To verify your "Taxable Goods" Tax Class ID in your cart admin go to:
Locations/Taxes -> Tax Classes
This will show you all the Tax Classes defined for your cart, the ID for each class is on the far left.

If you only have one tax class and its ID = 1 then you dont have to update anything, just upload the included SetAllTaxClasses.sql file.

If your tax class ID is not 1 then you will need to open SetAllTaxClasses.sql and change the 1 to whatever your tax class ID is:

UPDATE `tax_rates_local` SET `local_tax_class_id`=1;

Save your changes and upload the SetAllTaxClasses.sql file.

If you have more than one tax class you will need to decide which tax class your local taxes are to be applied to and use that Tax Class ID.


I hope this isn't too confusing, just take a deep breath and go slow. Be sure to read the included readme.txt and/or upgradenotes.txt files and follow the directions.

As, always, be sure to back up your files and database before you begin.

Good Luck!

LadyHLG