cardcraft Posted January 1, 2010 Posted January 1, 2010 Hi I am looking for some help please. I have gone into oscommerce control and opened Locations/Taxes and then Tax Rates I have altered the Taxable good to 17.50 Tax Rate (%) and the Description to 17.5% VAT I have then checked Customer Orders and opened an Invoice for one order. The invoice shows Product, Model, Price (inc), Price (inc) The Tax rate has been removed in the past? The sub total shows £34.95 UK 1st Class (Total postage for this order) £0.00 (This is correct for FREE P&P) Total £34.95 Vat is included below as a separate entry stating Vat included at 15% --- £4.56 Q1: How do I remove the Vat listed below the main part of the invoice (or change the rate to 17.5%?) - eg. Vat included at 15% --- £4.56 Q2: How do I add these as detailed on the ORDER page: Product, Model, Tax, Price (ex), Price (inc), Total (ex), Total (inc) to show on the invoice Q3: If I alter the tax in the listing (or easy populate) it shows the net amount on the website. How do I change this to show the Gross amount on the website? I would like to thank anyone for their help and wish everyone a Happy New Year Sandra
cardcraft Posted January 1, 2010 Author Posted January 1, 2010 Hi Hope this helps. I have checked the Vat rates in Oscommerce Administration Zero Rated Vat is 0.00% Tax rate Taxable Goods is 17.5% Tax rate so these appear correct I have checked MySql database Tax rates Zero Rated Vat is 0.00 Zero 0% Taxable is 17.5% so this to appears correct, please let me know if I am not right so far. >>>>>ORDER VIEW<<<<< I therefore feel there are two problems at this stage, one is that the Vat Tax is showing 0.00% for each item and two there is no total Vat Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc) 1 x Copic Ciao marker pen G99 Olive Copic-G99 0.00% £1.99 £1.99 £1.99 £1.99 1 x Copic Ciao marker pen BG01 Aqua Blue Copic-BG01 0.00% £1.99 £1.99 £1.99 £1.99 1 x Copic Ciao marker pen YG06 Yellowish Green Copic-YG06 0.00% £1.99 £1.99 £1.99 £1.99 2 x Pinflair Glue Gel - 1 Tube DEE38 0.00% £4.35 £4.35 £8.70 £8.70 Sub-Total: £14.67 UK 1st Class (Total postage for this order): £0.00 Total: £14.67 >>>>>INVOICE VIEW<<<<< The Vat Rate and Values are missing Products Model Price (inc) Total (inc) 1 x Copic Ciao marker pen G99 Olive Copic-G99 £1.99 £1.99 1 x Copic Ciao marker pen BG01 Aqua Blue Copic-BG01 £1.99 £1.99 1 x Copic Ciao marker pen YG06 Yellowish Green Copic-YG06 £1.99 £1.99 2 x Pinflair Glue Gel - 1 Tube DEE38 £4.35 £8.70 Sub-Total: £14.67 UK 1st Class (Total postage for this order): £0.00 Total: £14.67 Can anyone suggest how this is corrected to show the relavent Vat Tax rates and amounts If the changes also change to amount shown on the website from Gross value to Net value can you also suggest what I need to do to show the Gross value online Many thanks in advance Paul
Xpajun Posted January 1, 2010 Posted January 1, 2010 Do you have this problem with a order placed after you made your alteration or are you expecting your pre alteration orders to change to the new rate of VAT? If the latter they won't as the tax rate (and any exchange rate) is applied and stored at the time of the sale. Only if you are experiencing the former you have a problem My store is currently running Phoenix 1.0.3.0 I'm currently working on 1.0.7.2 and hope to get it live before 1.0.8.0 arrives (maybe 🙄 ) I used to have a list of add-ons here but I've found that with the ones that supporters of Phoenix get any other add-ons are not really neccessary
cardcraft Posted January 2, 2010 Author Posted January 2, 2010 Do you have this problem with a order placed after you made your alteration or are you expecting your pre alteration orders to change to the new rate of VAT? If the latter they won't as the tax rate (and any exchange rate) is applied and stored at the time of the sale. Only if you are experiencing the former you have a problem
cardcraft Posted January 2, 2010 Author Posted January 2, 2010 Hello Thank you for your reply. I changed the Vat (Tax) rate from 15% to 17.5% just before the turn into the New Year. I changed it in the administration section and the MySql database In the CUSTOMER > ORDER section of admin for an order placed AFTER the change I get Products ----------------------------- Model ----- Tax - Price (ex) - Price (inc) - Total (ex) - Total (inc) 1 x Slice Design Card Animal Crackers SLICE-ANIM 0.00% £29.99 ----- £29.99 -------- £29.99 ------ £29.99 ( have added the ----- lines to position the data better for this message) Tax = £0.00% Price (ex) same as Price (inc) Total (ex) same as Total (inc) Should be Tax 17.50% --- Price (ex) £25.52 --- Price (inc) £29.99 When I click the button to view and print the INVOICE I get Products ------------------------------- Model -- Price (inc)-Total (inc) 1 x Slice Design Card Animal Crackers SLICE-ANIM £29.99 £29.99 Sub-Total: £29.99 UK 1st Class (Total postage for this order): £0.00 (Corrcet for FREE P&P) Total: £29.99 VAT IS NOT SHOWING HERE last year someone suggested I load another piece of software which gives the Vat and the Vat number below the above items as follows (I have xxx the vat number for this forum) VAT included @ 15% --- Vat Reg. Number xxx xxxx xx £3.91 The Vat (Tax) in the main stsyem doesn't show and the additional details here calculate at 15% Help please!!!!!!!!! Thank you Paul
cardcraft Posted January 2, 2010 Author Posted January 2, 2010 Good News but still struggling I have returned the code for admin/invoice.php that was altered last year on recommendation when altering the Vat to 15% The ORDER page and the INVOICE page now show the same columns, the format is now correct but the Vat (Tax) is still showing 0.00% therefore is not calculated in the totals????? This is now the format for ORDER & INVOICE pages with '-' included between each section or price Products - Model - Tax - Price (ex) - Price (inc) - Total (ex) - Total (inc) 1 x Cricut cartridge - 29-0707 - 0.00% - £44.95 - £44.95 - £44.95 - £44.95 Sub-Total: £44.95 UK 1st Class (Total postage for this order): £0.00 Total: £44.95 What I cannot understand is why the Tax is showing 0.00% ??? It is set in the administration / locations/ Taxes / Tax rates / Taxable Goods 17.50% MySql Database Table for Tax_Rates settings are Field Tax_rate Type Decimal = (7,2) Attrubutes is blank Null = No Default = 0.00 MySql query on database from tax_rate is - `tax_rate`SELECT * FROM `tax_rates` WHERE 1 I am greatful for what ever help you an provide Thank you for your time Paul
cardcraft Posted January 4, 2010 Author Posted January 4, 2010 Good News but still struggling I have returned the code for admin/invoice.php that was altered last year on recommendation when altering the Vat to 15% The ORDER page and the INVOICE page now show the same columns, the format is now correct but the Vat (Tax) is still showing 0.00% therefore is not calculated in the totals????? This is now the format for ORDER & INVOICE pages with '-' included between each section or price Products - Model - Tax - Price (ex) - Price (inc) - Total (ex) - Total (inc) 1 x Cricut cartridge - 29-0707 - 0.00% - £44.95 - £44.95 - £44.95 - £44.95 Sub-Total: £44.95 UK 1st Class (Total postage for this order): £0.00 Total: £44.95 What I cannot understand is why the Tax is showing 0.00% ??? It is set in the administration / locations/ Taxes / Tax rates / Taxable Goods 17.50% MySql Database Table for Tax_Rates settings are Field Tax_rate Type Decimal = (7,2) Attrubutes is blank Null = No Default = 0.00 MySql query on database from tax_rate is - `tax_rate`SELECT * FROM `tax_rates` WHERE 1 I am greatful for what ever help you an provide Thank you for your time Paul
cardcraft Posted January 4, 2010 Author Posted January 4, 2010 Hi can anyone help please The Tax shoule show the Vat amount? The price (ex) and the Total (ex) should but but net of the Vat tax? Thank you Paul
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.