I'm using odoo 9.0 community edition. I modified the *account.invoice.supplier.form *view to give me an editable form when modifying/creating invoice lines rather than the standard inline editing. To do this I changed: to I also did the same with account.invoice.form . The view that now pops up when I click an invoice line is *account.invoice.line.form*. The problem I'm getting when I do this from *account.invoice.supplier.

supplier invoice line form fails to find field

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

All Posts People Badges

Tags (View all)

odoo v14 accounting v15 odoo16features

About this forum

Help

supplier invoice line form fails to find field

fields form invoicing

1 Reply

2878 Views

Alexander Soare

I'm using odoo 9.0 community edition.

I modified the account.invoice.supplier.form view to give me an editable form when modifying/creating invoice lines rather than the standard inline editing. To do this I changed:

I also did the same with account.invoice.form.

The view that now pops up when I click an invoice line is account.invoice.line.form.

The problem I'm getting when I do this from account.invoice.supplier.form, is that when I click the many2one dropdown to select a Product I get the following error:

Odoo Server Error

Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 643, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 680, in dispatch
    result = self._call_function(**self.params)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 316, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 118, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 309, in checked_call
    result = self.endpoint(*a, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 959, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 509, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 892, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 884, in _call_kw
    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/product/product.py", line 1152, in name_search
    ids = self.search(cr, user, args, limit=limit, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/product/product.py", line 1184, in search
    return super(product_product, self).search(cr, uid, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 1658, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4748, in _search
    query = self._where_calc(cr, user, args, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4519, in _where_calc
    e = expression.expression(cr, user, domain, self, context)
  File "/usr/lib/python2.7/dist-packages/openerp/osv/expression.py", line 644, in __init__
    self.parse(cr, uid, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/osv/expression.py", line 840, in parse
    raise ValueError("Invalid field %r in leaf %r" % (left, str(leaf)))
ValueError: Invalid field u'purchase_ok' in leaf "<osv.ExtendedLeaf: (u'purchase_ok', u'=', True) on product_product (ctx: )>"

This does not happen from account.invoice.form.

How can I get around this error? Why does it happen?

Qutechs, Ahmed M.Elmubarak

Best Answer

Hello,

As summary this happened because of the fields_view_get function. Because you didn't defined a local form view this lead to call the original form view of the invoice.line which calls the fields_view_get function which add new domain.

So to get around this error you need to make a local form view. You can simply copy & past the original form view of the invoice line from and paste it after the </tree> of the field.

So your field looks like:

<tree string="Bill lines">
    <field name="sequence" widget="handle" />
    <field name="product_id" context="{'partner_id': parent.partner_id}"/>
    <field name="name"/>
    <field name="company_id" invisible="1"/>
    <field name="account_id" groups="account.group_account_user" domain="[('company_id', '=', parent.company_id), ('internal_type', '=', 'other')]"/>
    <field name="account_analytic_id" groups="analytic.group_analytic_accounting" domain="[('company_id', '=', parent.company_id), ('account_type', '=', 'normal')]"/>
     <field name="quantity"/>
     <field name="uom_id" groups="product.group_uom"/>
     <field name="price_unit"/>
     <field name="discount" groups="sale.group_discount_per_so_line"/>
     <field name="invoice_line_tax_ids" widget="many2many_tags" context="{'type':parent.type}"
                                        domain="[('type_tax_use','=','purchase'),('company_id', '=', parent.company_id)]" options="{'no_create': True}"/>
     <field name="price_subtotal"/>
     <field name="currency_id" invisible="1"/>
     </tree>
     <form string="Invoice Line">
      <group>
         <group>
             <field name="product_id" context="{'partner_id': parent.partner_id}"/>
              <label for="quantity"/>
               <div>
                  <field name="quantity" class="oe_inline"/>
                     <field name="uom_id" class="oe_inline" groups="product.group_uom"/>
                  </div>
                  <field name="price_unit"/>
                  <field name="discount" groups="sale.group_discount_per_so_line"/>
                  <field name="currency_id" invisible="1"/>
                   </group>
                     <group>
                 <field domain="[('company_id', '=', parent.company_id)]" name="account_id" groups="account.group_account_user"/>
              <field name="invoice_line_tax_ids" context="{'type':parent.get('type')}" domain="[('type_tax_use','!=','none'),('company_id', '=', parent.company_id)]" widget="many2many_tags" options="{'no_create': True}"/>
                <field domain="[('company_id', '=', parent.company_id), ('account_type', '=', 'normal')]" name="account_analytic_id" groups="analytic.group_analytic_accounting"/>
              <field name="company_id" groups="base.group_multi_company" readonly="1"/>
                </group>
                    </group>
                <label for="name"/>
                    <field name="name"/>
             </form>
  </field>

Hope this could help

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
Possibility to add dynamic fields in Form view fields form odoo	2 Sep 23	8069
Fiscal localization for Slovakia fields localisation invoicing	0 Nov 22	700
Different way to hide the field ? fields form hide	1 Mar 16	8938
How to align checkboxes, in a single line in form? Solved views fields form V17	2 Jul 24	487
Field editing after create a form Solved fields form create edit	1 Aug 23	976

This question has been flagged

Enjoying the discussion? Don't just read, join in!