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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
SuiteWorld | October 25–28, 2026 | Las Vegas Where our community gets ready for what’s next!
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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