Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: Big number changed automatically on float fields

Archives

Contributors

Re: Big number changed automatically on float fields

Re: Big number changed automatically on float fields

Re: Big number changed automatically on float fields


That is the right question - what problem are you trying to solve that requires 19 digit numbers.

On the actual problem, this is how floating point numbers are designed to work at a low level, on Python and computers in general.
Floating point numbers don't store all the number's digits.
For efficiency they only store a limited number of "precision" digits (the ones you can see on the scientific representation) and then the power of 10 scale - where the ("floating") decimal point is.
So for very large number, you lose precision on the rightmost digits of your number.

/Daniel

On 23/10/2024 15:12, Janik von Rotz wrote:

Hi Rolando

I'm interested in the business context of this problem. What kind of accounting are you doing where numbers have 19 digits?

Your questions reminds me of the first Odoo Partner Days. Somebody asked something similar in the context of fuel prices. Fabien opened an interactive python shell and did something like:

>>> import math
>>> math.pow(2, 64)
1.8446744073709552e+19

The question was dismissed and we went on to the next question.

> A value with the last Nth digits changed.

What exactly changes? Can you compare the number entered and retrieved?

Cheers, Janik

On 10/23/24 15:32, Rolando Pérez Rebollo wrote:

Hello, when trying to input very large numbers (with no decimals, 19 digits in my specific case) in credit or debit fields from journal items these numbers are changed on saving automatically with no explanation. The issue is easily reproducible in runbot Odoo 16 CE. I think a similar issue has been reported on github (https://github.com/odoo/odoo/issues/82597).

Steps to reproduce (from a user with full accounting features enabled), demo db from runbot.com 16.0 CE:

- Go to Invoicing/Accounting/Journal Entries

- Create a new one

- In Journal Items add a new line like this:

 

- When saved we get:

A value with the last Nth digits changed.

I was able to debug in a local environment and my observations are:

  • Is not a problem from UI: emulating the creation of journal items from code gets the same results.
  • Is not a problem of visualization: wrong values are persisted into database.
  • At ORM level the large numbers are represented in python scientific notation, in this case 1.51337248356932e+18
    • From there python float "features" begin to work and the float part of the scientific notation gets transformed due to the way python stores float numbers.
  • If my tests are not wrong every single float field in Odoo is hit by this.

I think is rare nobody has notice this before. Maybe I'm ignoring some very basic fact about currency settings in Odoo that's why I'm reaching U for help or any creative idea.

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

-- 
We are hiring: https://www.mint-system.ch/jobs
Send application to: jobs@mint-system.ch

CTO Mint System GmbH 
Tel: +41 44 244 7222

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe


--
DANIEL REIS
MANAGING PARTNER

>> Schedule time on my calendar.
M: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office Center, 2649-517 Cascais

[Logo OpenSourceIntegrators.com]

by Daniel Reis - 04:26 - 23 Oct 2024

Reference

  • Big number changed automatically on float fields

    Hello, when trying to input very large numbers (with no decimals, 19 digits in my specific case) in credit or debit fields from journal items these numbers are changed on saving automatically with no explanation. The issue is easily reproducible in runbot Odoo 16 CE. I think a similar issue has been reported on github (https://github.com/odoo/odoo/issues/82597).

    Steps to reproduce (from a user with full accounting features enabled), demo db from runbot.com 16.0 CE:

    - Go to Invoicing/Accounting/Journal Entries

    - Create a new one

    - In Journal Items add a new line like this:

     

    - When saved we get:

    A value with the last Nth digits changed.

    I was able to debug in a local environment and my observations are:

    • Is not a problem from UI: emulating the creation of journal items from code gets the same results.
    • Is not a problem of visualization: wrong values are persisted into database.
    • At ORM level the large numbers are represented in python scientific notation, in this case 1.51337248356932e+18
      • From there python float "features" begin to work and the float part of the scientific notation gets transformed due to the way python stores float numbers.
    • If my tests are not wrong every single float field in Odoo is hit by this.

    I think is rare nobody has notice this before. Maybe I'm ignoring some very basic fact about currency settings in Odoo that's why I'm reaching U for help or any creative idea.

    by Ing. Rolando Pérez Rebollo - 03:30 - 23 Oct 2024

    2 attachments 2 attachments

    ooOjCgk1NfpAI9oa.png
    lo0b8U3ltBa5r5ph.png

    6 replies 6 replies

    • Re: Big number changed automatically on float fields

      I reviewed this before. I think is the "why is happening?" I also make a research of github issues and even stackoverflow but it's not the same context. Almost every issue related comes from the misleading float_round in float_utils helpers but I'm not even working with a float directly I just have inserted a large number and it's just python dealing with it like a float **18, not Odoo ORM. I'll read again the documentation in search of some hint. Thanks.

      On 10/23/24 10:37, Holger Brunn wrote:
      https://docs.python.org/3/tutorial/floatingpoint.html


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Ing. Rolando Pérez Rebollo - 05:02 - 23 Oct 2024
    • RE: Big number changed automatically on float fields

      Dear,

       

      In Python, you have a Decimal class. Here your numbers are stored in full. So maybe this is a solution.

       

      With kind regards,

       

      Van Hirtum Johan

       

      Van: Rolando Pérez Rebollo [mailto:notifications@odoo-community.org]
      Verzonden: woensdag 23 oktober 2024 16:43
      Aan: Contributors
      Onderwerp: Re: Big number changed automatically on float fields

       

      > I'm interested in the business context of this problem. What kind of accounting are you doing where numbers have 19 digits?

      It's a country with a very high inflation but the company operations really runs in USD so when converting from USD to local currency there are these kind of large numbers.

      > A value with the last Nth digits changed.

      For 1513372483569320000 is always the last five digits, the number stays the same till 15133724835693. My guess is due to the use of float for scientific notation the rest of the number gets messed up for some sort of global digit precision setting.

      The columns in postgres that stores the values for credit and debit fields are of type numeric but without precision and scale settings. For me the responsible for the issue is python.

       

      On 10/23/24 10:12, Janik von Rotz wrote:

      Hi Rolando

      I'm interested in the business context of this problem. What kind of accounting are you doing where numbers have 19 digits?

      Your questions reminds me of the first Odoo Partner Days. Somebody asked something similar in the context of fuel prices. Fabien opened an interactive python shell and did something like:

      >>> import math
      >>> math.pow(2, 64)
      1.8446744073709552e+19

      The question was dismissed and we went on to the next question.

      > A value with the last Nth digits changed.

      What exactly changes? Can you compare the number entered and retrieved?

      Cheers, Janik

      On 10/23/24 15:32, Rolando Pérez Rebollo wrote:

      Hello, when trying to input very large numbers (with no decimals, 19 digits in my specific case) in credit or debit fields from journal items these numbers are changed on saving automatically with no explanation. The issue is easily reproducible in runbot Odoo 16 CE. I think a similar issue has been reported on github (https://github.com/odoo/odoo/issues/82597).

      Steps to reproduce (from a user with full accounting features enabled), demo db from runbot.com 16.0 CE:

      - Go to Invoicing/Accounting/Journal Entries

      - Create a new one

      - In Journal Items add a new line like this:

       

      - When saved we get:

      A value with the last Nth digits changed.

      I was able to debug in a local environment and my observations are:

      • Is not a problem from UI: emulating the creation of journal items from code gets the same results.

      • Is not a problem of visualization: wrong values are persisted into database.

      • At ORM level the large numbers are represented in python scientific notation, in this case 1.51337248356932e+18

        • From there python float "features" begin to work and the float part of the scientific notation gets transformed due to the way python stores float numbers.

      • If my tests are not wrong every single float field in Odoo is hit by this.

      I think is rare nobody has notice this before. Maybe I'm ignoring some very basic fact about currency settings in Odoo that's why I'm reaching U for help or any creative idea.

      -- 
      We are hiring: https://www.mint-system.ch/jobs
      Send application to: jobs@mint-system.ch
       
      CTO Mint System GmbH 
      Tel: +41 44 244 7222

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by johan - 04:51 - 23 Oct 2024
    • Re: Big number changed automatically on float fields

      > I'm interested in the business context of this problem. What kind of accounting are you doing where numbers have 19 digits?

      It's a country with a very high inflation but the company operations really runs in USD so when converting from USD to local currency there are these kind of large numbers.

      > A value with the last Nth digits changed.

      For 1513372483569320000 is always the last five digits, the number stays the same till 15133724835693. My guess is due to the use of float for scientific notation the rest of the number gets messed up for some sort of global digit precision setting.

      The columns in postgres that stores the values for credit and debit fields are of type numeric but without precision and scale settings. For me the responsible for the issue is python.


      On 10/23/24 10:12, Janik von Rotz wrote:

      Hi Rolando

      I'm interested in the business context of this problem. What kind of accounting are you doing where numbers have 19 digits?

      Your questions reminds me of the first Odoo Partner Days. Somebody asked something similar in the context of fuel prices. Fabien opened an interactive python shell and did something like:

      >>> import math
      >>> math.pow(2, 64)
      1.8446744073709552e+19

      The question was dismissed and we went on to the next question.

      > A value with the last Nth digits changed.

      What exactly changes? Can you compare the number entered and retrieved?

      Cheers, Janik

      On 10/23/24 15:32, Rolando Pérez Rebollo wrote:

      Hello, when trying to input very large numbers (with no decimals, 19 digits in my specific case) in credit or debit fields from journal items these numbers are changed on saving automatically with no explanation. The issue is easily reproducible in runbot Odoo 16 CE. I think a similar issue has been reported on github (https://github.com/odoo/odoo/issues/82597).

      Steps to reproduce (from a user with full accounting features enabled), demo db from runbot.com 16.0 CE:

      - Go to Invoicing/Accounting/Journal Entries

      - Create a new one

      - In Journal Items add a new line like this:

       

      - When saved we get:

      A value with the last Nth digits changed.

      I was able to debug in a local environment and my observations are:

      • Is not a problem from UI: emulating the creation of journal items from code gets the same results.
      • Is not a problem of visualization: wrong values are persisted into database.
      • At ORM level the large numbers are represented in python scientific notation, in this case 1.51337248356932e+18
        • From there python float "features" begin to work and the float part of the scientific notation gets transformed due to the way python stores float numbers.
      • If my tests are not wrong every single float field in Odoo is hit by this.

      I think is rare nobody has notice this before. Maybe I'm ignoring some very basic fact about currency settings in Odoo that's why I'm reaching U for help or any creative idea.

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      -- 
We are hiring: https://www.mint-system.ch/jobs
Send application to: jobs@mint-system.ch

CTO Mint System GmbH 
Tel: +41 44 244 7222

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Ing. Rolando Pérez Rebollo - 04:41 - 23 Oct 2024
    • Re: Big number changed automatically on float fields 
      https://docs.python.org/3/tutorial/floatingpoint.html


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com
      by Holger Brunn - 04:35 - 23 Oct 2024

      1 attachments 1 attachments

      signature.asc
    • Re: Big number changed automatically on float fields

      That is the right question - what problem are you trying to solve that requires 19 digit numbers.

      On the actual problem, this is how floating point numbers are designed to work at a low level, on Python and computers in general.
      Floating point numbers don't store all the number's digits.
      For efficiency they only store a limited number of "precision" digits (the ones you can see on the scientific representation) and then the power of 10 scale - where the ("floating") decimal point is.
      So for very large number, you lose precision on the rightmost digits of your number.

      /Daniel

      On 23/10/2024 15:12, Janik von Rotz wrote:

      Hi Rolando

      I'm interested in the business context of this problem. What kind of accounting are you doing where numbers have 19 digits?

      Your questions reminds me of the first Odoo Partner Days. Somebody asked something similar in the context of fuel prices. Fabien opened an interactive python shell and did something like:

      >>> import math
      >>> math.pow(2, 64)
      1.8446744073709552e+19

      The question was dismissed and we went on to the next question.

      > A value with the last Nth digits changed.

      What exactly changes? Can you compare the number entered and retrieved?

      Cheers, Janik

      On 10/23/24 15:32, Rolando Pérez Rebollo wrote:

      Hello, when trying to input very large numbers (with no decimals, 19 digits in my specific case) in credit or debit fields from journal items these numbers are changed on saving automatically with no explanation. The issue is easily reproducible in runbot Odoo 16 CE. I think a similar issue has been reported on github (https://github.com/odoo/odoo/issues/82597).

      Steps to reproduce (from a user with full accounting features enabled), demo db from runbot.com 16.0 CE:

      - Go to Invoicing/Accounting/Journal Entries

      - Create a new one

      - In Journal Items add a new line like this:

       

      - When saved we get:

      A value with the last Nth digits changed.

      I was able to debug in a local environment and my observations are:

      • Is not a problem from UI: emulating the creation of journal items from code gets the same results.
      • Is not a problem of visualization: wrong values are persisted into database.
      • At ORM level the large numbers are represented in python scientific notation, in this case 1.51337248356932e+18
        • From there python float "features" begin to work and the float part of the scientific notation gets transformed due to the way python stores float numbers.
      • If my tests are not wrong every single float field in Odoo is hit by this.

      I think is rare nobody has notice this before. Maybe I'm ignoring some very basic fact about currency settings in Odoo that's why I'm reaching U for help or any creative idea.

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      -- 
We are hiring: https://www.mint-system.ch/jobs
Send application to: jobs@mint-system.ch

CTO Mint System GmbH 
Tel: +41 44 244 7222

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe


      --
      DANIEL REIS
      MANAGING PARTNER

      >> Schedule time on my calendar.
      M: +351 919 991 307
      E: dreis@OpenSourceIntegrators.com
      A: Avenida da República 3000, Estoril Office Center, 2649-517 Cascais

      [Logo OpenSourceIntegrators.com]

      by Daniel Reis - 04:26 - 23 Oct 2024