Forums / Currencies & Sales Taxes, VAT, GST, etc. / Help with a tax issue

Help with a tax issue

Locked

Results 1 to 4 of 4

This thread is locked. New replies are disabled.

8 Mar 2007, 3:13 PM

extrem94

New Zenner

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

Help with a tax issue

Hi,
I'd like to know if there is a way to globally change the products 's "net", "gross" value, I did not enter the products at first with the "taxable goods" option selected. I decided to update the table taxable ID row with the correct ID 1.
Now it calculed "removed" the tax from the gross:bored:
Example:

 Sub-Total:$719.04


  $0.00
 Store Pickup (Walk In):


  

 FL TAX 7.0%:$47.04


  

 Total:$719.04

The net price of the product should be 719.04 and total should be $719.04 +&50.33

Help please !!

8 Mar 2007, 3:43 PM

extrem94

New Zenner

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

Re: Help with a tax issue

Hi all,
I'm looking for the SQL statement to update the product price table;
Something like update gross price with net price.
Thank you in advance

9 Mar 2007, 1:42 AM

stagebrace

Totally Zenned

Join Date:: Jan 2005
Location:: Tennessee
Posts:: 985
Plugin Contributions:: 0

Re: Help with a tax issue

http://www.w3schools.com/sql/sql_update.asp

UPDATE products
SET products_price = new_value
WHERE products_model = some_text

9 Mar 2007, 1:27 PM

extrem94

New Zenner

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

Re: Help with a tax issue

Wow,
That's what I needed...
Thank you so much for you help.