How could I solve this error when trying to update account module?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

How could I solve this error when trying to update account module?

1 Reply

6843 Views

accounting error update

Pascal Tremblay

Please !!!!!

2015-02-11 20:17:25,257 16976 CRITICAL 111aaa openerp.service.server: Failed to initialize database `111aaa`.
Traceback (most recent call last):
File "/home/odoo/openerp/service/server.py", line 909, in preload_registries
    registry = RegistryManager.new(dbname, update_module=update_module)
File "/home/odoo/openerp/modules/registry.py", line 346, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
File "/home/odoo/openerp/modules/loading.py", line 359, in load_modules
    force, status, report, loaded_modules, update_module)
File "/home/odoo/openerp/modules/loading.py", line 263, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/home/odoo/openerp/modules/loading.py", line 182, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='data')
File "/home/odoo/openerp/modules/loading.py", line 118, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/home/odoo/openerp/tools/convert.py", line 901, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/home/odoo/openerp/tools/convert.py", line 987, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
File "/home/odoo/openerp/tools/convert.py", line 853, in parse
    self._tags[rec.tag](self.cr, rec, n, mode=mode)
File "/home/odoo/openerp/tools/convert.py", line 379, in _tag_function
    _eval_xml(self,rec, self.pool, cr, uid, self.idref, context=context)
File "/home/odoo/openerp/tools/convert.py", line 230, in _eval_xml
    res = getattr(model, method)(cr, uid, *args)
File "/home/odoo/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
File "/home/odoo/addons/account/account.py", line 1165, in account_assert_balanced
    "For all Journal Items, the state is valid implies that the sum " \
ParseError: "For all Journal Items, the state is valid implies that the sum of credits equals the sum of debits" while parsing /home/odoo/addons/account/account_assert_test.xml:4, near
<function name="account_assert_balanced" model="account.move"/>

Mariusz Mizgier

Best Answer

You have two ways to do that (first one is strongly suggested, second one is a brute-force solution)

1. Correct your accout_move table (and account_move_line) because this line says exactly what is wrong - one or more of the moves' sum of debits is not equal to sum of credits.

2. Comment out line 4 in account_assert_test.xml file so that check will not be done under module update.

Pascal Tremblay

Author

Thanks to take care of me. I will try it soon.

This question has been flagged