Display the summary table into fixed position in Advanced PDF Template

<#if record.custbody_invoice_type == "ใบกำกับภาษี (Vat)">

<pdf>
<head>
    <link name="thai-font" type="font" subtype="opentype" src="https://7454905.app.netsuite.com/core/media/media.nl?id=1850&amp;c=7454905&amp;h=FGnZX3vRRQc5NcQgq-bwYOkRuPBgcluYhDEs6eXbFRcqfr-d&amp;_xt=.ttf" src-bold="https://7454905.app.netsuite.com/core/media/media.nl?id=1851&amp;c=7454905&amp;h=S3IppkkXUI4Ue_jzP1DFXUHCxJS6Tfivem8O3JYh6lufc6Mp&amp;_xt=.ttf" bytes="2" />
    <#assign totalAmount =0>
    <#assign taxRate =0>
    <#list record.item as item>
    <#assign totalAmount += item.amount>
    <#if item?counter==1>
    <#assign taxRate = item.taxrate1>
</#if>
</#list>
<macrolist>
<macro id="nlheader">
    <table style="width:100%;">

        <tr><td colspan="25"  class="fontClass"><br /><br /><br /><br /><br /><br /></td></tr>
        <tr>
            <td colspan="25" align="right" style="padding-top:-4px;">
                <table style="width:100%;" colspan="25">
                    <tr>
                        <td colspan="20" class="fontClass" align="right" style="padding-top:-40px;padding-right:-28px;">Page&nbsp;<pagenumber/> / <totalpages/></td>
                        <td colspan="5" align="right" style="padding-top:-20px;"><barcode codetype="code128" showtext="false" value="${record.tranid}" width="159px"/></td>
                    </tr>
                </table>
            </td>

        </tr>
        <tr><td colspan="25" class="fontClass">&nbsp;</td></tr>

        <tr>
            <td colspan="15" class="fontClass" style="padding-top:-5px;">
                <table style="width:100%;" colspan="15">
                <tr>
                    <td colspan="15" class="fontClass">&nbsp;</td>
                </tr>
                <tr>
                    <td colspan="15" class="fontClass"></td>
                </tr>
                <tr>
                <td colspan="2" class="fontClass"></td>
                <td colspan="13"  style="padding-top:-10px;font-size:18pt;"><#if record.entity.companyname?has_content>${record.entity.companyname}<#else>${record.entity}</#if></td>
        </tr>
        <tr>
            <td colspan="2" class="fontClass"></td>
            <td colspan="13" class="fontClass16"> <#if record.billaddr1?has_content>${record.billaddr1}&nbsp;</#if>
            <#if record.billaddr2?has_content>${record.billaddr2}&nbsp;</#if>
        <#if record.billaddr3?has_content>${record.billaddr3}&nbsp;</#if>
    <#if record.billcity?has_content>${record.billcity}&nbsp;</#if>
<#if record.billzip?has_content>${record.billzip}</#if>
        </td>
        </tr>
<tr>
<td colspan="5" class="fontClass16"></td>
<td colspan="5" class="fontClass16">${record.vatregnum}</td>

</tr>
<tr>
<td colspan="2" class="fontClass"></td>

</tr>
        </table>
        </td>
<td colspan="10" style="padding-top:10px;">
<table style="width:100%;" colspan="10">

<tr>
<td colspan="3" class="fontClass"></td>
<td colspan="7" style="font-size:18pt;">${record.tranid}</td>

</tr>
<tr>
<td colspan="3" class="fontClass"></td>
<td colspan="7" class="fontClass16">${record.salesrep}</td>
</tr>

<tr>
<td colspan="3" class="fontClass"></td>

        </tr>
        </table>
        </macro>
<macro id="nlfooter">
<table style="width:100%;">

    <tr><td colspan="25"  class="fontClass"><br /><br /><br /></td></tr>
</table>
</macro>
        </macrolist>

<#function toCurrency value showSymbol=false>
<#if value?is_number>
<#local retval = 0>
<#local retval = value?string["#,##0.00"]>

<#return retval>
<#else>
<#return value>
        </#if>
        </#function>

<style type="text/css">* {
font-family: thai-font, sans-serif;
}
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 p { align:left }
b {
font-weight: bold;
color: #333333;
}
table.header td {
padding: 0px;
font-size: 10pt;
}
table.footer td {
padding: 0px;
font-size: 8pt;
}


table.total {
page-break-inside: avoid;
}


hr {
width: 100%;
color: #d3d3d3;
background-color: #d3d3d3;
height: 1px;
}
td.fontClass{
font-size:14pt;
}
td.horizontalLine {
border: 0;
border-top: 1px solid black;
width:100%;
}
td.fontClass16{
font-size:16pt;
}
</style>
        </head>
<body header="nlheader" header-height="30%" footer="nlfooter" footer-height="20pt" padding="0.5in 0.1in 0.1in 0.1in" size="A4">

<#assign counterVar2 = 0>

<#list record.item as item>
<#assign counterVar2 = counterVar2 + 1>
</#list>

<#if record.item?has_content>

<table  style="width: 100%;">
<#assign rowHeight1 = -300>
<#assign rowHeight2 = -280>
<#assign rowHeight3 = -260>
<#assign rowHeight4 = -240>
<thead>

</thead>

<tbody>
    <#assign totalAmount =0>
    <#assign taxRate =0>
    <#assign counterVar = 0>
    <tr><td colspan="22">&nbsp;</td></tr>

    <#list record.item as item>
    <#assign totalAmount += item.amount>

    <#if item?counter==1>
    <#assign taxRate = item.taxrate1>
</#if>


<tr>

<td align="left" colspan="14" style="word-break: break-all;font-size:16pt;padding-top:0px;padding-left:-7px;">
    <#if item.description?has_content>
    <#assign newDesc =''>
    <#if  item.description?contains("<br />")><#assign newDesc = item.description?replace("<br />"," ")><#else><#assign newDesc = item.description></#if>

<#assign len = newDesc?length>
<#if len &lt; 56>${newDesc}
<#else>${newDesc?substring(0,55)}
</#if>
        </#if>
        </td>
<td align="center" colspan="3"  class="fontClass16">${item.quantity}&nbsp;&nbsp;${item.units}</td>

<td align="center" colspan="3"  class="fontClass16">${item.rate}</td>
<td align="right" colspan="3"  class="fontClass16">${toCurrency(item.amount)}</td>
        </tr>
<#assign counterVar = counterVar + 1>
<#if counterVar == 12>
<#if counterVar2 == 12><#assign counterVar = 12>

<#else>
<#list 1..13 as i>
<tr><td colspan="25"  class="fontClass16">&nbsp;</td></tr>
        </#list>
<tr><td colspan="22">&nbsp;</td></tr>
<#assign counterVar = 0></#if>
        </#if>
        </#list>


<tr>
<td colspan="25">


    <table style="width: 100%;">
        <#if counterVar &gt; 12>
        <#assign pageLines = 12>
        <#else><#assign pageLines = 12 - counterVar>
    </#if>
    <#if pageLines &gt; 0>
    <#list 1..pageLines as i> <tr>
    <td align="center" colspan="5"   class="fontClass16" >&nbsp;</td>
    <td align="center" colspan="8"  class="fontClass16">&nbsp;</td>
    <td align="left" colspan="3"  class="fontClass16">&nbsp;</td>
    <td colspan="3"  class="fontClass16">&nbsp;</td>
    <td align="right" colspan="3"  class="fontClass16">&nbsp;</td>
    <td align="right" colspan="3"   class="fontClass16">&nbsp;</td>
</tr></#list></#if>




        </table>
        </td>
        </tr>
<tr>
<td colspan="25">

    <table  style="width: 100%;" >
        <tr style="padding-top:46px;">
            <td colspan="3" class="fontClass16" >&nbsp;</td>
        </tr>
        <tr><td colspan="25" class="fontClass16" >&nbsp;</td></tr>
        <tr style="padding-top:36px;">
            <td colspan="16">
                <table style="width:100%;" colspan="16">
                    <tr>
                        <td colspan="16" class="fontClass16">(${record.custbody_jj_amount_in_thai_js_92})</td>
                    </tr>

                </table>
            </td>
            <td colspan="9" style="padding-right:-20px;">
                <table style="width:100%;" colspan="9">
                    <tr>
                        <td colspan="6" class="fontClass16"></td>
                        <td colspan="3" class="fontClass16" align="right" style="padding-right:-3px;">${toCurrency(totalAmount)}<br />&nbsp;</td>
                    </tr>
                    <tr style="padding-top:-5px;">
                        <td colspan="4" class="fontClass16"></td>
                        <td colspan="2" class="fontClass16" align="center" style="padding-right:-14px;">${taxRate?replace('%','')}.00%</td>
                        <td colspan="3" class="fontClass16" align="right" style="padding-right:-3px;">${toCurrency(record.taxtotal)}<br />&nbsp;</td>
                    </tr>
                    <tr style="padding-top:-5px;">
                        <td colspan="6" class="fontClass16"></td>
                        <td colspan="3" class="fontClass16" align="right" style="padding-top:0px;padding-right:-3px;">${toCurrency(record.total)}<br />&nbsp;</td>
                    </tr>
                </table>
            </td>

        </tr>

    </table>
</td>
</tr>

        </tbody>



        </table>




        </#if>

        </body>
        </pdf>


        </#if>

Leave a comment

Your email address will not be published. Required fields are marked *