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

[Jordi Esteve (www.zikzakmedia.com)]

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 [phone], 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, ' \

[Purnendu Singh (OpenERP) (purnendu-singh)]

Hello Jordi Esteve,

Thanks for your contribution, We have improve the code as per your suggestion in lp:~openerp-commiter/openobject-addons/trunk-dev-addons3-psi2

Revision No: 4617
Revision ID: <email address hidden>

Thanks,
PSI