Build order part location export

[martin323232]

Is it possible export allocated part locations for a build order?
I can see location when pressing the "plus" icon and manually writing them down, but an export to pdf with part name and location would be nice.

[SergeoLacruz]

Hi,
This would be really interesting. I am already looking for a way to get these parts in the reporting system but i did not find the proper
context variables yet.
I tried .sub_part.build_order_allocations and .required_parts.build_order_allocations but as these variables are related to the part the resulting query set lists all allocations, also the ones from other BOs. Filtering those might get too complex. If I had the required variables I would like to create something like a packing list. See you,

Michael

[martin323232]

Thanks Michael for the code, this was just what I was looking for.

I’ve added a column for manufacturer part number, also using this on our labels.
The only way I’ve managed to use this is with the variable “item.supplier_part.manufacturer_part” but this also outputs manufacturer name, “Samsung Electro-Mechanics | CL10A475KQ8NNNC”.
How can I just get the manufacturer part name?

[SergeoLacruz]

Just guessing: manufacturer_part.name?

[martin323232]

There is no output when using manufacturer_part.name.
would also like to add part description. In labels "part.description" works, but no output in Build Order, {{ line.part.description }}

[SchrodingersGat]

If you are looking for the "manufacturer part name" you should be using item.supplier_part.manufacturer_part.MPN

You can make use of any attribute which exists on the particular model:

InvenTree/InvenTree/company/models.py

Line 272 in 55c14bd

MPN = models.CharField(

[martin323232]

thanks @SchrodingersGat

item.supplier_part.manufacturer_part.MPN worked for stock label, but no output in BO report

<td> {{ line.bom_item.reference }} </td> <td> {{ line.item.supplier_part.manufacturer_part.MPN }} </td> {% if line.stock_item.part.IPN == "DNP-000000-000" %} <td> do not place </td> <td> </td> {% else %} <td> {{ line.part.description }} </td> <td> {{ line.stock_item.location.name }} </td>

[SergeoLacruz]

manufacturer_parts and supplier_parts can be several. So try e.g.

  <table class='changes-table'>
    <thead>
      <tr>
        <th>.stock_item.part.IPN</th>
        <th>.stock_item.part.supplier_parts.all.0.SKU</th>
        <th>.stock_item.part.manufacturer_parts.all.0.MPN</th>
      </tr>
    </thead>
    <tbody>
  {% for line in build.allocated_stock.all %}
      <tr>
        <td> {{ line.stock_item.part.IPN }} </td>
        <td> {{ line.stock_item.part.supplier_parts.all.0.SKU }} </td>
        <td> {{ line.stock_item.part.manufacturer_parts.all.0.MPN }} </td>
      </tr>
  {% endfor %}
    </tbody>
  </table>

With .0 you get just the first from the list. 01 will sow the second ...

[martin323232]

@SergeoLacruz Thanks that worked perfectly.

[SergeoLacruz]

Hi,
You are welcome :-)
I am still locking for an easy way to find out if a build.bom_item.x has an allocated stock for that build or not. Anybody any idea?
Michael