I need not to show "None" when if empty value in Part number field in SI

[sathya_raj]

Hi All,
In my sales invoice, i had fetched part number from item transaction through this code {{ frappe.db.get_value(“Item”, doc.item, “custom_part_number”) }} my problem is if the part number field is empty it is showing none in sales invoice print i need not to show none

Thanks in Advance

[NCP]

@sathya_raj

doc.item

Please use the item_code instead of the item

Example:

{% for row in doc.items %}
    {{ frappe.db.get_value("Item", row.item_code, "custom_part_number") or ''}}
{% endfor %}

Also, check the field the field name of the part number

[sathya_raj]

please guide how i keep your code inside this html

Thanks in Advance

[NCP]

@NCP

{{ frappe.db.get_value("Item", row.item_code, "custom_part_number") or ''}}

Paste the above line in center part-number

because you used a doc instead of the row.

same for, item_code instead of the item

[sathya_raj]

@NCP

{{ frappe.db.get_value("Item", row.item_code, "custom_part_number") or ''}}

Thank you so much