Ask A Guru

Honey Soe

Dear Gurus,

I just want to restrict account when we printing out of customer individual statement. Could you please help us for this case?

This is my source 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>
<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: 28pt;
}
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 padding="0.2in 0.2in 0.2in 0.2in" size="A4">
<table style="width: 100%;"><tr>
<td rowspan="2" style="width: 234px; height: 80px;"><img src="https://5132165.secure.netsuite.com/core/media/media.nl?id=918&amp;c=5132165&amp;h=DmNSORfjx3iUW-fpYez2U1BeoaAP3Y1Co7gZOemQlJEN5LAg" style="width: 114px; height: 106px;" /></td>
<td style="width: 406px; height: 49px;"><span style="font-size:18px;"><strong><span class="nameandaddress">${companyInformation.companyName}</span></strong></span></td>
<td rowspan="2" style="width: 274px; height: 49px;">${subsidiary.logo}</td>
</tr>
<tr>
<td style="width: 406px; height: 15px;"><span style="font-size:12px;"><span class="nameandaddress">${companyInformation.addressText}</span></span></td>
</tr></table><table style="width: 100%; margin-top: 10px;"><tr>
<td class="addressheader" colspan="2"><span style="font-size:14px;"><strong>${customer.companyname}</strong></span></td>
<td class="addressheader" style="text-align: right;"><span style="font-size:11px;">Statement Date : ${statement.trandate}</span></td>
</tr>
<tr>
<td class="addressheader" colspan="3"><span style="font-size:14px;">${statement.billaddress@label}</span></td>
</tr>
<tr>
<td class="address" colspan="3">${customer.defaultaddress}</td>
</tr></table><table class="body" style="width: 100%;"><tr>
<th align="right" colspan="2">Amount Remaining</th>
</tr>
<tr>
<td align="right" style="height: 18px;">AR Balance</td>
<td align="right" style="height: 18px;">${statement.amountDue}</td>
</tr>
<tr>
<td align="right">Deposit Balance</td>
<td align="right">${customer.depositbalance}</td>
</tr></table>
<#if statement.lines?has_content><table class="itemtable" style="margin-top: 10px; width: 100%;"><!-- start items --><#list statement.lines as line><#if line_index==0>
<thead>
<tr>
<th colspan="3" style="width: 69px;">${line.datecol@label}</th>
<th style="width: 101px;">Doc No.</th>
<th style="width: 230px;">Memo</th>
<th align="right" colspan="4" style="width: 50px text-align: right;">${line.charge@label}</th>
<th align="right" colspan="4" style="width: 60px text-align: right;">${line.payment@label}</th>
<th align="right" colspan="4" style="width: 80px text-align: right;">${line.balance@label}</th>
</tr>
</thead>
</#if><tr>
<td colspan="3" style="width: 69px;">${line.datecol}</td>
<td style="width: 101px;">${line.description}</td>
<td style="width: 230px;">${line.memo}</td>
<td align="right" colspan="4" style="width: 50px text-align: right;">${line.charge}</td>
<td align="right" colspan="4" style="width: 60px text-align: right;">${line.payment}</td>
<td align="right" colspan="4" style="width: 80px text-align: right;">${line.balance}</td>
</tr>
</#list><!-- end items --></table>
</#if><#if preferences.RETURNFORM && remittanceSlip??><hr />
<table style="width: 100%; margin-top: 10px;"><tr>
<td><span class="nameandaddress">${companyInformation.companyName}</span></td>
<td align="right"><span class="number">${remittanceSlip@title}</span></td>
</tr></table><table style="width: 100%; margin-top: 10px;"><tr>
<th>${remittanceSlip.customername@label}</th>
<th>${statement.trandate@label}</th>
<th>${statement.amountDue@label}</th>
<th>${remittanceSlip.amountPaid@label}</th>
</tr>
<tr>
<td>${companyInformation.addressText}</td>
<td>${statement.trandate}</td>
<td align="right">${statement.amountDue}</td>
<td>&nbsp;</td>
</tr></table><table style="width: 100%;"><tr>
<th>${remittanceSlip.ccinfo@label}</th>
<th>${remittanceSlip.companyaddress@label}</th>
</tr>
<tr>
<td>${remittanceSlip.ccinfo}</td>
<td>${companyInformation.addressText}</td>
</tr></table><table style="width: 100%;"><tr>
<td style="width: 500px;">Confirmed By&nbsp;</td>
<td style="width: 150px; text-align: right;">Printed By :&nbsp;${user.firstname}</td>
</tr>
<tr>
<td style="width: 100%;">&nbsp;</td>
<td style="width: 150px; text-align: right;">Printed Date :&nbsp;${.now?datetime}</td>
</tr>
<tr>
<td style="width: 100%;">&nbsp;</td>
<td style="width: 150px; text-align: right;"><span style="font-size:10px;"><span id="cke_bm_209S" style="display: none;">&nbsp;</span><span style="font-size:10px;"><pagenumber/></span></span>&nbsp;<span style="font-size:10px;">of&nbsp;<span style="font-size:10px;"><totalpages/></span></span></td>
</tr></table>
<br />&nbsp;</div>
</#if></body></pdf></#list><#else><pdf><head></head><body>
</body>
</pdf></#if></pdfset>

With Best Regards,

Honey