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.

Display Specific Transaction Lines an Email Template

edited Jul 1, 2020 7:33PM in Ask A Guru 3 comments

I'm trying to create an email template that will only display line items from the current transaction (Sales Order) with a quantity of 0. How can I achieve this?

In the template, we have a table with the following body:

<table align="center" border="1" cellpadding="4" cellspacing="1" style="width: 700px; font-size: 12px; font-family: arial;">

<thead>

     <tr>

     <th>Item Name</th>

     <th>Item Description</th>

     <th>Quantity</th>

     <th>Amount</th>

     </tr>

</thead>

<#list transaction.item as listItem>

<tbody>

     <tr>

     <td>${listItem.item}</td>

     <td>${listItem.description}</td>

     <td style="text-align: center;">${listItem.quantity}</td>

     <td style="text-align: right;">${listItem.amount}</td>

     </tr>

Tagged:

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