HomeHome Product Discus... Product Discus...SmithCartSmithCartRounding error with fractional quantitiesRounding error with fractional quantities
Previous
 
Next
New Post
7/2/2010 2:49 PM
 

We are getting 1 cent errors when an order has multiple items, each with fractional quantities. For example,

1.25 lbs @ $9.99 = $12.4875, rounded to $12.49

1.32 lbs @ $11.99 = $15.8268, rounded to $15.83

When the two items are totaled, the unrounded amounts are added together, for $28.3143, rounded to $28.31, but the total of 12.49 and 15.83 is $28.32.

It would be better if the line item extended amounts were rounded as appropriate for the selected currency (e.g. $0.01 for US dollar), and then rounded extended amounts were added to calculate order total, rather than adding the unrounded individual amounts and rounding the total.

 
New Post
7/2/2010 3:17 PM
 

When the cart converts amounts to currency rounding to 2 digits is required. Also to display line item amounts formatted to 2 decimal places the rounding must occur. In your example the rounding the cart does by line item is correct to 2 decimal places and you made a penny! thats a good thing... right :)

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
7/3/2010 6:10 AM
 

In a word, NO.

The total of the order must be the total of the line items, period.

Save the rounded item amount, add up the rounded item amounts for the order total.

 
New Post
7/7/2010 2:49 AM
 

I know it's only a penny or two, but this error is giving me a major headache with my new client. She feels she has to check every transaction, and make an adjustment to eliminate the penny error when it occurs.

Please, give this a priority to provide a fix.

Thanks,

Worth

 
New Post
7/9/2010 6:02 AM
 

Can we get a gameplan for resolving this issue?

 
New Post
7/9/2010 11:02 AM
 

This item is not been scheduled for programming yet. The penny rounding error only occurs when you are using fractional qtys and the way the cart handles line item amounts it converts amounts to currency rounding to 2 digits is required.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartRounding error with fractional quantitiesRounding error with fractional quantities