Need to Fetch data in Print for Submitted 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 %}