Rounding Question

Frappe Framework
1

Hi all,

I noticed that when erpnext is rounding it always round down for example an invoice
$79,222.506 will have a rounding adjustment of -$0.006 to put the grand total to $79,222.50

Is there a way to change this rounding method to instead use the traditional rounding where it rounds up if >=5

I know that this method of rounding is done as a courtesy for customers but most of the time most people/company expects a round up

2

@Dan_Navarro I have checked the Currency control alongside the rounding function and both works as intended.

Just to clarify, the rounding is performed based on the precision value. If it is lower than the number of decimal places, then it rounds the number.

Examples:

Number = $79,222.506
Precision = 3 or more
Value = $79,222.506

Number = $79,222.506
Precision = 2
Value = $79,222.51

I have tested the rounding function and this is what I have found.

3

Ah you are right although my current production server
which is on version ERPNext: v13.35.3 isn’t doing that.

I brought up the new version ERPNext: v13.37.0 and it seems like it is properly rounding.

Thanks!

4

okay I was wrong looks like it is still happening.

image

Frappe Framework: v13.40.0
ERPNext: v13.37.0

Below is my currency settings

image
image787Ă—635 26.7 KB

1 Like
5

@Dan_Navarro How about you set the precision to 4 for all the currency fields in the doctype, like Rounded Total…

6

Hi @Dan_Navarro - Did you find any solution for this?
I am facing the same issue on v15 for INR currency. INR 788.50 is getting rounded off to 788 instead of 789

7

I can’t remember how its fixed but make sure you set the correct settings for rounding. See below

image
image1392Ă—507 43.2 KB

8

Thanks for the reply. Setting the correct rounding method worked. We selected it to Banker’rounding.

9

See this for a detailed comparison of rounding methods: