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 to Group by Item Category and Amount in Advanced PDF FreeMarker
Hello,
I'm trying to group the invoice lines by Category and Amount. This means that for each category I'd like to display the total amount for that category. Below is my FreeMarker code:
<#assign categoryTotals = {}> <!-- create an empty map to hold category totals -->
<#list record.item as item> <!-- loop through each line item -->
<#assign category = item.custcol_subof_category?string> <!-- get the category value for the current line item -->
<#assign amount = item.amount> <!-- get the amount value for the current line item -->
<!-- custcol_subof_category is the custom column line field on the invocie -->
<#if categoryTotals[category]??> <!-- if the category is already in the map, add the amount to its total -->
<#assign categoryTotals[category] = categoryTotals[category] + amount>
<#else> <!-- if the
Tagged:
0