How to add unit price and total price when printing purchase order as pdf?

[anonkwe]

How to add unit price and total price when printing purchase order as pdf?

{% decimal line.purchase_price %} does not work... not much seems to be working

[SchrodingersGat]

Can you share your entire template?

[anonkwe]

<h3 style="text-transform:uppercase;">{% trans "Items" %}</h3>
<table class='table table-striped table-condensed'>
    <thead>
        <tr>
		<th>Description</th>
		<th>QTEE/QTY</th>
		<th>Prix/Price</th>
		<th>Total</th>
            
        </tr>
    </thead>
    <tbody>
        {% for line in lines.all %}
        <tr>
            <td>
                <div class='thumb-container'>
                    <img src='{% part_image line.part.part %}' class='part-thumb'>
                </div>
                <div class='part-text'>
                    {{ line.part.part.full_name }}
                
            </td>
            <td>{% decimal line.quantity %} PMP</td>
			<td>{{ line.purchase_price }} {{ line.purchase_price_currency}} </td>
			<td>{{ line.total_price }} {{ line.purchase_price_currency}} </td>
		</tr>

  {% endfor %}
  		</div>
    </tbody>
</table>

{% endblock %}

[SchrodingersGat]

Seems to work fine on my end:

I had to tweak your example to get it to work:

{% extends "report/inventree_po_report.html" %}

{% load i18n %}
{% load inventree_extras %}
{% load report %}
{% load barcode %}

{% block page_content %}

<h3 style="text-transform:uppercase;">{% trans "Items" %}</h3>
<table class='table table-striped table-condensed'>
    <thead>
        <tr>
		<th>Description</th>
		<th>QTEE/QTY</th>
		<th>Prix/Price</th>
		<th>Total</th>
            
        </tr>
    </thead>
    <tbody>
        {% for line in lines.all %}
        <tr>
            <td>
                <div class='thumb-container'>
                    <img src='{% part_image line.part.part %}' class='part-thumb'>
                </div>
                <div class='part-text'>
                    {{ line.part.part.full_name }}
                
            </td>
            <td>{% decimal line.quantity %} PMP</td>
			<td>{{ line.purchase_price }} {{ line.purchase_price_currency}} </td>
			<td>{{ line.total_price }} {{ line.purchase_price_currency}} </td>
		</tr>

  {% endfor %}
  		</div>
    </tbody>
</table>

{% endblock %}

[anonkwe]

it ain't working for you as well, i wanna display this in the po:[image: image.png]

…

On Fri, Mar 3, 2023 at 12:25 AM Oliver ***@***.***> wrote: Seems to work fine on my end: [image: image] <https://user-images.githubusercontent.com/10080325/222638385-087f7dae-59cd-4ba0-b2bc-070e83502d9f.png> I had to tweak your example to get it to work: {% extends "report/inventree_po_report.html" %} {% load i18n %} {% load inventree_extras %} {% load report %} {% load barcode %} {% block page_content %} <h3 style="text-transform:uppercase;">{% trans "Items" %}</h3><table class='table table-striped table-condensed'> <thead> <tr> <th>Description</th> <th>QTEE/QTY</th> <th>Prix/Price</th> <th>Total</th> </tr> </thead> <tbody> {% for line in lines.all %} <tr> <td> <div class='thumb-container'> <img src='{% part_image line.part.part %}' class='part-thumb'> </div> <div class='part-text'> {{ line.part.part.full_name }} </td> <td>{% decimal line.quantity %} PMP</td> <td>{{ line.purchase_price }} {{ line.purchase_price_currency}} </td> <td>{{ line.total_price }} {{ line.purchase_price_currency}} </td> </tr> {% endfor %} </div> </tbody></table> {% endblock %} — Reply to this email directly, view it on GitHub <#4439 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOXZLLWWTQR3GAFVZMBQ7LLW2F6DXANCNFSM6AAAAAAVN5EYJU> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[SchrodingersGat]

That's strange, it should be working based on that. Can you show what happens when you use the inventree_po_report_base.html template?

[SchrodingersGat]

Oh and it will only work if you have updated your installation to the latest master version, where I've added the total_line_price method

[anonkwe]

i'm quite new to this, how do i make sure i update to the latest version? if i do invoke update while on my env, it says master has no commmit or something like that?

[anonkwe]

{% extends "report/inventree_report_base.html" %}

{% load i18n %}
{% load report %}
{% load barcode %}
{% load inventree_extras %}

{% block page_margin %}
margin: 2cm;
margin-top: 4cm;
{% endblock %}

{% block bottom_left %}
content: "v{{report_revision}} - {{ date.isoformat }}";
{% endblock %}

{% block bottom_center %}
content: "{% inventree_version shortstring=True %}";
{% endblock %}

{% block style %}

.header-right {
text-align: right;
float: right;
}

.logo {
height: 20mm;
vertical-align: middle;
}

.thumb-container {
width: 32px;
display: inline;
}

.part-thumb {
max-width: 32px;
max-height: 32px;
display: inline;
}

.part-text {
display: inline;
}

table {
border: 1px solid #eee;
border-radius: 3px;
border-collapse: collapse;
width: 100%;
font-size: 80%;
}

table td {
border: 1px solid #eee;
}

table td.shrink {
white-space: nowrap
}

table td.expand {
width: 99%
}

{% endblock %}

{% block header_content %}

<img class='logo' src='{% company_image supplier %}' alt="{{ supplier }}" width='150'>

<div class='header-right'>
    <h3>{% trans "Purchase Order" %} {{ prefix }}{{ reference }}</h3>
    {% if supplier %}{{ supplier.name }}{% else %}{% trans "Supplier was deleted" %}{% endif %}
</div>

{% endblock %}

{% block page_content %}

{% trans "Line Items" %}

{% for line in lines.all %} {% endfor %}

    {% if extra_lines %}
    <tr><th colspan='6'>{% trans "Extra Line Items" %}</th></tr>
    {% for line in extra_lines.all %}
    <tr>
        <td><!-- No part --></td>
        <td>{{ line.reference }}</td>
        <td>{% decimal line.quantity %}</td>
        <td>{% include "price_data.html" with price=line.price %}</td>
        <td>{% include "price_data.html" with price=line.total_line_price %}</td>
        <td>{{ line.notes }}</td>
    </tr>
    {% endfor %}
    {% endif %}

    <tr>
        <td></td>
        <td></td>
        <td></td>
        <th>{% trans "Total" %}</th>
        <td>{% include "price_data.html" with price=order.total_price %}</td>
        <td></td>
    </tr>

</tbody>

{% trans "Part" %}	{% trans "Reference" %}	{% trans "Quantity" %}	{% trans "Unit Price" %}	{% trans "Total Price" %}	{% trans "Note" %}
{{ line.part.part.full_name }}	{{ line.reference }}	{% decimal line.quantity %}	{% include "price_data.html" with price=line.purchase_price %}	{% include "price_data.html" with price=line.total_line_price %}	{{ line.notes }}

{% endblock %}

[anonkwe]

its okay it's working, i did not pull the master branch the proper way the first time, now everything's fine

[anonkwe]

is there a way to multiply the unit price by the quantity directly on the report's html file

…

On Fri, Mar 3, 2023 at 1:52 AM Oliver ***@***.***> wrote: Do you mean that the "total price" is not rendering correctly? The PurchaseOrderLineItem model does not have a method called *total_price* which is why it is not showing anything. We would need to add that functionality to allow rendering here — Reply to this email directly, view it on GitHub <#4439 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOXZLLR7GHYQ7YEASIIH3JTW2GIJFANCNFSM6AAAAAAVN5EYJU> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[SchrodingersGat]

Not currently - although I can see that this would be a useful addition!

See incoming changes in #4443

[anonkwe]

is there a way to change decimals only on PO reports, if I put pricing decilmals to 2, it messes up all the table views of the site, decimals should be 2 on the report and 4 on the whole site. right now reports are taking in account 4 decimals:

[SchrodingersGat]

@anonkwe check out new PR - #4469 - I've exposed the new method render_currency which will allow you to do this.

[SchrodingersGat]

https://docs.inventree.org/en/latest/report/helpers/#rendering-currency