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
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

supplier invoice line form fails to find field

fields form invoicing

1 Odpowiedz

4551 Widoki

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

Najlepsza odpowiedź

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

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Possibility to add dynamic fields in Form view fields form odoo	2 wrz 23	10754
Fiscal localization for Slovakia fields localisation invoicing	0 lis 22	2292
Different way to hide the field ? fields form hide	1 mar 16	11073
How to align checkboxes, in a single line in form? Rozwiązane views fields form V17	2 lip 24	2684
Field editing after create a form Rozwiązane fields form create edit	1 sie 23	2806

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!