This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

&gt;*AI generated answer (using internal Slack threads):*
To show the amount paid on an invoice by taking total - amountremaining in the advanced PDF template, you can use the following formula:

```xml
${record.total}-${record.amountremaining}
```

This formula will subtract the remaining amount from the total amount of the invoice, giving you the amount that has been paid.

You can add this formula to your advanced PDF template by following these steps:

1. Navigate to the Advanced PDF/HTML Templates page in NetSuite.
2. Click on the 'Customize' button next to the template you want to edit.
3. In the template editor, find the location where you want to display the paid amount.
4. Insert the formula above at the desired location.

Please note that you need to use the HTML editor for this, as the WYSIWYG editor may not support this functionality.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1686855223297259|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.884033859

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29J1BPM3/p1581451110271400|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.83931607

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C29HKGM6J/p1629171379073100|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.837377191



Please provide your feedback on this answer.

The bot isn't yet programmed to answer follow-up questions in-thread. But you can ask again in the main channel.