Hey Everyone! It's urgent. I am currently working ...
# advancedpdf
s
Hey 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.
Copy code
<?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}&nbsp;&nbsp;</span></strong>        
        </td>
        </tr>
        <tr>
        <td></td><td></td>
        <td align="left">
          <span style="font-size:12px;"><strong>Amount Due:</strong> ${statement.amountDue}&nbsp;&nbsp;</span><br />
          <span style="font-size:12px;"><strong>Account #:</strong> ${customer.custentity6}&nbsp;&nbsp;</span><br />
          <span style="font-size:12px;"><strong>Currency:</strong> ${customer.currency}&nbsp;&nbsp;</span><br />
          <span style="font-size:12px;"><strong>Subsidiary:</strong> ${subsidiary.name}&nbsp;&nbsp;</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;">&nbsp;</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}</td>
        </tr></table>
    <#if statement.lines?has_content>
    
    <table class="itemtable" style="width: 100%; font-family: NotoSans, sans-serif; margin-top: 10px;"><!-- start items --><#list statement.lines as line><#if line_index==0>
    <thead>
        <tr>
        <th colspan="3">${line.datecol@label}</th>
        <th colspan="12">${line.description@label}</th>
        <th align="right" colspan="3">${line.charge@label}</th>
        <th align="right" colspan="4">${line.payment@label}</th>
        <th align="right" colspan="4">${line.balance@label}</th>
        </tr>
    </thead>
    </#if><tr>
        <td colspan="3">${line.datecol}</td>
        <td colspan="12">${line.description}</td>
        <td align="right" colspan="3">${line.charge}</td>
        <td align="right" colspan="4">${line.payment}</td>
        <td align="right" colspan="4">${line.balance}</td>
        </tr>
        </#list><!-- end items --></table>
    
    <table class="aging" style="width: 100%; font-family: NotoSans, sans-serif; margin-top: 10px;"><tr>
        <th>${statement.aging1@label}</th>
        <th>${statement.aging2@label}</th>
        <th>${statement.aging3@label}</th>
        <th>${statement.aging4@label}</th>
        <th>${statement.aging5@label}</th>
        <th>${statement.agingbal@label}</th>
        </tr>
        <tr>
        <td style="text-align: center">${statement.aging1}</td>
        <td style="text-align: center">${statement.aging2}</td>
        <td style="text-align: center">${statement.aging3}</td>
        <td style="text-align: center">${statement.aging4}</td>
        <td style="text-align: center">${statement.aging5}</td>
        <td style="text-align: center">${statement.agingbal}</td>
        </tr></table>
    </#if><#if preferences.RETURNFORM && remittanceSlip??>
    
    <hr />
    <div class="remittanceSlip">
    <table style="width: 100%; font-family: NotoSans, sans-serif; margin-top: 10px;"><tr>
        <td><span style="font-size:12px;">${subsidiary.legalname}</span></td>
        <td align="right"><span class="number">${remittanceSlip@title}</span></td>
        </tr></table>
    
    <table style="width: 100%; font-family: NotoSans, sans-serif; margin-top: 10px;"><tr>
        <th><span style="font-size:12px;">${remittanceSlip.customername@label}</span></th>
        <th><span style="font-size:12px;">${statement.trandate@label}</span></th>
        <th><span style="font-size:12px;">${statement.amountDue@label}</span></th>
        <th><span style="font-size:12px;">${remittanceSlip.amountPaid@label}</span></th>
        </tr>
        <tr>
        <td><span style="font-size:12px;">${customer.defaultaddress}</span></td>
        <td><span style="font-size:12px;">${statement.trandate}</span></td>
        <td><span style="font-size:12px;">${statement.amountDue}</span></td>
        <td>&nbsp;</td>
        </tr>
      </table>
    
    </#if></body>
    <footer>
    <table class="footer" style="width: 100%; font-family: NotoSans, sans-serif;"><tr>
        <tr><td><br /><br /><span style="font-size:12px;">Please contact  with any invoice or statement related questions at  or .</span></td></tr>
        <tr><td><span style="font-size:12px;"><br />${subsidiary.custrecord_ms_bankaddress@label}<br />${subsidiary.custrecord_ms_bankaddress}</span></td></tr>
        <tr><td><span style="font-size:12px;"><br />${subsidiary.custrecord_ms_usbanktransfer@label}<br />${subsidiary.custrecord_ms_usbanktransfer}</span></td></tr>
        <tr><td><span style="font-size:12px;"><br />${subsidiary.custrecord_ms_intltransfer@label}<br />${subsidiary.custrecord_ms_intltransfer}</span></td></tr>
        </table>
    </footer>
    </pdf></#list><#else><pdf><head></head><body>
        

          </body>
       
    </pdf></#if></pdfset>