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

Related Posts	Odgovori	Prikazi
Partial production declaration mrp production	3 mar. 21	5760
Odoo 11: Accidentally cancelled an MO MAnifacturing order mrp production	0 jul. 20	3731
how to start a group of workorders simultaneously with components lots allocation ? [V13] mrp production lots	0 okt. 20	2964
MRP Workorder lot MO confirmation error mrp workorder production	0 dec. 15	5875
Product Cost Structure with BoM and Routing mrp v7 production	1 avg. 15	12127

This question has been flagged

Enjoying the discussion? Don't just read, join in!