Admin rounding errors

[strelitzia]

I have an issue with rounding errors in admin using version 1.5.3.
I thought these had been resolved in 1.5 but i've just tested a completely clean install of 1.5.3 using the same tax settings as the client site and there is indeed an issue.
Tax is set at 20%. Product price including tax is 6.99 which when entered into Products Price (Gross) on the product entry page is automatically calculated as 5.825 in the Products Price (Net) entry field. Preview page changes this to 2 decimal places making it 5.83. Tax added to 5.83 is 7.00. Tax added to 5.825 is 6.99

The product list in admin shows the product as 7.00 as do any order pages and invoices. Store side shows the correct value of 6.99

[frank18]

I have an issue with rounding errors in admin using version 1.5.3.
I thought these had been resolved in 1.5 but i've just tested a completely clean install of 1.5.3 using the same tax settings as the client site and there is indeed an issue.
Tax is set at 20%. Product price including tax is 6.99 which when entered into Products Price (Gross) on the product entry page is automatically calculated as 5.825 in the Products Price (Net) entry field. Preview page changes this to 2 decimal places making it 5.83. Tax added to 5.83 is 7.00. Tax added to 5.825 is 6.99

The product list in admin shows the product as 7.00 as do any order pages and invoices. Store side shows the correct value of 6.99

This thread might give you a clue: http://www.zen-cart.com/showthread.p...94#post1254894

[strelitzia]

Just looked at your thread. Interesting. I'll give your code changes a go and see if it resolves the issue.
TBH, if this issue really has been around since 2008 it's ridiculous that a major flaw such as this has not been addressed!
Devs, If this is the case, care to comment why this hasn't been resolved?

[strelitzia]

I made the edits listed by frank18 to a vanilla 1.5.3 and it didn't fix the admin displayed price issue so further help is going to be needed.
The store side is showing the correct price of 6.99 but admin stubbornly shows 7.00

Making the Net price only 2 decimal places wouldn't fix the problem as 20% tax on 5.82 is 6.984
It will only work if it uses the full 5.825 value.
It must be feasible as the store side can calculate it from the figure stored in the database.

[frank18]

I made the edits listed by frank18 to a vanilla 1.5.3 and it didn't fix the admin displayed price issue so further help is going to be needed.
The store side is showing the correct price of 6.99 but admin stubbornly shows 7.00

Making the Net price only 2 decimal places wouldn't fix the problem as 20% tax on 5.82 is 6.984
It will only work if it uses the full 5.825 value.
It must be feasible as the store side can calculate it from the figure stored in the database.

Did you also apply the change in admin/includes/functions/functions_prices.php ?

return number_format($blah_blah_variable, 2, '.', ''); 

[frank18]

Searching through my live 1.5.3 site I noticed that I had made one other change in admin/functions/functions_prices.php

starting around line 90

      if (!$special_price) { 
        return number_format($sale_product_price, 2, '.', ''); // number_format changed from 4 to 2 decimals - frank18 
      } else { 
        switch($sale->fields['sale_specials_condition']){ 
          case 0: 
            return number_format($sale_product_price, 2, '.', ''); 
            break; 
          case 1: 
            return number_format($special_price, 2, '.', ''); 
            break; 
          case 2: 
            return number_format($sale_special_price, 2, '.', ''); 
            break; 
          default: 
            return number_format($special_price, 2, '.', ''); 
        } 
      } 

Didn't think that was relevant for your purpose as it deals with specials - but worth a try in your vanilla 1.5.3 installation