Getting my invoice to add tax up correctly

[Guest]

Hi all

 

I have recently produced an oscommerce store, and i'm doing some test orders. When i go into the admin suite and pull off an invoice from a recent test order, i identify a niggly error.

 

I get the price excluding tax and then including tax which is nice and what i want to happen. But the problem occurs at the bottom of the invoice when it adds all the figures together. Here's the problem:

 

Sub-Total: ?99.00

Shipping: ?0.00

VAT 17.5%: ?14.74

Total: ?99.00

 

The Sub-Total figure is adding the items together including tax - exactly the same as the Total figure. I want this sub-total figure to be the sum of the products excluding tax - then it adds the shipping, then the VAT, and the Total should have the final amount.

 

Can anyone advise how to make the sub-total figure add up VAT exclusive figures, as at the moment its doing exactly the same at Total field - which could be v. confusing to the customer.

 

Thanks a lot, in advance.

[Guest]

The Sub-Total figure is adding the items together including tax - exactly the same as the Total figure. I want this sub-total figure to be the sum of the products excluding tax - then it adds the shipping, then the VAT, and the Total should have the final amount.

 

<{POST_SNAPBACK}>

 

I have the exact same problem, and yes I have also had a few customers complain that sub total is the same as total.

 

Would also like a fix for this.

[Guest]

I have the exact same problem, and yes I have also had a few customers complain that sub total is the same as total.

 

Would also like a fix for this.

<{POST_SNAPBACK}>

 

See guys, there's 2 of us here in the same boat. Can anyone shed some light on this one?

[Guest]

Theres a similar thread regarding this problem:

 

Subtotal Problem

 

But they havn't got a solution either.

 

Someone posted this in another thread

 

In the file ot_subtotal.php (folder order_totals) you have to make some changes.

 

Somewhere around line 29 you should make the following changes to the function process()

 

function process() {
global $order, $currencies;


$this->output[] = array('title' => $this->title . ':',
// Edited 14-04-04 by Mike MKEhosting.com for display without tax in the subtotal at checkout_confirmation.
// Original 'text' => $currencies->format($order->info['subtotal'], true, $order->info['currency'], $order->info['currency_value']),
'text' => $currencies->format(($order->info['subtotal'])-($order->info['tax']), true, $order->info['currency'], $order->info['currency_value']),
// Original 'value' => $order->info['subtotal']);
'value' => ($order->info['subtotal'])-($order->info['tax']));
}

 

Not tried it, but its worth a shot.

 

Leet us know how it goes.

[Guest]

Theres a similar thread regarding this problem:

 

Subtotal Problem

 

But they havn't got a solution either.

 

Someone posted this in another thread

Not tried it, but its worth a shot.

 

Leet us know how it goes.

<{POST_SNAPBACK}>

 

Hey there, I updated the code and then went into some old test orders, and saw the invoice and nothing had happened.

 

However, i then did a new test order and when i viewed this invoice it was correct. So it does work for all invoices from now on. Thanks for this, it was really bugging me.

 

New dillemma though - i charge VAT for the products, but P&P i do as 0% VAT. Does postage have to be given VAT too?

[Guest]

Hey there, I updated the code and then went into some old test orders, and saw the invoice and nothing had happened.

 

However, i then did a new test order and when i viewed this invoice it was correct. So it does work for all invoices from now on. Thanks for this, it was really bugging me.

 

New dillemma though - i charge VAT for the products, but P&P i do as 0% VAT. Does postage have to be given VAT too?

<{POST_SNAPBACK}>

 

Yes, carriage isn't VAT exempt as far as I know. We charge VAT on our carriage.

 

Glad the code I gave you worked for your orders.