show applied credit amount and payment amount in i...
# ask-stanley-ai
n
show applied credit amount and payment amount in invoice pdf
c
AI 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:
Copy code
<#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">&nbsp;</td>
	<td align="right">(${credit.amount})</td>
	</tr>
For showing the amount remaining, amount paid/credit, and balance in the invoice:
Copy code
<tr>
      <td>
        ${record@title} Total :
      </td>
      <td>
        ${record.currency}&nbsp;&nbsp;&nbsp;${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. ******
Slack 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
Please provide your feedback on this answer.