This question has been flagged
3 Replies
3262 Views

hi, I am trying to install POS after I uninstalled it as I was not been able to start my sale session due to following error

"All available pricelists must be in same currency as the company or as sales journal set on this point of sale if you use accounting application."


I am new on Odoo please guide me.

Avatar
Discard
Best Answer

Hi Muhammad,

You need to make sure your POS Configuration's journal currency is the same as the one you set in your pricelist

Image 1.png



Avatar
Discard
Author Best Answer

thanks for your solution but that is just one part of problem, I uninstalled POS then again tried to install it but faced following problem: kindly help


Odoo Server Error

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 712, in parse
    self._tag_root(de)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 674, in _tag_root
    f(rec)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 674, in _tag_root
    f(rec)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 577, in _tag_record
    record = model._load_records([data], self.mode == 'update')
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 4080, in _load_records
    records = self._load_records_create([data['values'] for data in to_create])
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 3994, in _load_records_create
    return self.create(values)
  File "<decorator-gen-174>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 317, in _model_create_single
    return self.browse().concat(*(create(self, vals) for vals in arg))
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 317, in <genexpr>
    return self.browse().concat(*(create(self, vals) for vals in arg))
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\point_of_sale\models\pos_config.py", line 444, in create
    pos_config = super(PosConfig, self).create(values)
  File "<decorator-gen-3>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 335, in _model_create_multi
    return create(self, [arg])
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 3742, in create
    records = self._create(data_list)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 3828, in _create
    cr.execute(query, params)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\sql_db.py", line 164, in wrapper
    return f(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\sql_db.py", line 241, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.NotNullViolation: null value in column "pricelist_id" violates not-null constraint
DETAIL:  Failing row contains (1, Shop, 37, 9, 1, null, null, null, null, null, null, null, f, t, null, subtotal, null, null, null, null, null, null, null, t, 351689a0-5e23-4fa1-ba44-5870b399cf67, 160, 161, null, 1, 1, 119, 118, null, null, null, null, null, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, 1, 2020-05-27 18:37:32.708669, 1, 2020-05-27 18:37:32.708669).


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 624, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 310, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\pycompat.py", line 14, in reraise
    raise value
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 669, in dispatch
    result = self._call_function(**self.params)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 350, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\service\model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 339, in checked_call
    result = self.endpoint(*a, **kw)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 915, in __call__
    return self.method(*args, **kw)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 515, in response_wrap
    response = f(*args, **kw)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\web\controllers\main.py", line 1326, in call_button
    action = self._call_kw(model, method, args, kwargs)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\web\controllers\main.py", line 1314, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 387, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 374, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "<decorator-gen-59>", line 2, in button_immediate_install
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\base\models\ir_module.py", line 72, in check_and_log
    return method(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\base\models\ir_module.py", line 463, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\base\models\ir_module.py", line 573, in _button_immediate_function
    modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\modules\registry.py", line 86, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\modules\loading.py", line 423, in load_modules
    loaded_modules, update_module, models_to_check)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\modules\loading.py", line 315, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\modules\loading.py", line 225, in load_module_graph
    load_data(cr, idref, mode, kind='data', package=package, report=report)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\modules\loading.py", line 68, in load_data
    tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 736, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 803, in convert_xml_import
    obj.parse(doc.getroot())
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 721, in parse
    exc_info[2]
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\pycompat.py", line 13, in reraise
    raise value.with_traceback(tb)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 712, in parse
    self._tag_root(de)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 674, in _tag_root
    f(rec)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 674, in _tag_root
    f(rec)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\convert.py", line 577, in _tag_record
    record = model._load_records([data], self.mode == 'update')
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 4080, in _load_records
    records = self._load_records_create([data['values'] for data in to_create])
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 3994, in _load_records_create
    return self.create(values)
  File "<decorator-gen-174>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 317, in _model_create_single
    return self.browse().concat(*(create(self, vals) for vals in arg))
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 317, in <genexpr>
    return self.browse().concat(*(create(self, vals) for vals in arg))
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\point_of_sale\models\pos_config.py", line 444, in create
    pos_config = super(PosConfig, self).create(values)
  File "<decorator-gen-3>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 335, in _model_create_multi
    return create(self, [arg])
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 3742, in create
    records = self._create(data_list)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 3828, in _create
    cr.execute(query, params)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\sql_db.py", line 164, in wrapper
    return f(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0\server\odoo\sql_db.py", line 241, in execute
    res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "null value in column "pricelist_id" violates not-null constraint
DETAIL:  Failing row contains (1, Shop, 37, 9, 1, null, null, null, null, null, null, null, f, t, null, subtotal, null, null, null, null, null, null, null, t, 351689a0-5e23-4fa1-ba44-5870b399cf67, 160, 161, null, 1, 1, 119, 118, null, null, null, null, null, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, 1, 2020-05-27 18:37:32.708669, 1, 2020-05-27 18:37:32.708669).
" while parsing file:/c:/program files (x86)/odoo 13.0/server/odoo/addons/point_of_sale/data/point_of_sale_data.xml:2, near
<odoo>
    <data noupdate="1">
        <!-- After closing the PoS, open the dashboard menu -->
        <record id="action_client_pos_menu" model="ir.actions.client">
            <field name="name">Open POS Menu</field>
            <field name="tag">reload</field>
            <field name="params" eval="{'menu_id': ref('menu_point_root')}"/>
        </record>

        <function model="stock.warehouse" name="_create_missing_pos_picking_types"/>

        <record id="product_category_pos" model="product.category">
            <field name="parent_id" ref="product.product_category_1"/>
            <field name="name">PoS</field>
        </record>

        <record id="product_product_tip" model="product.product">
            <field name="name">Tips</field>
            <field name="categ_id" ref="point_of_sale.product_category_pos"/>
            <field name="default_code">TIPS</field>
            <field name="weight">0.01</field>
            <field name="available_in_pos" eval="True"/>
            <field name="taxes_id" eval="[(5,)]"/>
        </record>

        <record model="pos.config" id="pos_config_main">
            <field name="name">Shop</field>
            <field name="barcode_nomenclature_id" ref="barcodes.default_barcode_nomenclature"/>
        </record>

        <record id="product_product_consumable" model="product.product">
            <field name="name">Discount</field>
            <field name="available_in_pos">True</field>
            <field name="standard_price">0.00</field>
            <field name="list_price">0.00</field>
            <field name="weight">0.00</field>
            <field name="type">consu</field>
            <field name="categ_id" ref="point_of_sale.product_category_pos"/>
            <field name="uom_id" ref="uom.product_uom_unit"/>
            <field name="uom_po_id" ref="uom.product_uom_unit"/>
            <field name="default_code">DISC</field>
            <field name="purchase_ok">False</field>
        </record>

        <record id="uom.product_uom_categ_unit" model="uom.category">
            <field name="is_pos_groupable">True</field>
        </record>
        <function model="pos.config" name="post_install_pos_localisation"/>
    </data>
</odoo>


Avatar
Discard
Best Answer

محمد ياتري تم حل ه>ا العطل لانة لدي للاسف ولم اعثر علي حل الي الآن 

شكرا

Avatar
Discard