Rounding problem

28.01.2011 11:01
#1
keesp
Joomshopping forum user no avatar
Name: Kees
13.01.2011
Posts: 6
Quote
Rounding problem

Hi,

I have a problem with the rounding in the total. The price of the product is 395 including tax (331,93 excl. tax), the shipping price is 10 including tax (8.40 excl. tax). These figures should be charged to the customer as they are.
However, in the shopping cart the following happens:
331,93 + 19% = 394,9967
8,40 + 19% = 9,996
Total = 404,9927

This is displayed on the invoice as 404.99, but I want it to be 395 + 10 = 405

Is there a way to calculate the total based on the brutto prices and not on the netto prices + tax

Thanks,
Kees

 
28.01.2011 20:48
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25919
Quote
Aw: Rounding problem

Try

administrator/index.php?option=com_jshopping&controller=config&task=general

Displaying prices in the admin area: Brutto
Displaying prices in the front end: Netto

 
24.02.2011 08:23
#3
Acqua
Joomshopping forum user no avatar
Name: Beatrice Isaac
13.01.2011
Posts: 51
Quote
Aw: Rounding problem

I have a similar problem.

Aw: Rounding problem
For my customers outside the EU I set up the shop that it shows netto prices without VAT.
Setting:
Admin: netto prices
Front end: bruttto prices + additional rule for specific countries: netto prices.

My european customers now wil see this:
Aw: Rounding problem
Aw: Rounding problem
This is confusing (and also wrong). I want the prices to show in brutto with the text: incl. VAT.
How should the settings be, that it show correctly?


Last change: 24.02.2011 08:28
 
26.02.2011 07:48
#4
Acqua
Joomshopping forum user no avatar
Name: Beatrice Isaac
13.01.2011
Posts: 51
Quote
Aw: Rounding problem

I think I solved the problem.

In the database I changed all decimal (12,2) to decimal (12,4).
Now the prices round correctly with admin setting: show netto prices because I can enter 4 digits behind the comma.

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.