Nada Ahmed
01/08/2025, 8:22 PMCeligo AI
01/08/2025, 8:22 PMAI generated answer (using internal Slack threads):To show the applied credit amount and payment amount in the invoice PDF, you can use the Advanced PDF/HTML templates in NetSuite. Here are two ways to achieve this: 1. Using a script: If there's no direct way to get the field in the advanced PDF template, you can achieve this via a script. However, this method requires knowledge of SuiteScript. 2. Using Advanced PDF/HTML templates: You can use the following code snippets in your Advanced PDF/HTML template to show the applied credit and payment amounts: For showing "Credits Applied" line values from the Bill payment (Vendor Payment) record:
<#list check.credit as credit>
<tr>
<td align="center">${credit.creditdate}</td>
<td align="left">${credit.appliedto}</td>
<td align="left">${credit.refnum}</td>
<td align="right">(${credit.amount})</td>
<td align="right"> </td>
<td align="right">(${credit.amount})</td>
</tr>
For showing the amount remaining, amount paid/credit, and balance in the invoice:
<tr>
<td>
${record@title} Total :
</td>
<td>
${record.currency} ${record.total}
</td>
</tr>
<#if record.status == "Open" && Record.amountremaining != Record.total && record.type == "custinvc" >
<tr>
<td>
Amount Paid/Credit :
</td>
<td>
${record.amountpaid}
</td>
</tr>
<tr>
<td>
Balance :
</td>
<td>
${record.amountremaining}
</td>
</tr>
<#else>
</#if>
Please note that you need to replace the placeholders with the actual field IDs from your NetSuite record.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
01/08/2025, 8:23 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848014474
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837111592
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828193188
Celigo AI
01/08/2025, 8:23 PM