Sales order QR on report

[leejoow]

I'm creating a report which is a package slip on which I want the QR code to be able to use the app to open the SO. In the web interface I can open the QR code and scan it.

However, I cannot find the correct information in the report context to generate it: as fas as I can see there is no qr_data like field and the primary key is also not available to construct the string myself.

Am I overlooking something?

[SchrodingersGat]

Try using barcode instead of qr_data on the sales order report

[leejoow]

Thanks for your suggestion, however it does not see to work.
I currently have the following source for the report:

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

{% block header_content %}

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

    <div class='header-right'>
        <h3>{% trans "Verkoop" %} {{ prefix }}{{ reference }}</h3>
        {{ customer.name }} <br />
        {{ customer.primary_address.line1 }} <br />
        {{ customer.primary_address.postal_code }} <br />
        {{ customer.primary_address.postal_city }} <br />
        {{ customer.primary_address.country }} <br />
        {{ customer.email }}
    </div>

{% endblock header_content %}

{% block page_content %}

<style>
    body {
        font-size: 125%;
    }

    table {
        font-size: 1em;
    }
</style>

<h3>{% trans "Bestelregels" %}</h3>

<table class='table table-striped table-condensed'>
    <thead>
        <tr>
            <th>{% trans "Part" %}</th>
            <th>{% trans "Quantity" %}</th>
            <th>{% trans "Note" %}</th>
        </tr>
    </thead>
    <tbody>
        {% for line in lines.all %}
        <tr>
            <td>{{ line.part.full_name }}</td>
            <td>{% decimal line.quantity %}</td>
            <td>{{ line.notes }}</td>
        </tr>
        {% endfor %}
    </tbody>
</table>

<img class='qr' src='{% qrcode barcode %}'>

{% endblock page_content %}

The QR is at the end of the report. Unfortunately, this report gives an "Error rendering template"

[leejoow]

don't know whether @SchrodingersGat gets updates, so a tag just in case 😄

[SchrodingersGat]

Use order.barcode - not barcode directly.

e.g.

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

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

{% block header_content %}

    <img class='logo' src='{% qrcode order.barcode %}' alt="{{ customer }}" width='150'>

    <div class='header-right'>
        <h3>{% trans "Sales Order" %} {{ prefix }}{{ reference }}</h3>
        {{ customer.name }}
    </div>

{% endblock header_content %}

leads to:

[leejoow]

Thanks, this works. Could I find this in the documentation? I cannot find the description of the model mentioned at the attribute order:

[leejoow]

And last question, is there a way to intercept the generated HTML before the PDF is created to see what I'm rendering?

Edit: found it under admin settings 😄

[SchrodingersGat]

Regarding discoverability of available variables - see #12449 which provides much better introspection of available fields and attributes