Hi, I try to close the fiscal year and get the following error:
Traceback (most recent call last): File "/usr/lib/python2.4/site-packages/tinyerp-server/netsvc.py", line 338, in run r=m(*msg[2:]) File "/usr/lib/python2.4/site-packages/tinyerp-server/service/web_services.py", line 422, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/usr/lib/python2.4/site-packages/tinyerp-server/service/web_services.py", line 402, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/usr/lib/python2.4/site-packages/tinyerp-server/wizard/__init__.py", line 160, in execute res = self.execute_cr(cr, uid, data, state, context) File "/usr/lib/python2.4/site-packages/tinyerp-server/wizard/__init__.py", line 75, in execute_cr action_res = action(self, cr, uid, data, context) File "/usr/lib/python2.4/site-packages/tinyerp-server/addons/account/wizard/wizard_fiscalyear_close.py", line 105, in _data_save 'LIMIT %d OFFSET %d', (account.id, limit, offset)) File "/usr/lib/python2.4/site-packages/tinyerp-server/sql_db.py", line 73, in execute res = self.obj.execute(sql, p) ProgrammingError: ERROR: missing FROM-clause entry for table "l" SELECT name, quantity, debit, credit, account_id, ref, amount_currency, currency_id, blocked, partner_id, date_maturity, date_created FROM account_move_line WHERE account_id = 51 AND account_move_line.active AND account_move_line.state<>'draft' AND account_move_line.period_id in (SELECT id from account_period WHERE fiscalyear_id in (1)) and (l.journal_id in (select id from account_journal where state='valid')) AND reconcile_id is NULL ORDER BY id LIMIT 100 OFFSET 0 It seems that there is a bug in the sql request. Is this a bug or a problem with my configuration? Thanks for your advices... -------------------- m2f -------------------- -- http://www.openerp.com/forum/viewtopic.php?p=27236#27236 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
