Custom Email Alert for PO

[ermalc]

Hi

I need some help with creating the below email alert. I can create email alerts fine, but not with the fields that i need.

Dear PO Approver or (name)

User or Employee (name) has submitted a PO (po number and hyperlink) for the amount of (total amount of the PO)

Please login to approve or reject (hyperlink to the PO or login page)

Many thanks in advance

[rmehta]

@ermalc share what you have tried.

[ermalc]

PO Approval Request

Transaction: {{ doc.name }} . Created by {{ doc.from_employee }} , by {{ doc.raised_by }}

This brings up employee code and employee address, any chance to pull up the Full Name.?

PO Total: {{ doc.grand_total }}

This does not display the currency value in front, £, $,, etc... how to get that?

Please Login to Approve or Reject.

No clue what the correct field for the hyperlink for this ?

Also, this email alert is created so when a user or member of staff creates a PO, or draft PO and it is awaiting authorization from the authorization approver or manager.

What would the “Email By Document Field” be for the authorization approver or manager to be notified , or the condition? Another topic for this on here

Authorized Approver or Approvers of a PO to get email alert

Hi You can use the email alert feature for this. Please refer to the link below for further info. https://frappe.github.io/erpnext/user/manual/en/setting-up/email/email-alerts.html You can create an email alert for Purchase Order when it is saved and choose to send the mail to the approver. Hope it helps

Please help if you can

Thank you

Thank you
Ermal

[rmehta]

@ermalc

PO Total: {{ doc.grand_total }}

This does not display the currency value in front, £, $, etc… how to get that?

Use {{ doc.get_formatted("grand_total") }}

@ermalc

Please Login to Approve or Reject.

Your /login url?

@ermalc

This brings up employee code and employee address, any chance to pull up the Full Name.?

{{ frappe.db.get_value("Employee", doc.employee", "full_name") }}

(check the fieldname in employee)

[ermalc]

@rmehta That is amazing, thank you so much for this, great help!!

I have one last request to make this work and would appreciate your time to have a look at this. It is the link to the other post about the authorized approver receiving an email once a user raises a PO. How to do this or what way is there to get some sort of notification email to the approver? Any help would be appreciated.

Many Thanks