How to use a custom field from item doctype to sales invoice print format?

ERPNext
#1

I’ve created a custom text editor field named as item_specification inside item doctype. Now I want to use this inside sales invoice print format. But somehow I’m not getting the item_specification inside the print format.

I’m fetching the details by frappe.db.get_value(“Item”, doc.item, "item_specification) or “” }} but I’m getting None.

#2

Hi @Rahul_Singh,

Please apply it.

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

Then reload and check it.

Thank You!

1 Like
#3

Hi @NCP ,
This solution worked form me.
Thank you so much for your time.