c2c-oerpscenario team mailing list archive

["Azazahmed Saiyed \(OpenERP\)" <714444@xxxxxxxxxxxxxxxxxx>]

Hello,

I have attached the screen shot of database for your reference. Just
execute the query for the fields which has the 'Account' string
precision in digits_compute=dp.get_precision('Account') function. And
all the data stored with the uniform precision.

Thanks.

** Attachment added: "postgres.png"
   https://bugs.launchpad.net/openobject-server/+bug/714444/+attachment/1835520/+files/postgres.png

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/714444

Title:
  [6.0] numeric data types have no decimals

Status in OpenERP Server:
  New

Bug description:
  ** in V5 "numeric(16,2)"
  ** in V6 everything is "numeric"
  (checked account_move_line, invoice_line as it is vital for accounting)
  this means values with any precision can be stored. (especially when bypassing the OpenERP engine) 

  debit|credit in a demo installation
  shows 2 lines with only one decimal digit - although IMHO it should have 2
  select debit,credit,tax_amount from account_move_line;

   2000.00 |    0.00 |           
      0.00 |    0.00 |           
    5000.0 |    0.00 |           
      0.00 | 11000.0 |           
   9000.00 |    0.00 | 

  I am not saying this is necessarily an error, but developers should be
  aware of this change.