Fmt_money with "#.###,##' format

1

Hi! I was wondering format ‘#.###,##’ for currency and floats is still an issue for some members in Frappe / ERPNext community?

2

what do you mean with “issue”?
problem I faced is, that we have to support both formats in the same instance. depending of the origin country/language of the customer a different format is needed.

3

Yes. Based on the locale

4

How did you solve this problem? Or is it still a problem?

5

short answer: yes, still a problem.
longer explanation:
right now we “workaround” by having two separate print templates. (which is very bad for maintenance and usability) with using

{{ frappe.utils.fmt_money(n.rate, currency=doc.currency)|replace(',','x')|replace('.','y')|replace('x','.')|replace('y',',')   }}

I am working on extending fmt_money, but due to time and knowledge contrainst not finished yet…

6

Thanks. Instead of frappe.utils.fmt_money, I use ‘{:,.2f}’.format(n.rate)