I currently develop on custom print format for Payment Entry. As far as I know, Payment Entry somehow is connected with Sales Invoice. So let say, in the Payment Entry, I would like to have the party/customer address which only can be retrieved from the Sales Invoice. How can I fetch the data ? Would you mind to explain on this?
Or any other possible way could be really helpful too !
@Maheshwari_Bhavesh, Is it if I want to use “frappe” scripting, I must install it first ? Because at this moment, I don’t even have frappe in my computer. Or should I put anything before that scripting in order to open the database ?
You’ll have to put the frappe.db.get_value() inside curly braces as well:
{{ frappe.db.get_value("Sales Invoice", doc.sales_invoice, "address_display") }}
where doc.sales_invoice should be the field that links to the Sales Invoice.