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.

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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

supplier invoice line form fails to find field

fields form invoicing

1 Beantwoorden

4602 Weergaven

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

Beste antwoord

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Possibility to add dynamic fields in Form view fields form odoo	2 sep. 23	10840
Fiscal localization for Slovakia fields localisation invoicing	0 nov. 22	2364
Different way to hide the field ? fields form hide	1 mrt. 16	11166
How to align checkboxes, in a single line in form? Opgelost views fields form V17	2 jul. 24	2756
Field editing after create a form Opgelost fields form create edit	1 aug. 23	2910

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!