Production Order Report

Question

I'm trying to amend the Production Order report so that I can show the field note from mrp.routing.workcenter.

I think that's probably the best field to put specific instructions for what should happen at a particular point in a routing, checking something against a spec for example.

My problem seems to be that that particular field doesn't appear in mrp_production_workcenter_line which is what the Production Order report references.

I'm sure I'm missing something really obvious but, how do I

Andreas Brueckl · Answer

From within the report you can access the field note of the workcenter of the routing with

[[ (line2.workcenter_id and line2.workcenter_id.note) or '' ]]
So what you have missed is the connection through workcenter_id to access the fields of mrp_routing_workcenter .

Billy Watt · Answer

That's exactly what I thought Andreas, however, when I put the following in

     <td>
        <para style="terp_default_Centre_8">[[ (line2.workcenter_id and line2.workcenter_id.note) or '' ]]</para>
      </td>
      <td>
        <para style="terp_default_Centre_8">[[ (line2.workcenter_id and line2.workcenter_id.name) or '' ]]</para>
      </td>

The first part, which should be my note field is blank and the second part is correctly filled in with the workcenter name.

It's a little confusing

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Partial production declaration mrp production	3 maalisk. 21	5769
Odoo 11: Accidentally cancelled an MO MAnifacturing order mrp production	0 heinäk. 20	3739
how to start a group of workorders simultaneously with components lots allocation ? [V13] mrp production lots	0 lokak. 20	2967
MRP Workorder lot MO confirmation error mrp workorder production	0 jouluk. 15	5892
Product Cost Structure with BoM and Routing mrp v7 production	1 elok. 15	12138

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!