-1

I want the sum of invoices based on their currencies in netsuite advanced pdf template.

I am expecting the below result

enter image description here

Addy
  • 67
  • 3

1 Answers1

0

This would be very similar to the this post:

<#assign seen_currencies = []>
<#list transactions?sort_by('currency') as tran>
    <#assign tranCurrency = tran.currency>
    <#if seen_currencies ?seq_contains(tranCurrency )>
    <#else>
        <#assign seen_currencies  = seen_currencies + [tranCurrency]>
        <#assign currencyTotal = 0>
        <#list transactions?sort_by('trandate') as line>
           <#if tranCurrency == line.currency>
              <#assign currencyTotal = currencyTotal + line.amount>
    <tr>... output the transaction columns</tr>
          </if>
        </#list>
       <tr>... output the currencyTotal </tr>
   </#if>
</#list>
bknights
  • 14,408
  • 2
  • 18
  • 31