Odoo Help


Show history sale by partner by product

abdelwahed chiheb
on 3/9/14, 4:21 AM 1,449 views

I want to show a history of sale by partner by product: when i open the form view of sale qutation and when i choose a product i want to have a button when i click a popup apper to list the history sale for this partner and this product (qty,price ....)

this is my module.py :

def product_history_client(self, cr, uid, ids, context=None):
    ir_model_data = self.pool.get('ir.model.data')
        compose_form_id = ir_model_data.get_object_reference(cr, uid, 'sms_product_client_hist', 'hist_product_cust')[1]
    except ValueError:
        compose_form_id = False
    return {
        'name': _('Customer sale history'),
        'type': 'ir.actions.act_window',
        'view_type': 'form',
        'view_mode': 'form',
        'res_model': 'sale.order.line',
        'views': [(compose_form_id, 'form')],
        'view_id': compose_form_id,
        'target': 'new',
        'context': context,

and module.xml:

<?xml version="1.0"?>

<openerp> <data>

  <record id="hist_product_cust" model="ir.ui.view">
    <field name="name">hist.product.cust</field>
    <field name="model">product.product</field>
    <field name="type">tree</field>
    <field name="priority">16</field>
    <field name="arch" type="xml">
        <tree string="product cust">
            <field name="id"/>
            <field name="name"/>

  <record id="view_order_form_histo" model="ir.ui.view">
  <field name="name">sale.order.form.histo</field>
  <field name="model">sale.order</field>
  <field name="inherit_id" ref="sale.view_order_form"/>
  <field name="arch" type="xml">
      <xpath expr="/form/sheet/notebook/page/field[@name='order_line']/form/group/group/div/field[@name='product_uom_qty']" position="after">
          <!-- <button name="%(pop_hist_product)d" string="historique client" type="action" class="oe_highlight" /> -->
          <button name="product_history_client" string="historique client" type="object" class="oe_highlight oe_link" />




the popup window appear normally but when i close it a got this error :(

DataError: invalid input syntax for integer: "one2many_v_id_370" LINE 1: ...OM "sale_order_line" WHERE sale_order_line.id IN ('one2many_...

how can i fix this, i'm blocked please any idea will be appreciated

Thanks :)

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/9/14, 4:21 AM
Seen: 1449 times
Last updated: 3/16/15, 8:10 AM