Check Template Code Is Very Different || Bill Payment check template
Mon Sep 04 2023 07:55:46 GMT+0000 (Coordinated Universal Time)
Saved by @mdfaizi ##check ##template
<?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">
<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>
</head>
<body padding="0.5in 0.5in 0.5in 0.5in" size="Letter">
<#list records as check>
<#assign use=check.custbody3?eval>
<div style="position: center; font-family: Helvetica, sans-serif; height: 750pt; width: 612pt; page-break-before: avoid; font-size: 8pt;">
<table align="center" border="0.5" cellspacing="0" style="height: 200px ; width: 500px;border-top: none;border-left: none;border-right: none;"><#list use?keys as item><#if item_index==0>
<thead style="border">
<tr>
<th style="border-bottom: 0.5px solid black;border-top: none;border-left: none;">GCI ID/Ref#</th>
<th style="border-bottom: 0.5px solid black;">Begin Date</th>
<th style="border-bottom: 0.5px solid black;">End Date</th>
<th style="border-bottom: 0.5px solid black;">Hours/Inv Amount</th>
<th style="border-bottom: 0.5px solid black;">Amount paid</th>
<th style="border-bottom: 0.5px solid black;">Disc Take</th>
<th style="border-bottom: 0.5px solid black;border-right: none;">Net check Amt</th>
</tr>
</thead>
</#if>
<tr>
<td style="border-left: 0.5px solid black;border-right: 0.5px solid black;">${use[item].billItemEmp?keep_before(" ")} ${use[item].billExpenseEmp?keep_before(" ")}</td>
<td style="border-right: 0.5px solid black;">${use[item].billStartDate}</td>
<td style="border-right: 0.5px solid black;">${use[item].billEndDate}</td>
<td style="border-right: 0.5px solid black;"><#if use[item].billItemQty ==0> <#else>${use[item].billItemQty}</#if><#if use[item].billExpenseAmt ==0><#else>${use[item].billExpenseAmt}</#if></td>
<td style="border-right: 0.5px solid black;">${use[item].originalAmountVal}</td>
<td style="border-right: 0.5px solid black;">${use[item].discTakenVal}</td>
<td style="border-right: 0.5px solid black;">${use[item].paymentAmountVal}</td>
</tr>
</#list><!-- end items --></table>
<br /><br />
<table align="center" border="0.5" cellspacing="0" style="height: 200px ; width: 500px;border-top: none;border-left: none;border-right: none;"><#list use?keys as item><#if item_index==0>
<thead style="border">
<tr>
<th style="border-bottom: 0.5px solid black;border-top: none;border-left: none;">GCI ID/Ref#</th>
<th style="border-bottom: 0.5px solid black;">Begin Date</th>
<th style="border-bottom: 0.5px solid black;">End Date</th>
<th style="border-bottom: 0.5px solid black;">Hours/Inv Amount</th>
<th style="border-bottom: 0.5px solid black;">Amount paid</th>
<th style="border-bottom: 0.5px solid black;">Disc Take</th>
<th style="border-bottom: 0.5px solid black;border-right: none;">Net check Amt</th>
</tr>
</thead>
</#if>
<tr>
<td style="border-left: 0.5px solid black;border-right: 0.5px solid black">${use[item].billItemEmp?keep_before(" ")} ${use[item].billExpenseEmp?keep_before(" ")}</td>
<td style="border-right: 0.5px solid black;">${use[item].billStartDate}</td>
<td style="border-right: 0.5px solid black;">${use[item].billEndDate}</td>
<td style="border-right: 0.5px solid black;"><#if use[item].billItemQty ==0> <#else>${use[item].billItemQty}</#if><#if use[item].billExpenseAmt ==0><#else>${use[item].billExpenseAmt}</#if></td>
<td style="border-right: 0.5px solid black;">${use[item].originalAmountVal}</td>
<td style="border-right: 0.5px solid black;">${use[item].discTakenVal}</td>
<td style="border-right: 0.5px solid black;">${use[item].paymentAmountVal}</td>
</tr>
</#list><!-- end items --></table>
<br /><br />
<table align="center" border="0" cellpadding="1" cellspacing="1" style="height:150px;width:500px;"><tr>
<td style="height: 227px;">
<table border="1" cellpadding="1" cellspacing="1" style="width:501.333px;"><tr>
<td style="height: 69px; width: 137px;"><img src="http://7315200-sb1.shop.netsuite.com/core/media/media.nl?id=1462451&c=7315200_SB1&h=HP_0sf6mRAhLL48xHKSyAAAwG4yLSErFwdbBo4WqoMTmrHBS" style="width: 115px; height: 52px;" /></td>
<td colspan="3" rowspan="1" style="height: 69px; width: 103px;"> <b>BANK OF AMERICA</b><br /> PISCATAWAY<br /> PISCATAWAY, NJ</td>
<td colspan="2" rowspan="1" style="height: 69px; width: 238px;"> </td>
</tr>
<tr>
<td style="height: 68px; width: 137px;"><br /> 110 Allen Road<br /> Basking Ridge, NJ 07920</td>
<td colspan="3" rowspan="1" style="height: 68px; width: 103px;"> </td>
<td style="height: 68px; width: 95px;">
<table border="0" cellpadding="1" cellspacing="1" style="height:5px;width:91.3333px;"><tr>
<td style="width: 84px; height: 17px;"> </td>
</tr></table>
<table align="right" border="1" cellpadding="1" cellspacing="1" style="width: 84.3333px;"><tr>
<td style="width: 77px;">Check Date<br />${check.trandate}</td>
</tr></table>
<table border="0" cellpadding="1" cellspacing="1" style="width: 90.3333px;"><tr>
<td style="width: 83px;"> </td>
</tr></table>
</td>
<td style="height: 68px; width: 132px;">
<table align="right" border="0" cellpadding="1" cellspacing="1" style="width: 85.3333px;"><tr>
<td style="width: 78px; height: 13px; text-align: left;"><span style="font-size:10px;">CHECK # ${check.tranid}</span></td>
</tr></table>
<table align="right" border="1" cellpadding="1" cellspacing="1" style="width: 88.3333px;"><tr>
<td style="width: 81px;">Check Amount<br />${check.total}</td>
</tr></table>
<table align="right" border="0" cellpadding="1" cellspacing="1" style="width:95px;"><tr>
<td style="width: 113px; height: 10px; text-align: right;"> <span style="font-size:8px;"> **Void after 90 days**</span></td>
</tr></table>
</td>
</tr>
<tr>
<td colspan="6" style="height: 23px; width: 494px;"><i>Amount in Words: ${check.totalwords}************************USD</i></td>
</tr>
<tr>
<td style="height: 20px; width: 148px;"><b> Pay to the Order of</b></td>
<td style="height: 20px; width: 148px;"> </td>
<td colspan="4" style="height: 20px; width: 343px;"> </td>
</tr>
<tr>
<td colspan="3" rowspan="1" style="height: 52px; text-align: right;">
<table align="right" border="0" cellpadding="1" cellspacing="1" style="width: 176.333px;"><tr>
<td style="height: 44px; width: 169px; text-align: center;"><span style="font-size:8px;"></span><span style="font-size:8px;">${check.payeeaddress_text}</span></td>
</tr></table>
</td>
<td rowspan="1" style="height: 52px; text-align: right;"> </td>
<td colspan="2" style="width: 247px; height: 52px;">
<table align="right" border="0" cellpadding="1" cellspacing="1" style="width:242px;"><tr>
<td style="width: 236px;"><b> Authorised Signature</b><br /> **Not Valid over 50,000 without two signatures**</td>
</tr></table>
</td>
</tr></table>
</td>
</tr></table>
<br /><br /><br /><br /><br /><!-- Additional sections or styling can be added here --></div>
</#list>
</body>
</pdf>
1.Bill Payment record also print checks , and to access bill payment record data there a different method which is mentioned in point 2 below. 2.In case of check the whole code should be in between <#list records as check> </#list>
https://7315200-sb2.app.netsuite.com/app/common/custom/advancedprint/pdftemplate.nl?id=127&nl=F&tt=Check&pt=TRANSACTION&source=T&savedsearchid=-1&rt=&e=T&sc=-90
Comments
@mdfaizi - Mon Sep 04 2023 07:56:18 GMT+0000 (Coordinated Universal Time)template is in Ascendion SB2 with name ASC Custom Voucher Check PDF/HTML Template