Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

[UltraLtd]

But as you can see there IS a discrepancy between the two screenshots.. and if what you are saying is true and the order wasn't submitted in another currency (order was submitted in Australian currency) then wouldn't the tax shown BEFORE editing be wrong?? If not you will need to explain to me why not.. Cause the original looks off by 1.13..

I believe the tax discrepancy is to do with the shipping amount.

When the order is created from the store front the shipping amount includes tax or in my case GST (10%). This is then shown in the GST value (should really read GST Included Amount) When you go into edit orders it assumes that tax is not included on the shipping rate as the field 'Shipping Tax Rate' is at 0.0%. If you change that to 10% it then increases the $12.50 by 10%.

This is where the $1.13 comes from. $12.50 divided by 11 to give the the tax amount.

What I believe could happen is that the tax rate should be taken from the shipping module tax rate if that makes sense. with the option to decrease the tax rate.

But I am not expert at this.

Thanks

Damien.

[DivaVocals]

The original order totals still don't add up.. and I don't really get what/where the figures shown are coming from (with the exception of the weighted subtotal)

What I see different between the two examples is that the subtotal DOES not include taxes and the tax amount is different by $1.13 (original order displays the taxes $1.13 higher). In other words based on the data displayed for the original order I cannot back into the grand total based on the values displayed. The edited order I can add up the order totals values and get to the grand total..

Not trying to be a PITA, but I do need to understand how you expect these order totals to display and why.. I'm not clear ont why the original order IS correct.. Other than seeing the weighted sub-total on the original order the rest of those order totals don't add up..

I believe the tax discrepancy is to do with the shipping amount.

When the order is created from the store front the shipping amount includes tax or in my case GST (10%). This is then shown in the GST value (should really read GST Included Amount) When you go into edit orders it assumes that tax is not included on the shipping rate as the field 'Shipping Tax Rate' is at 0.0%. If you change that to 10% it then increases the $12.50 by 10%.

This is where the $1.13 comes from. $12.50 divided by 11 to give the the tax amount.

What I believe could happen is that the tax rate should be taken from the shipping module tax rate if that makes sense. with the option to decrease the tax rate.

But I am not expert at this.

Thanks

Damien.

[UltraLtd]

That doesn't add up UNLESS you are saying that the $12.50 includes the shipping tax.. What I see different bewtween the two examples is that the subtotal DOES not include taxes and the tax amount is different by $1.13 (original order displays the taxes $1.13 higher). In other words based on the data displayed for the original order I cannot back into the grand total based on the values displayed. The edited order I can add up the order totals values and get to the grand total..

Not trying to be a PITA, but I do need to understand how you expect these order totals to display and why..

Your not being a PITA.

In Australia all prices display are required to show the total price, ie tax inclusive price.

In the first screen shot the totals are as they should appear. Sub-Total Inc Tax (makes sense as in the table it is under the Total (Incl) Column). The shipping value includes tax of $1.13 ($11.36 +$1.13(gst tax amount - 10%)) The tax amount shown is all the GST tax amount in the order from the products and shipping. ie the order value divided by 11.

When you go into edit orders it assumes that there is not tax on the shipping value and has the shipping tax field set at 0.0%. It then also displays the Sub-Total amount as the ex-tax price. When you go into edit order the value of $12.50 (tax inclusive) is taken across and not the ex-tax value of $11.36 plus the 10% tax.

The GST (tax value) as I mentioned earler should just be a notification of the tax amount for the total order.

[DivaVocals]

Okay sanji and ScriptJunkie have confirmed that my fix solved their issue.. I need to test it on my test store, and I'll bundle this up and submit it in the next 24 hours..


To Sanji:
Merci à Sanji pour le fichier de langue française pour traiter des ordres .. Je suis sûr qu'il a bien rigolé quand il a vu mes fichiers Google Translate..

[DivaVocals]

Got it!! Now I fully see things CLEARLY!!

Your not being a PITA.

In Australia all prices display are required to show the total price, ie tax inclusive price.

In the first screen shot the totals are as they should appear. Sub-Total Inc Tax (makes sense as in the table it is under the Total (Incl) Column). The shipping value includes tax of $1.13 ($11.36 +$1.13(gst tax amount - 10%)) The tax amount shown is all the GST tax amount in the order from the products and shipping. ie the order value divided by 11.

When you go into edit orders it assumes that there is not tax on the shipping value and has the shipping tax field set at 0.0%. It then also displays the Sub-Total amount as the ex-tax price. When you go into edit order the value of $12.50 (tax inclusive) is taken across and not the ex-tax value of $11.36 plus the 10% tax.

The GST (tax value) as I mentioned earler should just be a notification of the tax amount for the total order.

[UltraLtd]

Got it!! Now I fully see things CLEARLY!!

I found a spot in the edit orders file where you can set the tax rate which I did to test however this only adds the 10% to the shipping rate and not assume that the shipping rate already has tax included in the price.

Thanks

Damien.

[Dustie]

Has the fix for the Edit orders been updated in the downloads yet??

[DivaVocals]

Has the fix for the Edit orders been updated in the downloads yet??

Not yet.. Needed to get all confirmations that it worked (and I now have that).. It's a holiday and I am on my way out to celebrate the New Year and my B-Day.. It will be uploaded tomorrow.. I will post the update when it's available to download..

[DivaVocals]

I found a spot in the edit orders file where you can set the tax rate which I did to test however this only adds the 10% to the shipping rate and not assume that the shipping rate already has tax included in the price.

Thanks

Damien.

Got it..

[Dustie]

Not a worry.....Happy New Year and Happy Birthday.

Thank you for all your work on this great mod!