Pular para o conteúdo
Esta pergunta foi sinalizada
stock.picking
2 Respostas
6688 Visualizações
Avatar
Marc Wagener

I want update a field in stock.picking with a value from sale.order.

in sale.order : 'client_order_ref'.

in stock.picking: I've created a new field 'x_order_description'


my server action code on update:

active_id = context.get('active_id')

sale_obj = self.pool.get('sale.order')

picking_obj = self.pool.get('stock.picking')

picking_ids = picking_obj.search(cr, uid, [('sale_id', '=', active_id)], context=context)  #this returns all the pickings!

if picking_ids:

sale_record = self.browse(cr, uid, active_id, context=context)

picking_obj.write(cr, uid, picking_ids, {'x_order_description': sale_record.client_order_ref}, context=context)


the problem:

when updating the full table gets the new value of 'x_order_description', but I want only update the corresponding pickings

Avatar
Cancelar
Sayed Anisul Hoque

you can use the fields.related as like below: class stock_picking(osv.osv): _name = 'stock.picking' _inherit = 'stock.picking' _columns = { 'x_project_id' : fields.related('sale_id','x_project_id',type="char", readonly="True", string="Project ID"), #'x_project_id' : fields.char(string="Project ID"), }

Avatar
Akhil P Sivan
Melhor resposta

Hi,

Try the following:

in .py file:

class stock_picking(osv.osv):
    _inherit="stock.picking"     
     
    _columns ={
           'x_order_description': fields.related('sale_id', 'client_order_ref', string='Order Description', type='char', size=64, required=True, readonly=True)
           
           }

in your xml file:

<record id="view_picking_form_form_inherited" model="ir.ui.view">
            <field name="name">view.picking.form.view.inherited</field>
            <field name="model">stock.picking</field>
            <field name="inherit_id" ref="stock.view_picking_form"/>
            <field name="arch" type="xml">
                <field name="partner_id" position="after">
                	<field name="x_order_description" />
                </field>
            </field>
        </record>

Hope this helps

Avatar
Cancelar
Publicações relacionadas Respostas Visualizações Atividade
Odoo 15 - How to Separate stock.quant record lines
stock.picking
Avatar
0
fev. 23
3334
[11.0] I can't validate a transfer order(stock.picking)
stock.picking
Avatar
0
mar. 20
3272
Change state to custom new state in stock.picking Odoo 8 Resolvido
stock.picking
Avatar
4
jan. 16
7395
How to show moves and their details from picking
stock.move stock.picking
Avatar
Avatar
Avatar
2
mai. 25
7022
Where are Stock Picking created from Sale Order?
sale.order stock.picking
Avatar
Avatar
1
abr. 25
2510