c2c-oerpscenario team mailing list archive

["Vinay Rana \(openerp\)" <699809@xxxxxxxxxxxxxxxxxx>]

** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
       Status: New => Confirmed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)

-- 
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/699809

Title:
  [6.0 and 5.0] Installing account_analytic_analysis you have a maximu
  of 2147 analytic accounts

Status in OpenObject Addons Modules:
  Confirmed

Bug description:
  If you install account_analytic_analysis module, you can no have more
  than 2147 analytic accounts because you get a postgres error: Integer
  is outside of range.

  In account_analytic_analysis/account_analytic_analysis.py file,
  account_analytic_analysis_summary_month postgres view is created as
  (line 630 in 6.0, line 634 in 5.0):

  '(TO_NUMBER(TO_CHAR(d.month, \'YYYYMM\'), \'999999\') + (d.account_id
  * 1000000))::integer AS id, ' \

  if account_id is bigger than 2147, then 2148 * 1000000 is bigger than
  +2147483647, the integer maximum value.

  IMHO, it usual that a company have more that 2147 analytic account, so
  I suggest to change the above line to:

  '(TO_NUMBER(TO_CHAR(d.month, \'YYYYMM\'), \'999999\') + (d.account_id
  * 1000000::bigint))::bigint AS id, ' \