<@U29QCJQF3> He needs to access the line items tho...
# suiteanalytics
i
@michoel He needs to access the line items though which is a sublist. Don't workflows not work with sublists?
m
You can access the complete record in the email template via freemarker
Example, this is an email template we use in a workflow to send alerts when products are sold at a loss
Copy code
A transaction has just been saved in the system with negative Gross Profit.<br />
<br />
<b>Customer:</b> ${transaction.entity}<br />
<b>Branch:</b> ${transaction.cseg_mos_branch}<br />
<b>Transaction #:</b> ${transaction.tranid}<br />
<b>Customer Order #:</b> ${transaction.otherrefnum}<br />
<b>Processed by:</b> ${transaction.custbody_reviewed_by}<br />
<b>Order Source:</b> ${transaction.custbody_order_source}<br />
<b>BTS Order:</b> ${transaction.custbody_mos_is_bts}<br />
<br />
<b>Transaction Total:</b> ${transaction.subtotal}<br />
<b>Total Cost:</b> ${transaction.totalcostestimate}<br />
<b>Total Profit:</b> ${transaction.estgrossprofit}<br />
<b>Total GP:</b> ${transaction.estgrossprofitpercent}<br />
<br />
&nbsp;
<table border="1" bordercolor="#ccc" cellpadding="5" cellspacing="0" style="border-collapse:collapse;">
<thead>
	<tr>
	<th scope="col">Item</th>
	<th scope="col">Description</th>
	<th scope="col">Qty</th>
	<th scope="col">Item Rate</th>
	<th scope="col">Item Cost</th>
	<th scope="col">GP %</th>
	</tr>
</thead>
<tbody><#list transaction.item as item><#assign gp_amount = item.amount - item.costestimate><#if item.amount == 0 ><#assign gp_percent = ""><#else><#assign gp_percent = (gp_amount / item.amount) * 100></#if>
	<tr><#if gp_amount lte 0 && item.quantity gt 0>
	<td><strong><span style="color:#FF0000;">${item.item}</span></strong></td>
	<td><strong><span style="color:#FF0000;">${item.description}</span></strong></td>
	<td><strong><span style="color:#FF0000;">${item.quantity}</span></strong></td>
	<td><strong><span style="color:#FF0000;">${item.rate}</span></strong></td>
	<td><strong><span style="color:#FF0000;">${item.costestimaterate}</span></strong></td>
	<td><strong><span style="color:#FF0000;">${gp_percent}%</span></strong></td>
	<#else >
	<td>${item.item}</td>
	<td>${item.description}</td>
	<td>${item.quantity}</td>
	<td>${item.rate}</td>
	<td>${item.costestimaterate}</td>
	<td>${gp_percent}%</td>
	</#if></tr>
	</#list>
</tbody>
</table>

<div style="text-align: center;"><br />
<a href="https://system.netsuite.com/app/accounting/transactions/${transaction.type}.nl?id=${transaction.id}&c=4078540"><span style="font-size:14px;">Click here to view the record</span></a></div>
@suitemike ☝️
💯 1