RE: 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>&gt; 90 Days</th>
	<th>Total&nbsp;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>
CAHolmes Rookie Asked on August 10, 2022 in Saved Searches.
Add Comment
1 Answers

I don’t believe you will be able to add these results into an Invoice PDF Template.

However, it is possible via SuiteScript.

Intermediate Answered on August 12, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.