Forum Stats

  • 3,686,902 Users
  • 61,168 Discussions
  • 206,741 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
Click on this link for the poll.

Community Care & Share: How to Add Fields from Applying Transactions to an Email Template

edited Mar 17, 2022 8:52PM in NetSuite Admin Corner

When adding the fields from Applying Transactions, there is no direct freemarker to use. In this example below, a user wants to add the Payment Date and Payment Amount of customer's invoice to a custom Email Template. This information is sourced from the Invoice record > Related Records tab > Payments subtab.


1. Navigate to Documents > Template > Email Templates

2. Click Edit beside your custom Email Template

3. Click the Source icon 

4. Add the statement below

<#list transaction.links as listItem>
<#if listItem.type?contains("Payment")>
<p>Payment Date: ${listItem.trandate}</p>
<p>Payment Amount: ${listItem.total}</p>
</#if>
</#list>


Do you have an alternative way of adding fields from Applying Transactions to your custom email template? Let us know by commenting below.

🏆️ Earn Community badges now! Refer a Member | Answer Accepter 

Michelle Jabanes | Ask a Guru

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders