Need to Fetch data in Print for Submitted Doctype

[Mohamed2335]

Dear Community,

Recently am updated building name in system but i submit sales invoice before uploaded these data.
but i need to fetch these data in print even i tried code it not work can you please help me to fetch the data in print

Doctype is Property, Field name is custom_building_name

Building Name:{{ frappe.db.get_value("Property", doc.property,"custom_building_name")) }}

by using this code in print it shows as None bcs of not available in sales invoice.

so i need directly fetch from property doctype.

[NCP]

Reference:

Fetch data from item to sales invoice print format

Hi @yara, Please apply/try it. {{ frappe.db.get_value("Item",{"item_code": row.item_code},'package') }} Then reload and check it. Thank You!

Custom Print Fromat - frappe.db.get_value

Hi @lyf, Please check your field name. Above code 100% worked. {{ frappe.db.get_value("Employee", doc.employee, 'passport_number') }} // OR {{ frappe.db.get_value("Employee", {"name": doc.employee}, 'passport_number') }} Thank You!

ERPNext Costumer ID from naming series are wrong print format

Hi @kevco97, Please apply it. {{ frappe.db.get_value("Customer", doc.customer, 'name') }} Then reload and check it. Thank You!

Need To Fetch Designation in Quotation Print Format

Hi @Mohamed2335, If the user link with an employee then please apply it. {% if doc.custom_quotation_created_by %} {% set user_id = frappe.db.get_value("User", doc.custom_quotation_created_by, 'name') %} {% if user_id %} {% set designation = frappe.db.get_value("Employee", {"user_id": user_id}, 'designation') %} {% if designation %} {{ designation }} {% endif %} {% endif %} {% endif %}

[Mohamed2335]

thanks for the response, but here the sales invoice is already submitted. so it not fetch tha building name in print even it only take none bcs of not available in sales invoice.

[Void_Moon]

If the document is already submitted and you want to make any changes to it, why not just cancel and amend it?

If you don’t want to cancel but just take a print, why not just give the property value statically just for this print alone? And change it back to dynamic jinja once you’ve taken your print?

[Mohamed2335]

they are 50 invoices now only these data added hence i tried via print code.