Forums / All Other Contributions/Addons / SplitTaxLines mod support thread

SplitTaxLines mod support thread

Locked

Views: 20,799

Results 41 to 60 of 81
This thread is locked. New replies are disabled.
8 Feb 2008, 3:16 PM
#41
imak avatar

imak

New Zenner

Join Date:
Feb 2007
Posts:
24
Plugin Contributions:
0

SplitTaxLines mod support thread

alanhigg:

imak,

I haven't tested this mod with 1.3.7 but I would expect it to work as I don't think that any of the differences between 1.3.7 and 1.3.7.1 will affect it.

Just be certain that you are using the right version of split tax lines. Version 1.1 is for the 1.3.8 series of zen-cart. For zen-cart 1.3.7 the one that you need is STL v1.01

Let us know if you have success with it!
Alan

alan,

It's working perfectly with ZC 1.3.7

Thanks !

11 Feb 2008, 12:40 PM
#42
imak avatar

imak

New Zenner

Join Date:
Feb 2007
Posts:
24
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

I'm using STL 1.01.

In the "Your Total" box (Step 2 of 3) it is possible to add line between PST and Total lines to show the shipping costs (with taxes includes) ? :

ex:

 Sub-Total: $XX.XX

GST : $X.XX
PST: $XX.XX
** Shipping (taxes includes if apply) : $XX.XX**
Total: $XX.XX

11 Feb 2008, 12:41 PM
#43
imak avatar

imak

New Zenner

Join Date:
Feb 2007
Posts:
24
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

Is the version 1.01 of SLT working fine with the module SuperOrder ?

11 Feb 2008, 9:41 PM
#44
vhjdb avatar

vhjdb

New Zenner

Join Date:
Dec 2007
Posts:
19
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

Alan,

Any plans to create reportin for Admin for different taxes? Thanks in advance.

12 Feb 2008, 2:13 PM
#45
alanhigg avatar

alanhigg

New Zenner

Join Date:
Nov 2007
Posts:
31
Plugin Contributions:
1

Re: SplitTaxLines mod support thread

imak:

I'm using STL 1.01.

In the "Your Total" box (Step 2 of 3) it is possible to add line between PST and Total lines to show the shipping costs (with taxes includes) ? :

ex:

 Sub-Total: $XX.XX

GST : $X.XX
PST: $XX.XX
** Shipping (taxes includes if apply) : $XX.XX**
Total: $XX.XX

Hi imak,
I'm not sure I fully understand what you're asking, but I'm sure there's a way to make it happen. Whether or not it's quick and easy is the question :-)

It sounds like you want to have only the subtotal taxes displayed (and split), and the shipping taxes you want to have added into the shipping cost and displayed on one line. If that's what you want, here's an approach that might do the trick (I haven't tried it myself):

  • Modify the ot_shipping.php file in includes->modules->order_total. First, force it to not split shipping taxes by forcing) the conditional expression that checks DISPLAY_SPLIT_TAX_LINES (line 67 for stl1.01 and line 52 for stl1.1). Something like this should do the trick:
//Begin SplitTaxLines modification
//--------------------------------
if ('true')
{

Then, in function process() (line 134 for stl1.01 line 131 for stl1.1) you will see: ```
'value' => $order->info['shipping_cost']);


Add in the calculated taxes like this (I repeat, I haven't tried this myself)

'value' => $order->info['shipping_cost'] + $order->info['tax_groups']["$shipping_tax_description"]);


- Change the priorities of the shipping and taxes items in the order_total module (in the admin area, modules->order_total) so that taxes are higher than shipping.

In my head, that should all work. Again, I haven't tried it so please be careful and don't wreck a live cart. Please do respond and let us all know how it worked out though, ok?


> **imak:**
>
> Is the version 1.01 of SLT working fine with the module SuperOrder ?

I have never tried SuperOrder so I can't say if it works. If you end up trying it, can you post back with your experiences? Thanks.


> **vhjdb:**
>
> Alan,
> 
> Any plans to create reportin for Admin for different taxes?  Thanks in advance.

Hi vhjdb,
I'm assuming that you want to know the grand totals for collected GST and PST for a time period (tax time, anyone?).  I'm not planning for that since SplitTaxLines is a cosmetic mod only, it splits the display of taxes. 
As long as you don't delete your orders after you've fulfilled them, you still have the required info in the database and can run a quick query to sum it all up. You can join the zen_orders and zen_orders_total tables on the orders_id field and then sum up all fields with the appropriate tax description that fall in your desired date range. Since zencart uses the tax description as the database key, you'll have to make sure that you didn't change your tax description partway through the year because that will screw up your totals and the tax man will not be happy.

Hmm.. as I write it looks like this really wouldn't be too hard to accomplish. I'll see if I can find some time to look at this a little closer...

Alan
13 Feb 2008, 6:39 AM
#46
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,567
Plugin Contributions:
58

Re: SplitTaxLines mod support thread

Just an update that I still haven't had a chance to update CTE to use the multiple tax function. Not sure when I'll have time. If someone else wants to do it please do. Just refer to how I disabled the tax on the function above it in functions_taxes.php

18 Feb 2008, 1:44 PM
#47
mommydesigns avatar

mommydesigns

Zen Follower

Join Date:
Jul 2006
Posts:
135
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

Hi guys! This mod rocks - I just can't get my taxes to add up right. Help?

This is what it's currently calculating:

Sub-Total: $160.00
Discount Coupon: partyof8 : -$10.00
FedEx Ground (FedEx Ground® Service ): $14.34
5% GST: $6.33
8% PST: $10.13
5.0% GST on Shipping: $0.68
Total: $184.72 (adding above numbers should total $181.54)

It should be to the way I've understood taxes (and the way it added prior to the mod installation):

Subtotal: $160.00
disc coupon: -$10.00
fedex: $14.34
5% gst: $7.50
8%pst: $12.00
5%gst on shipping: $0.72
Total: $$184.56

Please advise as the client has to manually adjust all orders right now with this.

Jennie

20 Feb 2008, 2:12 PM
#48
alanhigg avatar

alanhigg

New Zenner

Join Date:
Nov 2007
Posts:
31
Plugin Contributions:
1

Re: SplitTaxLines mod support thread

mommydesigns:

Hi guys! This mod rocks - I just can't get my taxes to add up right. Help?

This is what it's currently calculating:

Sub-Total: $160.00
Discount Coupon: partyof8 : -$10.00
FedEx Ground (FedEx Ground® Service ): $14.34
5% GST: $6.33
8% PST: $10.13
5.0% GST on Shipping: $0.68
Total: $184.72 (adding above numbers should total $181.54)

It should be to the way I've understood taxes (and the way it added prior to the mod installation):

Subtotal: $160.00
disc coupon: -$10.00
fedex: $14.34
5% gst: $7.50
8%pst: $12.00
5%gst on shipping: $0.72
Total: $$184.56

Please advise as the client has to manually adjust all orders right now with this.

Jennie

Hi Jennie,
I'm curious to know what's going on here as well, because those numbers are not good. At first glance, I can't see where the problem might lie. So, a few troubleshooting questions

  1. Do you have any other mods installed? Which ones?

  2. If you switch off the splittaxlines mod and then duplicate this order, do the right numbers show up?

  3. Do the taxes calculate properly for orders that don't have discounts?

Let's try to get to the bottom of this....

Alan

21 Feb 2008, 5:03 PM
#49
nickita avatar

nickita

New Zenner

Join Date:
Mar 2007
Posts:
92
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

I have the same problem & no it doesn't matter whether there is a discount or not:

Sub-Total: $359.98

Table Rate (15.00lbs) (Best Way): $25.00

5.0% GST#85990 7784 RT 0001: $7.50

8.0% PST (Ontario): $12.00

5.0% GST on shipping: $1.25

8.0% PST (shipping): $2.00

Grand Total $435.03

GRAND TOTAL IS LISTED AS $435.03 but adds up to $407.73....
GST should be $17.99 or $18.00
PST should be $28.79 or $28.80

GRAND TOTAL NUMBER IS CORRECT, BUT THE GST & PST NUMBERS SHOWN ARE INCORRECT. IT IS CALCULATING IT PROPERLY IT'S JUST NOT SHOWING IT PROPERLY.

SHIPPING GST & PST IS CALCULATED CORRECTLY!!

21 Feb 2008, 5:22 PM
#50
nickita avatar

nickita

New Zenner

Join Date:
Mar 2007
Posts:
92
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

One other question...

Why is my system charging PST for Shipping?
Shouldn't it only be GST on shipping?

21 Feb 2008, 6:14 PM
#51
alanhigg avatar

alanhigg

New Zenner

Join Date:
Nov 2007
Posts:
31
Plugin Contributions:
1

Re: SplitTaxLines mod support thread

nickita:

I have the same problem & no it doesn't matter whether there is a discount or not:

Sub-Total: $359.98
Table Rate (15.00lbs) (Best Way): $25.00
5.0% GST#85990 7784 RT 0001: $7.50
8.0% PST (Ontario): $12.00
5.0% GST on shipping: $1.25
8.0% PST (shipping): $2.00
Grand Total $435.03

GRAND TOTAL IS LISTED AS $435.03 but adds up to $407.73....
GST should be $17.99 or $18.00
PST should be $28.79 or $28.80

GRAND TOTAL NUMBER IS CORRECT, BUT THE GST & PST NUMBERS SHOWN ARE INCORRECT. IT IS CALCULATING IT PROPERLY IT'S JUST NOT SHOWING IT PROPERLY.

SHIPPING GST & PST IS CALCULATED CORRECTLY!!

Hi nickita,
This is also curious, but I don't know if it is related to Jennie's issue. In your case, the grand total is still OK but hers is not.

Can you describe to me the order that gave these numbers? How many items, what were their values... were they priced by attribute... things like that. The more detail the better. Also, are you running any other mods? Does the tax total come out OK when you turn off the split tax lines mod?

nickita:

One other question...

Why is my system charging PST for Shipping?
Shouldn't it only be GST on shipping?

That depends on how you have your tax rates set up, and doesn't have anything to do with this mod. I'm not a tax accountant but I'm under the impression that in Ontario you do have to charge PST on shipping. Here's a good thread (link) on setting up taxes for Canada. Maybe someone there will have a better answer for you...

Alan

22 Feb 2008, 6:26 PM
#52
nickita avatar

nickita

New Zenner

Join Date:
Mar 2007
Posts:
92
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

The total was two items $149.99 FREE SHIPPING & $209.99.

No they weren't listed with attributes.

No other mods, except a template from Template Monster.

Yes I think if you remove the split taxes, it will show & calculate all correctly.

24 Feb 2008, 3:39 PM
#53
alanhigg avatar

alanhigg

New Zenner

Join Date:
Nov 2007
Posts:
31
Plugin Contributions:
1

Re: SplitTaxLines mod support thread

nickita:

The total was two items $149.99 FREE SHIPPING & $209.99.

No they weren't listed with attributes.

No other mods, except a template from Template Monster.

Yes I think if you remove the split taxes, it will show & calculate all correctly.

Hi Nickita,
This is a good start, thanks. Based on the numbers you gave, it seems that taxes are being calculated on all products and the total is correct, but for some reason the tax lines are only showing tax on the first product ($1500.05 = 7.50 and $1500.08 = 12.00)

I'll try to find some time to find the root cause of this issue but I'm a little swamped with other work at the moment.

Alan

ps. to Jennie - are you still having the problem you described earlier?

25 Feb 2008, 1:00 PM
#54
nickita avatar

nickita

New Zenner

Join Date:
Mar 2007
Posts:
92
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

Good job!! I didn't even think of breaking them down like that to figure out where those numbers came from.

Let me know what you find out or if you'd like let me know what file to look into & I'll do some digging myself.

26 Feb 2008, 2:29 PM
#55
alanhigg avatar

alanhigg

New Zenner

Join Date:
Nov 2007
Posts:
31
Plugin Contributions:
1

Re: SplitTaxLines mod support thread

nickita:

Good job!! I didn't even think of breaking them down like that to figure out where those numbers came from.

Let me know what you find out or if you'd like let me know what file to look into & I'll do some digging myself.

Nickita,
You mentioned that you are using a template from template monster. Can you check to see if there is any overlap between the SplitTaxLines files and the template files? Maybe there is something not quite right about the way that the two have been integrated.

To All:
Has anyone else experienced a similar thing, where the grand total is OK but the tax lines shown are incorrect?

Alan

27 Feb 2008, 1:35 PM
#56
nickita avatar

nickita

New Zenner

Join Date:
Mar 2007
Posts:
92
Plugin Contributions:
0

Re: SplitTaxLines mod support thread

Should I try turning off the template & seeing if that resolves the issue?

I think I've done this before & it doesn't, but I can try again.

28 Feb 2008, 3:16 AM
#57
alanhigg avatar

alanhigg

New Zenner

Join Date:
Nov 2007
Posts:
31
Plugin Contributions:
1

Re: SplitTaxLines mod support thread

nickita:

Should I try turning off the template & seeing if that resolves the issue?

I think I've done this before & it doesn't, but I can try again.

Sure, that would be a good thing to try. Let us know what happens. I expect you'll also have to ensure that you have installed STL to the default template though, otherwise you won't be able to see the split tax lines.

Alan

6 Apr 2008, 12:22 AM
#58
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,567
Plugin Contributions:
58

Re: SplitTaxLines mod support thread

Hi guys,

Someone supported me to update the CTE module with STL, which I have done without a problem.

But, I am having a problem with STL with the classic template and version 1.3.8a:

GST (5%) - for all goods in Canada
PST (7%) - for all goods in BC
GST (5%) - for all services in Canada

When I install STL it displays the tax for each product as Array% and the GST is only calculated on the second item plus shipping and the PST is calculated on only the second item.

Qty. Item Name Tax Total
1 x test prod 1 cat 2 Array% $55.00
2 xt est prod 1 Array% $20.00

Sub-Total: $75.00

Flat Rate (Best Way): $5.00

GST (5%): $1.25 (should be $4.00)

PST (7%): $1.40 (should be $5.25)

Total: $89.25 (total is correct)

Everything is 100% perfect when STL is set to false.

When I activate CTE with STL the totals are always correct. I have tested STL without CTE to get the above errors.

6 Apr 2008, 12:26 AM
#59
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,567
Plugin Contributions:
58

Re: SplitTaxLines mod support thread

CTE with zen_get_multiple_tax_rates() support is completed and is ready to release. But it seems pointless to do so with the STL errors...

6 Apr 2008, 12:46 AM
#60
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,567
Plugin Contributions:
58

Re: SplitTaxLines mod support thread

Ok, solved the array% problem which was due to missing some lines for merging on tpl_checkout_confirmation_default.php. I'm now using the file included with the package and receiving the incorrect amounts on each tax line. All the taxes skip the first item in their calculations and only display on the last item of each tax class.