How to get payment voucher custom get purchase invoice in_words data

ERPNext
1

How to get payment voucher custom get purchase invoice in_words data

2

i added it but when check it shows no element. could you please help me on that

{{ frappe.db.get_value(“Purchase Invoice”, {“in_words”: row.in_words}, ‘in_words’) }}

3

row.in_words or doc.in_words ?

4

Hi @webshow,

Example:

{{ frappe.db.get_value("Purchase Invoice", doc.reference_name, 'in_words') }}

Here, please set the purchase invoice field name in reference_name according to.

Thank You!

5

thanks very much @NCP
The value obtained by the field information is not displayed correctly, the amount of the last document displayed. Does not show the correct value for the current document

6

Customize the print format according to.

7

Thank You! @NCP

Print Amount in Words - ERPNext / Accounting - Frappe Forum

Amount in Words - Frappe Framework / Custom Script - Frappe Forum