Identification



Welcome, Guest
Please Login or Register.    Lost Password?
Forum Dolibarr
Help
Howto / Help

Wrong calculation for the sum of 2 x 999?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Wrong calculation for the sum of 2 x 999?
#22342
Wrong calculation for the sum of 2 x 999? 2 Months ago Karma: 0
If I add two entries with the base price of 999 to an invoice, the (german) summary looks like this:
Code:
Gesamtpreis     1.00
MwSt. 8%   -1&996.00
Bruttosumme     2.00
The Total (net of tax) amount, the minus prefix, the & instead of ' and the Total (inc. tax) acount is wrong. Changing the default language to en_US calculates this result:
Code:
Total (net of tax) 1.00
Total tax 8%  -1,996.00
Total (inc. tax)   2.00


Could my change in the main.lang to the german syntax be the reason for the calculation problem?
Code:
SeparatorDecimal=.
SeparatorThousand='
FormatDateShort=%d.%m.%Y
FormatDateShortJava=dd.MM.yyyy
FormatDateShortJQuery=dd.MM.yy
FormatDateHourShort=%d.%m.%Y %H:%M


Surprisingly, an Invoice with 'smaller' prices for single entries works like expected and with the perfect calculation:
Code:
Gesamtpreis 382.80
MwSt. 8%     30.63
Bruttosumme 413.43


Maybe this screen can help?
DolibarUser
Junior Boarder
Posts: 26
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2013/03/19 13:44 By DolibarUser.
The administrator has disabled public write access.
 
#22357
Re: Wrong calculation for the sum of 2 x 999? 2 Months ago Karma: 8
Hi,

Oops !! that's weird... which Dolibarr version are you using ?

Rgds.
humphrey
Expert Boarder
Posts: 138
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#22358
Re: Wrong calculation for the sum of 2 x 999? 2 Months ago Karma: 0
Version 3.3.1
DolibarUser
Junior Boarder
Posts: 26
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#22361
Re:Wrong calculation for the sum of 2 x 999? 2 Months ago Karma: 8
Oh I see... hope someone else will help you

Have a good day.
humphrey
Expert Boarder
Posts: 138
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#22388
Re:Wrong calculation for the sum of 2 x 999? 2 Months ago Karma: 0
did you try to escape those symbols with a \ or / before it "maybe" ?
HubZ
Fresh Boarder
Posts: 15
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#22394
Re:Wrong calculation for the sum of 2 x 999? 2 Months ago Karma: 0
Unfortunately, escaping with \ or \\ or / or // doesn't help.
DolibarUser
Junior Boarder
Posts: 26
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#22436
Re:Wrong calculation for the sum of 2 x 999? 1 Month, 3 Weeks ago Karma: 0
The fix for the use of ' (Apostrophe) as SeparatorThousand fixed this calculation problem too!

The sum is now calculated as expected. Thank you, eldy!
DolibarUser
Junior Boarder
Posts: 26
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Forum Dolibarr
Help
Howto / Help
Powered by Kunenaget the latest posts directly to your desktop


Dolibarr ERP & CRM © 2003-2012 - OpenSource software for business
SourceForge