How to create and use custom email templates using standard NetSuite Scriptable Email Template for leave request notifications.

Overview

When using leave management, emails are sent on change of the leave request status (if the email suppress option has not been checked). The following table lists the status change and the emails sent.

Status	Recipient	Action
Requested	Leave Request Approver	Email Informs Approver that a new leave request has been made and is pending their approval
Approved	Employee Requesting Leave	Email Informs Employee that their leave request has been approved
Cancelled	Employee Requesting Leave	Email Informs Employee that their leave request has been cancelled
Declined	Employee Requesting Leave	Email Informs Employee that their leave request has been declined.

By default the system sends a standard subject and body, but this can be overridden using standard NetSuite email templates. Typical use cases for needing to modify the template include:

Using a Single Sign On Solution and want to reference a different place to login.
Adding additional employee or leave request fields to the emails to meet specific business requirement

To start using custom email templates you need to complete the following steps which are detailed below

Create Custom Email Templates
Update the Leave Configuration to use the email templates

Creating Leave Request Email Template

Email templates for use with Leave Request management are created using standard NetSuite Templates. A template must be associated with a record type that it will be merged with; then within the subject and body replacement fields can be specified (for more information on the templating markup search for "Working with Advanced Templates" in NetSuite help.

To create templates follow the steps below:

Navigate to Documents > Template > Email Templates > New
Set Name as you want the template name to appear for example Leave Request Approved Template"
Set Record Type to "Custom Record"
Set Subject for example "Leave Request Approved"
Set Body with message you would like employees to see.

Example Templates

The following example templates re-create the generic messages using the NetSuite Templating Markup.

Which Field

To help creating custom templates you can use the field type / insert field drop down menus above the message body. Simply select either Employee or Leave Request in the field type drop down and this will refresh the insert field to include fields from the record which are inserted when selected.

Subject: Leave Request ${customrecord.name}

Approval Request Email Template

Dear ${employee.firstName},<br />
<br />
A leave request has been entered and is pending your approval the details are as follows:<br />
<br />
Employee: ${customrecord.custrecord_pr_lr_employee}<br />
Period: ${customrecord.custrecord_pr_lr_start} - ${customrecord.custrecord_pr_lr_end}<br />
Leave Type: ${customrecord.custrecord_pr_lr_leave_type}<br />
<br />
To approve or decline this request, please log into NetSuite<br />
<br />

Subject: Leave Request ${customrecord.name} ${customrecord.custrecord_pr_lr_status}

Approved / Cancelled / Declined Email Template

Dear ${employee.firstName},<br />
<br />
Your request for ${customrecord.custrecord_pr_lr_leave_type} for the period ${customrecord.custrecord_pr_lr_start} - ${customrecord.custrecord_pr_lr_end} has been ${customrecord.custrecord_pr_lr_status}.<br />

Configuring Leave Setup To Use Templates

To configure leave to use the custom email templates, populate the template fields in the setup wizard by following these steps:

Navigate to Payroll Administration > Payroll Setup > Leave Wizard.
Go to Step 2: Basic and select your custom templates for the actions you wish to override the default email.
Proceed through each step and complete the Setup Assistant.

Sensitive Data

Please be aware that the fields you add to the template will appear in the messages tab when sent so avoid sensitive data that you don't want other employees to see.