Add Pack Quantity and Total Quantity to purchase order

[mabroens]

Hi,

i woud like to extend my PO report such that it prints the pack quantity and Total qty on the report.
some parts i can order in pcs some in reels of 1k/5k/10k so when placing an order i would like to show this clearly on the report like:

what do i need to do for that? i currently have this apreparation:

      {% for line in lines.all %}
        <tr>
            <td>
				<div class='thumb-container'>
                    <img src='{% part_image line.part.part %}' class='part-thumb'>
                </div>
            </td>
            <td>
                <div class='part-text'>
					{% if line.part.part.revision %} 
					  <strong>{{ line.part.part.IPN }} {{line.part.part.revision}}-Sample</strong>
					{% else %} 
                      <strong>{{ line.part.part.name }}</strong>
					{% endif %}
					<br><br>
					{{ line.part.part.description }}
                </div>
            </td>
            <td>{% decimal line.quantity %}</td>
            <td>{% decimal part.Pack Quantity %}</td>                      
            <td>{% decimal line.quantity %}</td>
			<td>{% render_currency line.price decimal_places=2 currency=order.customer.currency include_symbol=False%}</td>
			<td>{% render_currency line.total_line_price decimal_places=2 currency=order.customer.currency include_symbol=False%}</td>
        </tr>
        {% endfor %}

which clearly is nt correct but where can i find the attributes im looking for?
aim is to have:

this on ly report extended with the total end qty pcs. s 3 reels of 1k results in 3k pcs.

please advice
br martijn

[SchrodingersGat]

Look at the SupplierPart model for the available fields:

InvenTree/src/backend/InvenTree/company/models.py

Line 630 in fe807cb

class SupplierPart(

The field you are looking for is the pack_quantity field:

InvenTree/src/backend/InvenTree/company/models.py

Line 854 in fe807cb

pack_quantity = models.CharField(

So you should be able access with:

            <td>{% decimal part.pack_quantity %}</td> 

[mabroens]

@SchrodingersGat thanks for the feedback but for some reason that is inot working for me.
i have follwoing code:

<table class="invoice-data">
		<tr>
            <td colspan='2'><strong>Part</strong></td> 
            <td style="width: 30px;"><strong>Qty</strong></td>
            <td style="width: 30px;"><strong>Packaging</strong></td>
            <td style="width: 30px;"><strong>Pack Qty</strong></td>
            <td style="width: 30px;"><strong>Total Qty</strong></td>
            <td style="width: 70px;"><strong>Unit Price</strong></td>
            <td style="width: 70px;"><strong>Total Price</strong></td>
        </tr>

        {% for line in lines.all %}
        <tr>
            <td>
				<div class='thumb-container'>
                    <img src='{% part_image line.part.part %}' class='part-thumb'>
                </div>
            </td>
            <td>
                <div class='part-text'>
					{% if line.part.part.revision %} 
					  <strong>{{ line.part.part.IPN }} {{line.part.part.revision}}-Sample</strong>
					{% else %} 
                      <strong>{{ line.part.part.name }}</strong>
					{% endif %}
					<br><br>
					{{ line.part.part.description }}
                </div>
            </td>
            <td>{% decimal line.quantity %}</td>                   <!-- Qty -->
            <td>{% decimal line.part.part.units %}</td>            
            <!-- <td>{Pack Qty}</td> -->
            <td>{% decimal line.part.part.pack_quantity  %}</td>        
            {% multiply line.quantity 1 as Total_Qty %}
            <td>{% decimal Total_Qty  %}</td>   <!-- Total Qty -->
			<td>{% render_currency line.price decimal_places=2 currency=order.customer.currency include_symbol=False%}</td>
			<td>{% render_currency line.total_line_price decimal_places=2 currency=order.customer.currency include_symbol=False%}</td>
        </tr>
        {% endfor %}

which results in:

Addititionally i noticed that line,part.part.units returns the Units from the base part.
which for the first part is set to pcs and teh second does not have it filled. but at this posistion i would lneed the Packaging from the supplier.

not from the part. sinc this is a PO for a supplier.

[SchrodingersGat]

<td>{% decimal line.part.part.pack_quantity %}</td> should instead be <td>{% decimal line.part.pack_quantity %}</td>

[mabroens]

yes that works. thank you.

why does:

 {% multiply line.quantity line.part.pack_quantity as Total_Qty %}
            <td>{% decimal Total_Qty %}</td>

not work?

[SchrodingersGat]

To use "as" you need to be operating within a "with" block i.e. {% with x as y %}

https://docs.djangoproject.com/en/5.1/ref/templates/builtins/#with

[mabroens]

Thanks for the upe but unfortunatly i still dont get it. :-( sorry.

{% for line in lines.all %}
       <tr>
           <td>
   			<div class='thumb-container'>
                   <img src='{% part_image line.part.part %}' class='part-thumb'>
               </div>
           </td>
           <td>
               <div class='part-text'>
   				{% if line.part.part.revision %} 
   				  <strong>{{ line.part.part.IPN }} {{line.part.part.revision}}-Sample</strong>
   				{% else %} 
                     <strong>{{ line.part.part.name }}</strong>
   				{% endif %}
   				<br><br>
   				{{ line.part.part.description }}
               </div>
           </td>
           <td>{% decimal line.quantity %}</td>
           <td>{% decimal line.part.part.units %}</td> 
           <!-- <td>{% decimal line.part.pack_quantity  %}</td> -->
           {% multiply line.quantity 1000 as TotalQty %}
           <td>{% decimal TotalQty %} </td>
   		<td>{% render_currency line.price decimal_places=2 currency=order.customer.currency include_symbol=False%}</td>
   		<td>{% render_currency line.total_line_price decimal_places=2 currency=order.customer.currency include_symbol=False%}</td>
       </tr>
       {% endfor %}

the above seems to work. but than i have a fixed value of 1000

which is not what i want. i want to us ethe pack qty for this particulair SKU.

but when i replace the 1000 with line.part.pack_quantity
{% multiply line.quantity line.part.pack_quantity as TotalQty %}
than that failes.

i have been playing with the with block but without any luck.

can you please give the correct syntax for what i try to achieve?

Br Martijn

[SchrodingersGat]

I think that you should be able to use:

 {% with multiply line.quantity line.part.pack_quantity as TotalQty %}

Note the with command at the start.

Can you please share the actual error message which is generated by your failed attempt above?

[mabroens]

@SchrodingersGat

Thanks for the example.
i changed my code but as soon as i do no matter what with the with statement it failes.

my code:

{% for line in lines.all %}
       <tr>
           <td>
   			<div class='thumb-container'>
                   <img src='{% part_image line.part.part %}' class='part-thumb'>
               </div>
           </td>
           <td>
               <div class='part-text'>
   				{% if line.part.part.revision %} 
   				  <strong>{{ line.part.part.IPN }} {{line.part.part.revision}}-Sample</strong>
   				{% else %} 
                     <strong>{{ line.part.part.name }}</strong>
   				{% endif %}
   				<br><br>
   				{{ line.part.part.description }}
               </div>
           </td>
           <td>{% decimal line.quantity %}</td>
           <td>{% decimal line.part.part.units %}</td> 
           <td>{% decimal line.part.pack_quantity  %}</td>
           {% with multiply line.quantity line.part.pack_quantity as TotalQty %}
           <td>{% decimal TotalQty %} </td>
           {% endwith %}
   		<td>{% render_currency line.price decimal_places=2 currency=order.customer.currency include_symbol=False%}</td>
   		<td>{% render_currency line.total_line_price decimal_places=2 currency=order.customer.currency include_symbol=False%}</td>
       </tr>
       {% endfor %}

what does work is:

<td>{% decimal line.part.pack_quantity  %}</td>
{% multiply line.quantity 1 as TotalQty %}
<td>{% decimal TotalQty %} </td>

but whi change that to:

<td>{% decimal line.part.pack_quantity  %}</td>
{% with multiply line.quantity 1 as TotalQty %}
<td>{% decimal TotalQty %} </td>
{% endwith %}

that will lso result in Error renderig template.

and i am at:

br Martijn

[SchrodingersGat]

@mabroens looks like I should have read the docs.. that I wrote..

https://docs.inventree.org/en/stable/report/helpers/#assigning-variables