Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How do I use Grouping with SUM
How do I use Grouping with SUM.
[ATTACH=JSON]{"data-align":"none","data-size":"large","data-attachmentid":425610}[/ATTACH]
[CODE]
<#if record.item?has_content>
<table class="itemtable" style="width: 100%; margin-top: 10px;">
<!-- start items -->
<#list record.item as item>
<#if item_index==0>
<thead>
<tr>
<th colspan="18">${item.custitem_marketing_category@label}</th>
<th colspan="18">${item.custcol_ctp_harmonizecode@label}</th>
<th align="center" colspan="2">${item.quantity@label}</th>
<th align="right" colspan="3">UNIT PRICE</th>
[ATTACH=JSON]{"data-align":"none","data-size":"large","data-attachmentid":425610}[/ATTACH]
[CODE]
<#if record.item?has_content>
<table class="itemtable" style="width: 100%; margin-top: 10px;">
<!-- start items -->
<#list record.item as item>
<#if item_index==0>
<thead>
<tr>
<th colspan="18">${item.custitem_marketing_category@label}</th>
<th colspan="18">${item.custcol_ctp_harmonizecode@label}</th>
<th align="center" colspan="2">${item.quantity@label}</th>
<th align="right" colspan="3">UNIT PRICE</th>
0