Erpnext: Need more decimal points for Currency

[dottenbr]

We buy a lot of electronic components that cost like 0,0025 so we need to set in our company that our currency format allows 4 digits.

The System Settings Float Precision has no influence on that but only counts for float types, not currency types. The Smallest Currency Fraction Value in Currency also doesn't work.

How can we set the decimals for the currency to e.g. 4 or 5?

[kickapoo]

It can be configured (developer_mode on) in DocType: Item Price

[dottenbr]

I was hoping that this would be made configurable. If you change it please don't do it in developer mode but by customizing the form.

[dottenbr]

This issue is not closed in my opinion. Currencies are not only in items but sales orders, quotations, all the ledger entries and we need to be able to set the float precision for all of these at once.

I would recommend to make the currency configurable system-wide in System Settings by setting the float precision or making it configurable company-wide in the Company settings next to the currency to set the float precision wanted for that company.

This should be discussed with @nabinhait to make sure the impact on accounting is tested.

[rmehta]

Also see https://github.com/frappe/erpnext/issues/8366. I think the currency format should be global and consistent in the system.

[mtyspider]

Same problem here.. am trying to implement erpnext. but this issue has me running around circles for 15 days now i might as well give up.

[nabinhait]

Fixed it, now there is a dedicated settings for Currency precision under System Settings. You can set it to 9. Also, now Currency formatting is based on "Number Format" field in System Settings.

[dottenbr]

Thank you for implementing the feature. I think it is not ideally designed yet and needs a small improvement. So when buying or selling items we need to be able to set more decimals, you did that. However now these decimals are always visible also when they are not needed.

The most common thing is to show only the two decimals unless more are used.

So instead of the current layout:

I would suggest to show only the decimals beyond 2 when they are used:

This will allow people to use as many decimals as they want but will display nicely.

[rmehta]

It was implemented as designed. So it should have been specified better!

Sent from phone

On 18-Apr-2017, at 3:21 PM, Dominik Ottenbreit [e-mail] wrote:

Thank you for implementing the feature. I think it is not ideally designed yet and needs a small improvement. So when buying or selling items we need to be able to set more decimals, you did that. However now these decimals are always visible also when they are not needed.

The most common thing is to show only the two decimals unless more are used.

So instead of the current layout:

I would suggest to show only the decimals beyond 2 when they are used:

This will allow people to use as many decimals as they want but will display nicely.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub, or mute the thread.

[dottenbr]

I completely agree

[dottenbr]

@rmehta can you pick this up again and have the decimals beyond 2 only show is needed (input or calculation)?

[rmehta]

Can @kickapoo try it. You just need to update the formatters

[kickapoo]

@rmehta not in the near future, sorry but I am in some deep machine communication issues.

[dottenbr]

The currency setting should allow up to that number of float precision. However whenever we display sums like the sub total or the total we should round to 2 decimals.

[KanchanChauhan]

@nabinhait Should there be another setting for currency precision for sub total and totals?

[dottenbr]

@KanchanChauhan and @nabinhait in general you can not transfer or book any currency value that has more than the currency's decimals. For Euros that is 1 full cent = 0.01 euro. To me it doesnt matter if you want to implement two currency float precisions, maybe that is useful to some. For us and for all other normal businesses it should be sufficient if sums and totals are rounded to full cents.

I have just pulled 3 examples of invoices and order confirmations from some of our suppliers:

[dottenbr]

I would like to add that I believe strongly that the decimals should only be shown if they are used. Maybe this can be configurable to say "always show decimals" or "only show used decimals" that basically converts a 1.2000 -> 1.20 / 1.2120 -> 1.212 etc.

This is the behaviour in Microsoft Dynamics NAV and in all of the order confirmations and invoices I have seen from our suppliers so I think its safe to assume this is a standard.

[rmehta]

Yes, I think we can make that as the default. Show additional decimals if they are non-zero