Local Sales Tax Mod - Support Thread

[blarney]

OK gwynwyffar,
Please try the update attached, just upload the new files to over write the current ones (only 2 of them).

Let me know what happens!
LadyHLG

LadyHLG,
First, thanks so much for all the time you've put into this module! The update you sent has the function directory in the root rather than under the includes directory. I figured it out as most will but for any that get stumped, I thought I'd mention it. The fix helped me get my local and state (FLA) tax files back as well.

Now I'm working on figuring out why, when I exempt ALL, I still see the local tax there. I'm wrapping up today and will reread some of the forum comments and attack that one tomorrow.

Just wanted to mention the directory structure correction before anyone else misplaced those fixes.

Regards,

Jim

[blarney]

I just tried it and it still isn't working. The local tax is still calculated for exempt customers. The state sales tax shows as $0.00 but the local tax is then displayed under this with an amount.

I am having a similar problem as supersnow. I'm using ZC v1.3.9h, Local Tax v2.5 with the 2.51 changed files, and Tax Exempt v1.3.

With no exemptions: With the exemption box empty, I can now see the local & state taxes correctly for local (FLA) and none for out of state as expected.

ALL exempted: If I put "ALL" to exempt all taxes, it removes the state tax but I still see the local tax.

Exempt FL tax: When I put "FL TAX 6.0", it exempts the state tax and leaves in the local tax correctly.

I'm stumped as to where to look to fix the ALL exemption so it removes the local tax listing. Any suggestions would be appreciated.

Thanks,

Jim

[gotduhka]

Its been some time now and I was just wondering if anyone has successfully gotten this to work with 1.5. Tax cloud seems to have a major disconnect of information between the official site and the developer, I've given up on it.

[thirdmp]

Its been some time now and I was just wondering if anyone has successfully gotten this to work with 1.5. Tax cloud seems to have a major disconnect of information between the official site and the developer, I've given up on it.

I'd like to know the same thing. I am using Z1.5 and I am very much in need of such a mod ...

[gwynwyffar]

After 8 hours of tweeking, I am a little closer. Tax is applied to the shipping, and appears to be in the total, However, the numbers displayed do not add up.

Taxing based on: Shipping
Taxing For Zone: 195
Local Tax For:
Confer LAPT30- $72.4:
FL-Broward County - 4.344 @ 6.00
76.744
FL-Broward CountyTotal Tax = 4.344

Tax on shipping: 1.2558

$72.40 Sub-Total:

$20.93 United Parcel Service (Ground):

$4.34 FL-Broward County: (Does Not Include Shipping)

$98.93 Tax on Shipping appears to be included)

Any Thoughts on where to go would be appreciated?

Thanks

Jack

I'm having what I believe is the same problem.

Example:
Product subtotal: $34.00
Shipping (UPS Ground): $13.15
NY State sales tax (4%): $1.89
Ulster county sales tax (4%): $1.89
Total: $51.45

The tax calculations appear correct. $34+$13.15= $47.15 x 4% = $1.89

BUT! when you add $47.15 + 1.89 + 1.89 = $50.93 NOT $51.45

There's a $0.52 discrepancy in the calculated final total. Interestingly enough the shipping amt. $13.15 x 4% = .526

It looks like the local sales tax mod is adding in the tax on the shipping twice, but I can't quite see where that is happening. I'm using the files from 2.5.1 from June that you had sent me.

[timprov]

Mine was running 54 times. There's a stray end bracket in the PHP file causing the problem; it's the one that says endif apply local tax. That needs to be moved to below the shipping, order info, and update final total sections.

[gwynwyffar]

Could you be a little more specific? I think I see the extra bracket, but I'm not sure where you mean for it to go.

                //update order info totals 
                $apply_tax_to_shipping = check_tax_on_shipping($taxrec['tax_shipping']);    
                
                if($apply_tax_to_shipping){
                
                      $shipping_tax = zen_calculate_tax($order->info['shipping_cost'], $taxrec['tax']);
                      $order->info['shipping_tax'] += $shipping_tax;    
                      $tax_total_for_class  +=    $shipping_tax;
                } // end if apply to shipping
                
                
                // Update the final total to include tax
                $order->info['total'] = $order->info['subtotal'] + $order->info['tax'] + $order->info['shipping_cost'] + $order->info['shipping_tax'];
                
                $showtax = $currencies->format($tax_total_for_class, true, $order->info['currency'], $order->info['currency_value']);
                
                $this->output[] = array(
                                'title' => $taxdesc .':' ,
                                'text' => $showtax,
                                'value' => $tax_total_for_class);
            }Should the bracket go here instead?
                      
            } //end if tax total > 0 
            
            }  //end if apply local tax <- offending bracket?
       } //end foreach tax 

    } //end if local tax <> 0
    
} //end function

[gwynwyffar]

I tried moving the bracket, that is not my problem as it made no difference.

There's some error in the function or the loop that is causing the local tax on shipping to be added into the total twice.

[timprov]

You have a different version of the file than I do. I don't have if tax total >0 so I have no idea which side it should go on. Not that it really matters if it doesn't fix your problem.

[gwynwyffar]

I think I managed to fix my problem. It might not have been the right way, but the calculation is working properly now. I commented out line 109 on the ot_local_sales_taxes.php file (I'm using version 2.5.1 which I guess never actually got posted to the repository for download but it's available earlier in this thread. Posting the function below in case it helps someone else - or in case someone sees a flaw in my very rudimentary attempt.

//update order info totals
$apply_tax_to_shipping = check_tax_on_shipping($taxrec['tax_shipping']);

if($apply_tax_to_shipping){

$shipping_tax = zen_calculate_tax($order->info['shipping_cost'], $taxrec['tax']);
//commented out line below to fix addition of shipping tax twice into order total
//$order->info['shipping_tax'] += $shipping_tax;
$tax_total_for_class += $shipping_tax;
} // end if apply to shipping