Printing data from other linked doc Using jinja

1

Hi everyone,

I am currently working on a task where I need to incorporate transporter details from the delivery note into the sales invoice. While I have made an attempt using the code below, I’ve encountered an issue where the data is not being fetched from the linked delivery note.

{% if frappe.get_doc('Delivery Note', doc.delivery_note).transporter %}
    <p>{{ frappe.get_doc('Delivery Note', doc.delivery_note).transporter }}</p>
{% endif %}

{% if frappe.get_doc('Delivery Note', doc.delivery_note).driver_name %}
    <p>Driver Name: {{ frappe.get_doc('Delivery Note', doc.delivery_note).driver_name }}</p>
{% endif %}

{% if frappe.get_doc('Delivery Note', doc.delivery_note).transporter_drive_no %}
    <p>Drive No: {{ frappe.get_doc('Delivery Note', doc.delivery_note).transporter_drive_no }}</p>
{% endif %}

{% if frappe.get_doc('Delivery Note', doc.delivery_note).vehicle_no %}
    <p>Vehicle No: {{ frappe.get_doc('Delivery Note', doc.delivery_note).vehicle_no }}</p>
{% endif %}

{% if frappe.get_doc('Delivery Note', doc.delivery_note).lr_no  %}
    <p>Billity No: {{ frappe.get_doc('Delivery Note', doc.delivery_note).lr_no  }}</p>
{% endif %}

{% if frappe.get_doc('Delivery Note', doc.delivery_note).lr_date  %}
    <p>Date: {{ frappe.get_doc('Delivery Note', doc.delivery_note).lr_date  }}</p>
{% endif %}

I would greatly appreciate any guidance or suggestions on how to rectify this issue and ensure that the transporter details are accurately retrieved from the associated delivery note.

2

Hi,

Alternatively,

{% set linked_delivery_note = doc.delivery_note %}
{% if linked_delivery_note %}
{% set delivery_note = frappe.get_doc('Delivery Note', linked_delivery_note) %}

Then,

Transporter: {{ delivery_note.transporter }}
.
.
.
{% endif %}
3

Thank you @Yamen_Zakhour for your prompt response.

Unfortunately, the solution provided above does not successfully retrieve any data for the linked delivery note.