Hi!
I have a little problem with a advance PDF/HTML form...
I have an impression template for a quote like this;
[ATTACH=JSON]{"data-align":"center","data-size":"custom","height":"424","title":"Captura de pantalla 2017-06-08 16.44.09.png","width":"447","data-attachmentid":423994}[/ATTACH]
What I need is that the items that are the same sum and throw a single item with the measure of the sum of all items, for this case should give;
EBONY CRYSTAL CEP x2 26.67 M2 $1,197.00 $31,923.99 $5,107.84
NERO DAVOLA FLAM.CEP 120x60x1.5 130 M2 $627.00 $81,510.00 $13,041.60
Does anyone know what is the correct way to assign the function and condition for this to happen?
This is the code fragment where the problem is located;
<table cellpadding="1" cellspacing="1" style="width:100%;"><!-- start items --><#list record.item as item><#if item_index==0>
<thead>
<tr>
<td style="width: 300px;"><img align="left" src="https://system.na1.netsuite.com/core/media/media.nl?id=539&c=4019457&h=d6eb5dee88d0084c5674" style="width: 20px; height: 21px;" /></td>
<td><img align="center" src="https://system.na1.netsuite.com/core/media/media.nl?id=660&c=4019457&h=e3802b1c3caee6494c45" style="width: 14px; height: 16px;" /></td>
<td><img align="center" src="https://system.na1.netsuite.com/core/media/media.nl?id=661&c=4019457&h=48f7dfad2de6a4b0638f" style="width: 35px; height: 22px;" /></td>
<td align="right"><img src="https://system.na1.netsuite.com/core/media/media.nl?id=541&c=4019457&h=f747887124f8716a469f" style="width: 10px; height: 16px;" /></td>
<td align="center"><img src="https://system.na1.netsuite.com/core/media/media.nl?id=540&c=4019457&h=b164c73a5b663addb7da" style="width: 17px; height: 10px;" /></td>
<td align="center">IVA</td>
</tr>
</thead>
-------------------------------------------------- I think the condition is where the item description is called -----------------------------------------------------------------
<td align="left"><span style="color:#808080;"><span style="font-size:11px;"><span style="font-family:verdana,geneva,sans-serif;">${item.description}</span></span></span></td>
------------------------------------------------------- And the sum function is applied in the amount of m2 -----------------------------------------------------------------
<td align="center"><span style="color:#808080;"><span style="font-size:11px;"><span style="font-family:verdana,geneva,sans-serif;">${item.quantity}</span></span></span></td>
-------------------------------------------------------------------------------- Rest of code ----------------------------------------------------------------------------------------------
<td align="center"><span style="color:#808080;"><span style="font-size:11px;"><span style="font-family:verdana,geneva,sans-serif;">${item.custcol_maak_colum_um}</span></span></span></td>
<td align="right"><span style="color:#808080;"><span style="font-size:11px;"><span style="font-family:verdana,geneva,sans-serif;">${item.rate}</span></span></span></td>
<td align="right"><span style="color:#808080;"><span style="font-size:11px;"><span style="font-family:verdana,geneva,sans-serif;">${item.amount}</span></span></span></td>
<td align="right"><span style="color:#808080;"><span style="font-size:11px;"><span style="font-family:verdana,geneva,sans-serif;">${item.custcol_ix_calculatetax}</span></span></span></td>
</tr>
</#list><!-- end items --></table>
</#if>
Thanks for your help