Saved Searches and Advanced PDF
Hey all, I am trying to integrate a saved search into an Advanced PDF template. The saved search is an aging of the customer and is intended to be at the bottom of the invoice. The code I have so far is as follows but how would I actually link it to pull results from the saved search?
<table>
<thead>
<tr>
<th>${result.entity@label}</th>
<th>Current Balance</th>
<th>30 Days</th>
<th>60 Days</th>
<th>90 Days</th>
<th>> 90 Days</th>
<th>Total Balance</th>
</tr>
<tr>
<td>${result.entity}</td>
<td>${result.formulacurrency}</td>
<td>${result.formulacurrency_1}</td>
<td>${result.formulacurrency_2}</td>
<td>${result.formulacurrency_3}</td>
<td>${result.formulacurrency_4}</td>
<td>${result.formulacurrency_5}</td>
</tr>
</thead>
</table>
I don’t believe you will be able to add these results into an Invoice PDF Template.
However, it is possible via SuiteScript.