Round off problem

[Marco_K]

I've asked this also in our Dutch forum, but so far no result. So lets try here.
I have a problem with the round off in the tax.
It rounds off by 2 numbers after de decimal, like €2,27
If I choose to round off at 3 numbers after the decimal i'll get €2,261.
The right amount is €2,26.
The strange thing is that ,261 is rounded off to ,27.

Where can i fix this problem?
I'm using V1.3.7.

[fairestcape]

Your currency settings inputs may be the problem. From your post, I see that you are transposing COMMAS (,) and PERIODS (.)

Go to ADMIN...LOCALISATION...CURRENCIES (Select Euro)

Make sure your currency settings reflect your desired delimiters:-

Title: Euro
Code: EUR

Symbol Left: €
Symbol Right:

Decimal Point: .
Thousands Point: ,
Decimal Places: 2

Last Updated: 03/18/2008
Value: 1.33927500

Example Output:
£30.00 = €40.18

Now, when you ADD or EDIT a product's PRICE, you should use the following system (if your settings are as above, where I use a PERIOD for my decimal place delimiter).

Examples: A product with a price of TEN Euros should be entered:-

10.0000


A product with a price of ONE THOUSAND Euros should be entered:-

1000.0000 (NOT 1,000.0000)

[Marco_K]

Is this correct?

Naam: Euro
Code: EUR

Valutasymbool links: €
Valutasymbool rechts:

Notatie decimaal (. of ,): ,
Notatie duizendtal (. of ,): .
Aantal plaatsen achter de komma: 2

Datum laatste wijziging: 09/04/2008
Waarde: 1.00000000

Voorbeeld:
€30,00 = €30,00

[paulm]

@fairestcape: the separator settings differ per country

@Marco_K: your valuta settings are correct now (for The Netherlands)

Can you post the invoice details here? So that we can see all the amounts and taxes per product etc..

[fairestcape]

Yes, you can choose whether to use " . " , or " , " as your decimal symbol - I know that European users tend to choose " , " as the decimal separator (this is consistent with European metric notation).

But the problem may lie in how you apply the price value when you add or edit products.

When you input a price value, say EURO 1000, you must not put any commas or letter spaces in to the input field.

So, if you have chosen " . " as your thousands separator and " , " as your decimal symbol:-

1.000,00 (being one thousand euro and no cents) is incorrect.

It should be - : 1000,0000 (comma stays, but period must not be present).

[Marco_K]

I think i've founded....i hope....
I'll my prices (in admin) are like this 4.5000 in Euros it is €4,50.....13.6500 is €13,65...etc...etc... And not like this 4.5345, the last two numbers are all 00.
Thanks for the help.