In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Dependency Graph View Issue ] Relation Graph ] Vertical ]
related to child of duplicate of

Viewing Issue Simple Details
ID Category Type Reproducibility Date Submitted Last Update
0000552 [In-Portal CMS] Data Management bug report always 2010-01-25 10:29 2010-05-11 03:00
Reporter alex View Status public  
Assigned To alex
Priority normal Resolution fixed  
Status closed      
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.
Additional Information



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker