This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi All,
How to combine duplicate items in sales order advanced pdf template. Need to combine same items and sum up its quantity and amount and display as single line.
Thanks

I’ve done this using a hash in freemarker. Basically, list (loop through) your lines, and instead of printing / outputting the detail, add the detail to the hash, holding the values for the quantity/amount and summing through each iteration of the loop.

<https://freemarker.apache.org/docs/ref_builtins_hash.html>

then, list through the hash and print/output!

Do you have any snippet please could you share it

```&lt;#assign qtyHash = {} /&gt;
...
&lt;#assign unique_key = ... /&gt;
&lt;#assign line_summary_data = {"qty" : line_qty, "amt" : line_amount, "item": line.item, "rate": line.rate} /&gt;
&lt;#assign qtyHash = qtyHash + {unique_key: line_summary_data} /&gt;
...
&lt;#list qtyHash as key, value&gt;
&lt;tr&gt;
	&lt;td colspan="10"&gt;&lt;p style="text-align: left;"&gt;&lt;strong&gt;&lt;span class="itemname"&gt;${value.item}&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;&lt;/td&gt;
	&lt;td colspan="3" align="right"&gt;&lt;p style="text-align: right;"&gt;${value.qty}&lt;/p&gt;&lt;/td&gt;
	&lt;td colspan="4" align="right"&gt;&lt;p style="text-align: right;"&gt;${value.rate}&lt;/p&gt;&lt;/td&gt;
	&lt;td colspan="4" align="right"&gt;&lt;p style="text-align: right;"&gt;$${value.amt?string["#,###.00"]}&lt;/p&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/#list&gt;```
Note: line_summary_data had “item” and “subsc” and all the other values as properties