I need some help from the experts, we have an pdf ...
# advancedpdft
Todd Juenemann
08/21/2024, 5:01 PMI need some help from the experts, we have an pdf template that is used to create customer statements, we are having an issue with the PDF document being generated with just the customer info, and a grand total, but the details are blank. I think it is related to the start date, I was able to confirm that using the Print Statements screen which uses the same PDF template and when I expand the start date it works. My questions are, does this template use the Print Statement screen data to generate the statement, or does it use something else, like a saved search. Based on my research so far, it uses the Statement Object, but how does that object get populated. Any help you can provide would be great, I am new to this and trying to figure it out.
<?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%;"><tr>
<td rowspan="2"><#if companyInformation.logoUrl?length != 0><img src="${companyInformation.logoUrl}" style="float: left; margin: 7px" /> </#if></td>
<td align="right"><span class="title">${record@title}</span></td>
<td align="right"><pagenumber/> of <totalpages/></td>
</tr></table>
</macro>
<macro id="nlfooter">
<table style="width: 100%"><tr>
<td align="center" style="text-align: center;">Please send remittance advice to:ar@todaysdesignhouse.com</td>
</tr>
<tr><td align="center" style="text-align: center; color: red;">REMIT ADDRESS HAS CHANGED Send remittance to:</td>
</tr> (routing and bank info removed)
<tr><td align="center" style="text-align: center;">/td>
</tr>
<tr><td align="center" style="text-align: center;"></td>
</tr>
<tr><td align="center" style="text-align: center;"></td>
</tr>
<tr><td align="center" style="text-align: center;"></td>
</tr>
<tr><td align="center" style="text-align: center;"></td>
</tr>
<tr><td align="center" style="text-align: center;"></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-size: 10pt;
padding-top: 6px;
padding-bottom: 2px;
}
td.address {
padding-top: 0;
font-size: 10pt;
}
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 header="nlheader" header-height="10%" footer="nlfooter" footer-height="100pt" padding="0.5in 0.5in 0.5in 0.5in" size="Letter">
<table style="width: 100%; margin-top: 10px;"><tr>
<td class="addressheader" colspan="3">Collection Statement as of ${statement.trandate}</td>
</tr>
<tr>
<td class="address" colspan="3" style="background-color: rgb(187, 187, 187); border-color: black; border-width:2px; line-height:120%">${statement.billaddress}</td>
</tr></table>
<#if statement.lines?has_content>
<table class="itemtable" style="width: 100%; margin-top: 10px; font-size: 8.5pt;"><!-- start items --><#list statement.lines as line><#if line_index==0>
<thead>
<tr>
<th colspan="6">Customer</th>
<th colspan="5">Reference #</th>
<th align="right" colspan="5">${line.otherrefnum@label}</th>
<th colspan="4">Type</th>
<th colspan="5">Reference<br />Date</th>
<th colspan="5">${line.duedate@label}</th>
<th align="right" colspan="5">Original <br/> Amount</th>
<th align="right" colspan="5">${line.payment@label}</th>
<th align="right" colspan="5">Open<br />Amount</th>
<!-- <th align="right" colspan="4">${line.balance@label}</th>-->
</tr>
</thead>
</#if><#if line.description != 'Balance Forward' && line.charge?string != "$0.00"><tr>
<td colspan="6"><#if line.subname?has_content> ${line.subname} #else ${customer.entitytitle} </#if></td>
<td colspan="5">${line.description?keep_after("#")}</td>
<td align="right" colspan="5">${line.otherrefnum}</td>
<td colspan="4">${line.description?keep_before("#")}</td>
<td colspan="5">${line.datecol}</td>
<td colspan="5">${line.duedate}</td>
<td align="right" colspan="5">${line.charge}</td>
<td align="right" colspan="5">${line.payment}</td>
<td align="right" colspan="5">${line.amountremaining}</td>
<!-- <td align="right" colspan="4">${line.balance}</td> -->
</tr></#if>
</#list><!-- end items --></table>
<!--<table class="aging" style="width: 100%; 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>${statement.aging1}</td>
<td>${statement.aging2}</td>
<td>${statement.aging3}</td>
<td>${statement.aging4}</td>
<td>${statement.aging5}</td>
<td>${statement.agingbal}</td>
</tr></table>--></#if>
<hr style="height2px;border width2px;colorblack;background colorblack" />
<table class="body" style="width: 100%; font-weight: bold;"><tr>
<td> </td>
<td align="right">Ending Balance:</td>
<td align="right">${statement.amountDue}</td>
</tr></table>
r
reza.seedin
08/23/2024, 5:08 AMyou might want to add a snippet instead of pasting the full code like this
9 Views