← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 663279] [NEW] [v6] error creating budget lines - no account assigned

 

Public bug reported:

this is with v6 updated on 19/10
module account_budget

when I try to create budget lines (Accounting -> budgets-> budgets) I get this error:
 File "/home/cache/dev/trunk/openobject-addons/account_budget/account_budget.py", line 135, in _prac
    res[line.id] = self._prac_amt(cr, uid, [line.id], context=context)[line.id]
  File "/home/cache/dev/trunk/openobject-addons/account_budget/account_budget.py", line 125, in _prac_amt
    "general_account_id=ANY(%s)", (line.analytic_account_id.id, date_from, date_to,acc_ids,))
  File "/home/cache/dev/trunk/openobject-server/bin/sql_db.py", line 75, in wrapper
    return f(self, *args, **kwargs)
  File "/home/cache/dev/trunk/openobject-server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...mount) FROM account_analytic_line WHERE account_id=false AND...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.


It seems like the error is in the _prac_amt function, line 123-125
line.analytic_account_id.id is = false and it should contain the analytic accoutn id....
where do you assign the analytic account in the budget line?

thanx

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
[v6] error creating budget lines - no account assigned
https://bugs.launchpad.net/bugs/663279
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP OpenObject.

Status in OpenObject Addons Modules: New

Bug description:
this is with v6 updated on 19/10
module account_budget

when I try to create budget lines (Accounting -> budgets-> budgets) I get this error:
 File "/home/cache/dev/trunk/openobject-addons/account_budget/account_budget.py", line 135, in _prac
    res[line.id] = self._prac_amt(cr, uid, [line.id], context=context)[line.id]
  File "/home/cache/dev/trunk/openobject-addons/account_budget/account_budget.py", line 125, in _prac_amt
    "general_account_id=ANY(%s)", (line.analytic_account_id.id, date_from, date_to,acc_ids,))
  File "/home/cache/dev/trunk/openobject-server/bin/sql_db.py", line 75, in wrapper
    return f(self, *args, **kwargs)
  File "/home/cache/dev/trunk/openobject-server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...mount) FROM account_analytic_line WHERE account_id=false AND...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.


It seems like the error is in the _prac_amt function, line 123-125
line.analytic_account_id.id is = false and it should contain the analytic accoutn id....
where do you assign the analytic account in the budget line?

thanx





Follow ups

References