View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000735 | OXID eShop (all versions) | 1.01. Products (product, categories, manufacturer, promotions etc.) | public | 2009-03-23 13:49 | 2012-12-07 14:29 |
| Reporter | marco_steinhaeuser | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | no change required | ||
| Product Version | 4.0.1.0 revision 15990 | ||||
| Summary | 0000735: Rounding issue when net prices are activated | ||||
| Description | Admin -> Master settings -> Core settings -> Settings -> Other settings -> activate "Product and Gift Wrapping prices entered/displayed in Admin are Net Prices". Now try to insert a product with a gross price of 15,00 EUR. Entering a net price of 12.6049999 will come up with 14.99 EUR and 12.6050000 will come up with 15.01 EUR. | ||||
| Tags | Products | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
|
|
Solution for such case would be - show the price in admin (only admin) with bigger precision, i.e. with 6 decimal numbers. So user will notify that the price is not the same in both cases (what's the reason). Rounding the price to 2 decimal digits in admin and store such in DB may lead to further rounding problems when calculating discounts, VATs and so on. |
|
|
Such case occurs because defined precision (defined next to currencies rate in Core Settings => Settings => Other settings). If in this case the precision would be set to 3 decimal digits, then price 12.6049999 would be rounded to 12.605, as well as 12.6050000. And brutto price for both would be equal (15.00 EUR). |
