Skip to Content
This question has been flagged
installationmodulepoint_of_sale
1 Reply
3609 Views
Avatar
Rene Bendana

 I am carrying out the implementation of odoo in the company where I work, currently it is already in production, carry out the massive load of the movements of these first months of the year. I have made some additions such as fields, inherited views, etc ... and we imported our own chart of account.


Currently we want to use the point of sale, but for some reason it does not allow me. when I give the module to install, it shows me the following error. As I understand it, it is because it is taking the receivable_account_id as null, which I cannot explain why this happens.

Could it be that it is because we load our own chart of accounts and the module needs to take the ones that odoo brings by default?


How could I solve it?


As an extra piece of information, the license we have is odoo online.



Odoo Server Error
Traceback (most recent call last):
  File "/home/odoo/src/odoo/14.0/odoo/tools/convert.py", line 677, in _tag_root
    f(rec)
  File "/home/odoo/src/odoo/14.0/odoo/tools/convert.py", line 330, in _tag_function
    _eval_xml(self, rec, env)
  File "/home/odoo/src/odoo/14.0/odoo/tools/convert.py", line 201, in _eval_xml
    return odoo.api.call_kw(model, method_name, args, kwargs)
  File "/home/odoo/src/odoo/14.0/odoo/api.py", line 392, in call_kw
    result = _call_kw_model(method, model, args, kwargs)
  File "/home/odoo/src/odoo/14.0/odoo/api.py", line 365, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "/home/odoo/src/odoo/14.0/addons/point_of_sale/models/pos_config.py", line 649, in post_install_pos_localisation
    pos_configs.setup_defaults(company)
  File "/home/odoo/src/odoo/14.0/addons/point_of_sale/models/pos_config.py", line 658, in setup_defaults
    self.assign_payment_journals(company)
  File "/home/odoo/src/odoo/14.0/addons/point_of_sale/models/pos_config.py", line 677, in assign_payment_journals
    payment_methods |= payment_methods.create({
  File "<decorator-gen-65>", line 2, in create
  File "/home/odoo/src/odoo/14.0/odoo/api.py", line 344, in _model_create_multi
    return create(self, [arg])
  File "/home/odoo/src/odoo/14.0/odoo/addons/base/models/ir_fields.py", line 533, in create
    recs = super().create(vals_list)
  File "<decorator-gen-13>", line 2, in create
  File "/home/odoo/src/odoo/14.0/odoo/api.py", line 345, in _model_create_multi
    return create(self, arg)
  File "/home/odoo/src/odoo/14.0/odoo/models.py", line 3868, in create
    records = self._create(data_list)
  File "/home/odoo/src/odoo/14.0/odoo/models.py", line 3974, in _create
    cr.execute(query, params)
  File "<decorator-gen-3>", line 2, in execute
  File "/home/odoo/src/odoo/14.0/odoo/sql_db.py", line 101, in check
    return f(self, *args, **kwargs)
  File "/home/odoo/src/odoo/14.0/odoo/sql_db.py", line 298, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.NotNullViolation: null value in column "receivable_account_id" violates not-null constraint
DETAIL:  Failing row contains (1, Banco, null, f, null, f, 1, null, t, 1, 2021-05-17 22:07:56.187313, 1, 2021-05-17 22:07:56.187313).


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/odoo/src/odoo/14.0/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 683, in dispatch
    result = self._call_function(**self.params)
  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 359, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/odoo/src/odoo/14.0/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 347, in checked_call
    result = self.endpoint(*a, **kw)
  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 912, in __call__
    return self.method(*args, **kw)
  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 531, in response_wrap
    response = f(*args, **kw)
  File "/home/odoo/src/odoo/14.0/addons/web/controllers/main.py", line 1389, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/home/odoo/src/odoo/14.0/addons/web/controllers/main.py", line 1381, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/home/odoo/src/odoo/14.0/odoo/api.py", line 396, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/home/odoo/src/odoo/14.0/odoo/api.py", line 383, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/home/odoo/src/custom/trial/saas_trial/models/module.py", line 112, in button_immediate_install
    return super(IrModuleModule, self).button_immediate_install()
  File "<decorator-gen-72>", line 2, in button_immediate_install
  File "/home/odoo/src/odoo/14.0/odoo/addons/base/models/ir_module.py", line 73, in check_and_log
    return method(self, *args, **kwargs)
  File "/home/odoo/src/odoo/14.0/odoo/addons/base/models/ir_module.py", line 474, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "/home/odoo/src/custom/trial/saas_trial/models/module.py", line 99, in _button_immediate_function
    res = super(IrModuleModule, self)._button_immediate_function(function)
  File "/home/odoo/src/odoo/14.0/odoo/addons/base/models/ir_module.py", line 592, in _button_immediate_function
    modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "/home/odoo/src/odoo/14.0/odoo/modules/registry.py", line 89, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/home/odoo/src/odoo/14.0/odoo/modules/loading.py", line 453, in load_modules
    processed_modules += load_marked_modules(cr, graph,
  File "/home/odoo/src/odoo/14.0/odoo/modules/loading.py", line 346, in load_marked_modules
    loaded, processed = load_module_graph(
  File "/home/odoo/src/odoo/14.0/odoo/modules/loading.py", line 221, in load_module_graph
    load_data(cr, idref, mode, kind='data', package=package)
  File "/home/odoo/src/odoo/14.0/odoo/modules/loading.py", line 69, in load_data
    tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind)
  File "/home/odoo/src/odoo/14.0/odoo/tools/convert.py", line 733, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate)
  File "/home/odoo/src/odoo/14.0/odoo/tools/convert.py", line 799, in convert_xml_import
    obj.parse(doc.getroot())
  File "/home/odoo/src/odoo/14.0/odoo/tools/convert.py", line 719, in parse
    self._tag_root(de)
  File "/home/odoo/src/odoo/14.0/odoo/tools/convert.py", line 677, in _tag_root
    f(rec)
  File "/home/odoo/src/odoo/14.0/odoo/tools/convert.py", line 681, in _tag_root
    raise ParseError('while parsing %s:%s, near\n%s' % (
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 639, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 315, in _handle_exception
    raise exception.with_traceback(None) from new_cause
odoo.tools.convert.ParseError: while parsing /home/odoo/src/odoo/14.0/addons/point_of_sale/data/point_of_sale_data.xml:49, near
<function model="pos.config" name="post_install_pos_localisation"/>




Avatar
Discard
Avatar
Chris TRINGHAM
Best Answer

This may be because the default accounts are not set up in Company Properties 

If the record does exist, check the value


If the value is blank or not correct, you can update it (6 is the Record ID for the Accounts Receivable account in the Chart of Accounts - yours will probably be different). 

Normally this is created when you select a country during installation or if you install a Fiscal Localization package.  If you created a COA manually it would not be setup properly.

More information 

Avatar
Discard
Rene Bendana
Author

I thank you for your reply.

I am trying to do what you mention but I observe that I have a lot of properties pointing to that field. so I'm not sure if this is normal or represents something else.

Chris TRINGHAM

There should be multiple properties for different default accounts (receivable, payable, etc.)

Rene Bendana
Author

Again, I thank you for your help :)

I have done what you told me and I see that the IDs are fine, I still have the same problem.

We are also making use of the multi-company and multi-currency, could this be part of the cause?

Chris TRINGHAM

I'm not very good at understanding these error messages, but it seems that there is an invalid record in company parameters.

Could be because of multi-company.

Related Posts Replies Views Activity
how can I resolve dependency for Module called unidecode? Solved
installation module
Avatar
Avatar
Avatar
Avatar
Avatar
6
Sep 24
50453
How to run a python function right after installing a module?
installation module
Avatar
2
Jun 20
18524
Obtain customer information and order in the point of sale module
module point_of_sale
Avatar
Avatar
1
May 19
3372
How to load third party modules in Odoo 9 Enterprse?
installation module
Avatar
0
Mar 16
5045
how to move a modules inside the /opt/openerp folder?
installation module
Avatar
Avatar
1
Feb 16
5078