Hi, can you please put me in the right direction o...
# advancedpdfm
Merk
06/05/2024, 4:49 PMHi, can you please put me in the right direction of how to add the company logo and mainline name in the header of the saved search PDF/HTML template?
l
Lane Winham
06/06/2024, 12:10 AMI would also like information about this question.
Lane Winham
06/11/2024, 5:52 PMPlease correct me if I am wrong but after testing with my template, I believe if you have the data in your saved search then the list and index == 0 tag can be moved up before the macrolist tag. When doing this, I was able to include a header and footer with my template.
m
Merk
06/11/2024, 9:24 PMYou assumption is correct.
For the company logos:
The first step:
You will need to have subsidiary logo as a Formula (Text) in the Results of the saved search. {subsidiary.namenohierarchy}
The Second step you will need to have the following the template. Not to mention to replace Xs with the relevant data:
You will need to enter the following right after <pdf>
<macrolist>
<macro id="nlheader">
<#assign sub = "">
<#list results as result>
<#assign sub = result.formulatext>
</#list>
<#if sub == "Parent">
<img src="https://xxxxxxx-sb1.app.netsuite.com/core/media/media.nl?id=3927&c=&h=bI6m98F2-2i6g_88KomPJEzqzytJtT64K3K7irOMYC4TxUz1" style="width:5%; height: 5%;" />
<#elseif sub == "United Kingdom">
<img src="https://xxxxxxx-sb1.app.netsuite.com/core/media/media.nl?id=3930&c=&h=cR0SQJ6oSLNfXIOGGcopWlgztPoudIGOj4d4i3yV3_QbZQqD" style="width:5%; height: 5%;" />
</#if>
</macro>
</macrolist>
For header information I used the following:
<body header="nlheader" header-height="10%" padding="0.5in 0.5in 0.5in 0.5in" size="A4-LANDSCAPE">
<#assign documentId = "">
<#assign count = 0>
<#list results as result>
<#if result_index == 0 && documentId == "">
<#assign documentId = result.tranid>
</#if>
</#list>
<!--This is for the Header information-->
<#if count == 0>
<table wideth ="60%">
<#list results as result>
<#if result.tranid == documentId>
<#if result_index== 0>
<tr>
<td>
<strong><span style="font-size:16px;"> Date: ${result.trandate}</span></strong>
<br/>
<strong><span style="font-size:16px;"> Document No: ${result.tranid}</span></strong>
<br/>
<strong><span style="font-size:16px;">Customer: ${result.entity} </span></strong>
<br/>
<strong><span style="font-size:16px;">Created From: ${result.createdfrom}</span></strong>
<br/>
<strong><span style="font-size:16px;">Memo: ${result.memomain}</span></strong>
<br/>
</td>
</tr>
</#if>
</#if>
</#list>
</table>
<br/>
</#if>
For lines I used this:
<#if count == 0>
<table>
<#list results as result>
<#if result_index == 0>
<thead>
<tr>
<th>${result.item@label}</th>
<th>${result.memo@label}</th>
<th>${result.quantity@label}</th>
<th>${result.unit@label}</th>
<th>${result.inventorynumber@label}</th>
<th>${result.expirationdate@label}</th>
</tr>
</thead>
</#if>
<tr>
<td>${result.item}</td>
<td>${result.memo}</td>
<td>${result.quantity}</td>
<td>${result.unit}</td>
<td>${result.inventorynumber}</td>
<td>${result.expirationdate}</td>
</tr>
</#list>
</table>
</#if>
7 Views