invoice roundings incorrect

[M.Meesters]

Who also has problems with the automatically generated invoices for renewals?

PS: I have already reported this as a problem on level 2, but ask myself if this is an incident or structural

Invoice # xxxx
Amount: € 13.00
Expiry date: 27/06/2019

Billing information:

Domain extension - xx.xx - 1 Year (01/04/2020 - 31/03/2021) € 11.95EUR
+ Privacy protection
-------------------------------------------------- ----
Subtotal: € 11.00
21.00% VAT (VAT): € 2.00
Credit: € 0.00
Total: € 13.00

In Dutch special for NL users

factuur afrondingen niet juist

Wie heeft er ook problemen met de automatisch gegenereerde facturen voor verlengingen?

PS: heb dit al gemeld als probleem op level 2, maar vraag mezelf af of dit een incident is of structureel

Factuur #xxxx
Bedrag: €13,00EUR 
Vervaldatum: 27/06/2019 

Factuurgegevens: 

Domein verlenging - xx.xx - 1 Jaar (01/04/2020 - 31/03/2021) €11,95EUR
+ Privacy bescherming
------------------------------------------------------
Subtotaal: €11,00EUR
21.00% BTW (VAT): €2,00EUR
Krediet: €0,00EUR
Totaal: €13,00EUR  

Vgr,

 

PS: heb dit al gemeld als p

 

Edited May 28, 2019 by Ben Meesters

[M.Meesters]

plz close problem solved

[WHMCS ChrisD]

@Ben Meesters Could you please provide the solution that solved this for you, it could be helpful for future users that may run into the same issue.

[M.Meesters]

The problem of incorrect calculations was caused by a setting on the server level. (System Locale)

Converting amount & currency type based on locale.

This setting is used by php cli while php cgi is used by apache for a website, where you can choose a language or character set yourself.

As a result, new orders via the website are correct, renewals are wrong, because they go via a cron to php cli

# locale
LANG =
LANGUAGE =
LC_CTYPE = "en_US.UTF-8"
LC_NUMERIC = "en_US.UTF-8"
LC_TIME = "en_US.UTF-8"
LC_COLLATE = "en_US.UTF-8"
LC_MONETARY = "en_US.UTF-8"
LC_MESSAGES = "en_US.UTF-8"
LC_PAPER = "en_US.UTF-8"
LC_NAME = "en_US.UTF-8"
LC_ADDRESS = "en_US.UTF-8"
LC_TELEPHONE = "en_US.UTF-8"
LC_MEASUREMENT = "en_US.UTF-8"
LC_IDENTIFICATION = "en_US.UTF-8"
LC_ALL = and_US.UTF-8

# locale -a
C.
C.UTF-8
POSIX
and_US.utf8

I have had to remove all additional languages and character sets (nl_NL.utf8), because whmcs must use C to calculate the amount. otherwise you get strange results by interpretation of points and commas

The underlying problem is that no preference is forced in whmcs, so that a country setting is preferred.

If you need help, go to our website Domein-Direct.nl and ask for support.

Regards,

Ben