ERPNEXT - Purchase Reconciliation Tool - Email Template Customization

[Navya_shree]

Hi,

Requirement:
I want to utilize the mail feature of the Purchase Reconciliation tool to send detailed reports on mismatches and missing invoices.

Sample API: (values edited)

“reconciliation_data”: "[{"supplier_name": "Panchaakshari Distributors (Snacks)", "supplier_gstin": "29GRZPS4736K1ZF", "purchase_company_gstin": "29A…1Z4", "inward_supply_company_gstin": "29…1Z4", "bill_no": "SP004…064", "bill_date": "2024-05-16", "match_status": "Exact Match", "purchase_invoice_name": "J…2", "inward_supply_name": "GST-I…….565", "taxable_value_difference": 0.0, "tax_difference": 0.0, "differences": "", "action": "Accept My Values", "classification": "B2B", "purchase_doctype": "Purchase Invoice"}, { ………………}.……….]

In Email Template

I tried with

Result :

{{ supplier_name }}-{{ supplier_gstin }} working

{{ bill_no }} is not working

Please guide

[Smit_Vora]

With supplier row (in supplier view), invoice level information is not available.

This is because there could be more than one invoice associated for a supplier. So, you will not be able to add information related to bill number in email.