Hey Everyone! It's urgent. I am currently working ...
# generals
Salman Afzal
06/23/2023, 4:27 PMHey Everyone! It's urgent. I am currently working to generate multicurrency statement template for email for customers. First I was having an issue how we can change the email template as they want statement as HTML template not as pdf. I resolve issue with the help of these two articles https://www.linkedin.com/pulse/how-email-netsuite-statement-when-wrong-form-being-selected-schmitz/?trackingId=fVvBwinqQcy9QmjimoF8mQ%3D%3D and https://www.linkedin.com/pulse/how-make-netsuite-email-template-after-making-advanced-caleb-schmitz/?trackingId=fVvBwinqQcy9QmjimoF8mQ%3D%3D it will help if anyone having the same issue. But now issue is my template is working perfectly for my role that is Admisintrator but not for some other people with same role in Sanbox. Other than that when I created same thing in Production, it is not working. Has anyone have idea what is the problem. I need help with my HTML template. I am sharing my code here.
```<?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">
<pdfset><#if statements?has_content><#list statements as statement>
<pdf>
<head>
<link name="NotoSans" type="font" subtype="truetype" src="${nsfont.NotoSans_Regular}" src-bold="${nsfont.NotoSans_Bold}" src-italic="${nsfont.NotoSans_Italic}" src-bolditalic="${nsfont.NotoSans_BoldItalic}" bytes="2" />
<#if .locale == "zh_CN">
<link name="NotoSansCJKsc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKsc_Regular}" src-bold="${nsfont.NotoSansCJKsc_Bold}" bytes="2" />
<#elseif .locale == "zh_TW">
<link name="NotoSansCJKtc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKtc_Regular}" src-bold="${nsfont.NotoSansCJKtc_Bold}" bytes="2" />
<#elseif .locale == "ja_JP">
<link name="NotoSansCJKjp" type="font" subtype="opentype" src="${nsfont.NotoSansCJKjp_Regular}" src-bold="${nsfont.NotoSansCJKjp_Bold}" bytes="2" />
<#elseif .locale == "ko_KR">
<link name="NotoSansCJKkr" type="font" subtype="opentype" src="${nsfont.NotoSansCJKkr_Regular}" src-bold="${nsfont.NotoSansCJKkr_Bold}" bytes="2" />
<#elseif .locale == "th_TH">
<link name="NotoSansThai" type="font" subtype="opentype" src="${nsfont.NotoSansThai_Regular}" src-bold="${nsfont.NotoSansThai_Bold}" bytes="2" />
</#if>
<macrolist>
<macro id="nlheader">
<table class="header" style="width: 100%; font-family: NotoSans, sans-serif;"><tr>
<td rowspan="6"><img src="${subsidiary.logo@url}" style="width: 40%; height: 40%;" /><br /><br /><span style="font-size:12px;">${subsidiary.mainaddress_text}<br />${subsidiary.federalidnumber}</span></td>
<td></td><td></td>
<td align="left"><span class="title">${record@title}</span><br /><br />
<strong><span style="font-size:12px;">Date: ${statement.trandate} </span></strong>
</td>
</tr>
<tr>
<td></td><td></td>
<td align="left">
<span style="font-size:12px;"><strong>Amount Due:</strong> ${statement.amountDue} </span><br />
<span style="font-size:12px;"><strong>Account #:</strong> ${customer.custentity6} </span><br />
<span style="font-size:12px;"><strong>Currency:</strong> ${customer.currency} </span><br />
<span style="font-size:12px;"><strong>Subsidiary:</strong> ${subsidiary.name} </span><br />
</td>
</tr>
</table>
</macro>
</macrolist>
<style type="text/css">* {
<#if .locale == "zh_CN">
font-family: NotoSans, NotoSansCJKsc, sans-serif;
<#elseif .locale == "zh_TW">
font-family: NotoSans, NotoSansCJKtc, sans-serif;
<#elseif .locale == "ja_JP">
font-family: NotoSans, NotoSansCJKjp, sans-serif;
<#elseif .locale == "ko_KR">
font-family: NotoSans, NotoSansCJKkr, sans-serif;
<#elseif .locale == "th_TH">
font-family: NotoSans, NotoSansThai, sans-serif;
#else
font-family: NotoSans, sans-serif;
</#if>
}
table {
font-size: 9pt;
table-layout: fixed;
}
th {
font-weight: bold;
font-size: 8pt;
vertical-align: middle;
padding: 5px 6px 3px;
background-color: #e3e3e3;
color: #333333;
}
td {
padding: 4px 6px;
}
td p { align:left }
b {
font-weight: bold;
color: #333333;
}
table.header td {
padding: 0;
font-size: 10pt;
}
table.footer td {
padding: 0;
font-size: 8pt;
}
table.itemtable th {
padding-bottom: 10px;
padding-top: 10px;
}
table.body td {
padding-top: 2px;
}
td.addressheader {
font-weight: bold;
font-size: 8pt;
padding-top: 6px;
padding-bottom: 2px;
}
td.address {
padding-top: 0;
}
span.title {
font-size: 27pt;
}
span.number {
font-size: 16pt;
}
div.remittanceSlip {
width: 100%;
/* To ensure minimal height of remittance slip */
height: 200pt;
page-break-inside: avoid;
page-break-after: avoid;
}
hr {
border-top: 1px dashed #d3d3d3;
width: 100%;
color: #ffffff;
background-color: #ffffff;
height: 1px;
}
</style>
</head>
<body header="nlheader" header-height="15%" footer="nlfooter" footer-height="20pt" padding="0.5in 0.5in 0.5in 0.5in" size="Letter">
<table style="width: 100%; font-family: NotoSans, sans-serif;"><tr>
<td class="addressheader" colspan="4" style="width: 438px;">
</td>
<td class="addressheader" align="right" style="width: 343px;"><span style="font-size:12px;"><span style="background-color:#ffffff;">${subsidiary.custrecord12?replace("\\", "<br/>")}</span></span></td>
</tr>
<tr>
<td class="address" colspan="4" style="width: 438px;"><br /><span style="font-size:12px;">${customer.defaultaddress}<br />${customer.vatregnumber}</span></td>
<td class="address" style="width: 343px;"> </td>
</tr></table>
<table class="body" style="width: 100%; font-family: NotoSans, sans-serif;"><tr>
<th align="right">${statement.amountDue@label}</th>
</tr>
<tr>
<td align="right">${statement.amountDue}&…
Slack Conversation