iSuite
05/23/2019, 10:21 PMmichoel
05/23/2019, 11:11 PMmichoel
05/23/2019, 11:12 PMA 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 />
<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>
michoel
05/23/2019, 11:12 PM