|
In-Portal Issue Tracker - In-Commerce
|
|
Viewing Issue Advanced Details |
|
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
552 |
[In-Portal CMS] Data Management |
bug report |
always |
2010-01-25 10:29 |
2010-05-11 03:00 |
|
|
Reporter:
|
alex |
Platform:
|
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
|
Priority:
|
normal |
OS Version:
|
|
|
|
Status:
|
closed |
Product Version:
|
5.0.2 |
|
|
Product Build:
|
|
Resolution:
|
fixed |
|
| |
|
ETA:
|
none |
Fixed in Version:
|
5.0.3-B1 |
|
|
Reference:
|
http://groups.google.com/group/in-portal-bugs/browse_thread/thread/b481066bd38c4c08 |
|
Change Log Message:
|
|
|
Estimate Points:
|
0 |
|
|
Summary:
|
0000552: Total Order Amount (calculated field TotalAmount) is Rounded Twice |
|
Description:
|
Total order amount (calculated field) is rounded twice:
- in calculated field declaration (MySQL ROUND(<expr>, 2) function)
- in virtual field associated with given calculated field (via formatter)
When site uses multiple currencies, then all prices are stored in database
in primary currency. All currency conversions work, except for TotalAmount
calculated field, because of double round it operates with M.NN number
instead of M.NNNN and looses some cents during conversions of course.
For example:
- Site primary currency is LVL
- Current currency on Front-End is EEK, which has 0.0449 conversion rate
related to LVL
- Product price is: 26.9827 LVL
- Shipping price is: 3.0061 LVL
Field TotalAmount shows 669.93, but it should show 667.90 instead. |
|
Steps To Reproduce:
|
|
|
Additional Information:
|
|
| Relationships | |
|
Attached Files:
|
 order_total_currency_round.patch (1,366) 2010-01-25 10:29
http://tracker.in-portal.org/file_download.php?file_id=241&type=bug |
|
|
Issue History |
|
Date Modified |
Username |
Field |
Change |
|
2010-05-11 03:00 |
alex |
Note Added: 0002157 |
|
|
2010-05-11 03:00 |
alex |
Status |
resolved => closed |
|
2010-03-12 07:55 |
alex |
Note Added: 0001582 |
|
|
2010-03-12 07:55 |
alex |
Status |
reviewed and tested => resolved |
|
2010-03-12 07:55 |
alex |
Fixed in Version |
=> 5.0.3-B1 |
|
2010-03-12 07:55 |
alex |
Resolution |
open => fixed |
|
2010-03-12 07:55 |
alex |
Changeset attached |
5.0.x r13210 |
|
2010-03-11 23:56 |
Dmitry |
Note Added: 0001571 |
|
|
2010-03-11 23:56 |
Dmitry |
Assigned To |
Dmitry => alex |
|
2010-03-11 23:56 |
Dmitry |
Status |
needs testing => reviewed and tested |
|
2010-02-26 18:49 |
Dmitry |
Developer |
=> alex |
|
2010-01-25 10:31 |
Dmitry |
Assigned To |
=> Dmitry |
|
2010-01-25 10:31 |
Dmitry |
Status |
active => needs testing |
|
2010-01-25 10:29 |
Dmitry |
Reporter |
Dmitry => alex |
|
2010-01-25 10:29 |
Dmitry |
New Issue |
|
|
2010-01-25 10:29 |
Dmitry |
File Added: order_total_currency_round.patch |
|
|
2010-01-25 10:29 |
Dmitry |
Reference |
=> http://groups.google.com/group/in-portal-bugs/browse_thread/thread/b481066bd38c4c08 |