ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

[BUG] Print format with number formatting is wrong


#1

Hi,

I’m having an issue with numbers and decimal point or comma. I have prices with 4 decimals. Example 0,0085 When I use setup/system settings/number format as #.###,## this is shown and printed as 0,01 but when I use #.###,### the result is 0.0085 so period instead of comma.
How can I make sure that I get 0,0085.
Note format #,###.### also gives 0.0085
Thanks for the help.


#2

Anybody?


#3

Hi @Rudi_Meylemans,

It will help if you could upload screenshots of the changes you made in the system settings. The visuals will help others understand and advise you.


#4

This is my current setup

In this situation a number is printed as 1,123.1234 so US format and not 1.123.1234 EUR format. I would have expected the EUR format.
If I change the settings to #,###.### is still stays US format (as it should) so printing 1,123.1234


#5

Has anybody else the same issue? A,y European company with unit prices with 3 or more numbers behind the comma should have this problem.


#6

Hi @rmehta sorry to turn to you but I’m wondering why this is not taken up by ERPNext. Am I the only one?