How do I get the correct currency to display in approval notifications?

[chrisdamico]

The issue is the emails are not showing the correct currency.   How do I update the notification and script to ensure the correct currency is displayed for the approver?

The request.itil.approve.role email template has the following:

Short Description: ${sysapproval.short_description}

Priority: ${sysapproval.priority}

Requested For: ${sysapproval.requested_for}

Requested By: ${sysapproval.opened_by}

Total Price: ${sysapproval.price}

${mail_script:request.itil.approve.role_script_1}

Comments:

${sysapproval.description}

---

${mailto:mailto.approval} via e-mail

---

${mailto:mailto.rejection} via e-mail

---

Click here to view Approval Request in ServiceNow: ${URI}

The mail script contains the following code:

template.print("Summary of requested items:\n");  
var item = new GlideRecord("sc_req_item");
item.addQuery("request", current.sysapproval);
item.query();

while(item.next()) {
     
  template.print(item.number + ":   " + item.quantity + " X " + item.cat_item.getDisplayValue() + " at " + item.cat_item.price.getDisplayValue() + " each \n");
 
    template.print("       Options:\n");
  var keys = new Array();
  var set = new GlideappVariablePoolQuestionSet();
  set.setRequestID(item.sys_id);
  set.load();
  var vs = set.getFlatQuestions();
  for (var i=0; i < vs.size(); i++) {
    if(vs.get(i).getLabel() != '') {
      template.space(4);
      template.print('         ' +   vs.get(i).getLabel() + " = " + vs.get(i).getDisplayValue() + "\n");  
    }
  }
}

Thanks!

[Abhinay Erra]

Use "getCurrencyDisplayValue()"

Total Price: ${sysapproval.price.getCurrencyDisplayValue()}

[chrisdamico]

I added this to the email template.

Total Price: ${sysapproval.price.getCurrencyDisplayValue()}

It comes back blank when the notification is sent out.

Thanks for your help.

[jayachandran]

Does price contains some value? Sure it is not blank ?

[Abhinay Erra]

The problem here is, you cannot use the glide methods in the message section, you need to add it in mail scripts and reference it in the message section.