Local Sales Tax Mod - Support Thread

[noyloza]

I changed my sales tax to .5% and my tax classes match...

[dbpiano]

The people from accounting pointed out that on the Orders detail page and the Invoice on the Admin section are showing the wrong amount for taxes.

Example:

Someone from the Volusia county should be charged 6.5% 6% for state tax and 0.5% for county tax

The calculation is correct but the value displayed on the tax section is 7%.



I checked how the detail table is being created and traced the tax value in this case is field=products_tax(7.0000) being pulled from table on the DB `orders_products`.

Is there any way that you can help me to fix this? since is causing issues with end user giving them the impression that the tax is wrong.

I don't know if this is an issue with "local sales tax mod" or the "edit order mod", but since you are the creator of both I figured you would understand this issue.

Thanks in advance

[lhungil]

The people from accounting pointed out that on the Orders detail page and the Invoice on the Admin section are showing the wrong amount for taxes.

You are correct (and thank you for mentioning this in the support thread)!

Background / Why
The "tax" field is pulled from the Zen Cart "tax" rate for the product. This does not include any "local sales tax" calculations. The "Local Sales Tax" mod does not modify what is shown in this field (admin side). It also does not include changes to any templates (customer side). Showing a combined rate may be considered in the future (the value in the database saved with the product should not be altered). If you (or anyone else) tackles this project, please submit the changes / patches to this support thread!

Modifying the value of this field using "Edit Orders" will only modify the Zen Cart tax rate, not any "local sales tax" calculations. "Edit Orders" does not support manually changing the "local sales tax" rate for products. Any "local sales tax" will be applied in addition to the rate listed in this field. Adding the ability to modify the "local sales tax" order line will not be considered for "Edit Orders" in the future (unless an overwhelming need with no workaround is found - as this would require substantial modification to both modules).

Temporary Workaround / Hide the field
If you are concerned with the rate being shown to people using the Zen Cart admin interface, remove the column from showing in "/admin/orders.php" and "/admin/invoice.php" (I typically just alter the invoice and teach clients to always use this button to display / print their invoices).

For the customer side, this field is only shown on the account history page if products with different tax rates are in the same order. If you might encounter this situation you can edit "/includes/templates/YOUR_THEME_NAME/templates/tpl_account_history_info_default.php" to remove the tax column from being shown.

[dbpiano]

You are correct (and thank you for mentioning this in the support thread)!

Background / Why
The "tax" field is pulled from the Zen Cart "tax" rate for the product. This does not include any "local sales tax" calculations. The "Local Sales Tax" mod does not modify what is shown in this field (admin side). It also does not include changes to any templates (customer side). Showing a combined rate may be considered in the future (the value in the database saved with the product should not be altered). If you (or anyone else) tackles this project, please submit the changes / patches to this support thread!

Modifying the value of this field using "Edit Orders" will only modify the Zen Cart tax rate, not any "local sales tax" calculations. "Edit Orders" does not support manually changing the "local sales tax" rate for products. Any "local sales tax" will be applied in addition to the rate listed in this field. Adding the ability to modify the "local sales tax" order line will not be considered for "Edit Orders" in the future (unless an overwhelming need with no workaround is found - as this would require substantial modification to both modules).

Temporary Workaround / Hide the field
If you are concerned with the rate being shown to people using the Zen Cart admin interface, remove the column from showing in "/admin/orders.php" and "/admin/invoice.php" (I typically just alter the invoice and teach clients to always use this button to display / print their invoices).

For the customer side, this field is only shown on the account history page if products with different tax rates are in the same order. If you might encounter this situation you can edit "/includes/templates/YOUR_THEME_NAME/templates/tpl_account_history_info_default.php" to remove the tax column from being shown.

Thanks for your help.

[gwynwyffar]

Has any progress been made with regard to Order Total and the affect of coupons and GVs on that total? The Local Sales Tax mod works perfectly except when someone uses a Coupon code or GV. In that case it calculates tax as if the discount never happened.

[FloridaGoFishing]

Hi, I am considering using this mod for calculating Florida local taxes. I am currently using Tax Cloud and it does not play well with coupons causing me headaches with importing orders into my accounting system. What I need to know before installing this mod is how will the tax charged the customer (state 6% plus local %) get posted into the SQL database - into 1 field (normal tax field), 2 fields (state & local), or 3 fields (state, local, & total)? This is important because I use Cart Span that works fantastic and Cart Span only imports the one field, the normal Tax field that is build into Zen Cart. So if this mod posts the total tax charged into the normal Zen tax field, then I would be all set!

[lhungil]

... What I need to know before installing this mod is how will the tax charged the customer (state 6% plus local %) get posted into the SQL database - into 1 field (normal tax field), 2 fields (state & local), or 3 fields (state, local, & total)? ...

Typically the state is configured using the stock Zen Cart tax system. Local taxes are then configured using this module and will be added to the order total separately.

Taxes are stored as one entry per tax rate charged
This module adds the taxes to the standard Zen Cart locations during order total processing (array containing tax descriptions + amount). When the taxes are saved to the Zen Cart database, each "local" tax amount is treated as a separate order total line (and saved as such in the database). This is done on purpose to allow full reporting of what taxes were paid (and what municipality, program, or location for which the tax was collected).

Integration with 3rd Party software
After an order has been completed / shipped a, if integration is done using a 3rd Party vendor (to "export" the order data from Zen Cart's database and "import" the order data into account softwaresuch as QuickBooks)... It would probably be best to contact the 3rd Party vendor of the integration software (especially if the 3rd Party software is commercial).

Some questions to ask the 3rd Party Vendor:

• Does your Zen Cart module support the "Local Sales Tax" Zen Cart module?
• How does your Zen Cart module support multiple order total lines (such as store credit, shipping, discounts, taxes, subtotal, etc)?
• Does your Zen Cart module support adding together specific order total lines prior to import into accounting software such as QuickBooks?
• When exporting from Zen Cart and importing data to accounting software such as QuickBooks, does your Zen Cart module support mapping specific Zen Cart order total lines to specific lines in QuickBooks?

Note: I am not a tax lawyer and cannot give advice as to how taxes should be collected, reported, or remitted. As such, it is your responsibility to seek the advice of a tax professional operating the the area(s) you do business to provide accurate answers to any and all questions related to taxes.