我想要 netsuite 高级 pdf 模板中基于其货币的发票总和。
我期待下面的结果
这与此非常相似post https://stackoverflow.com/questions/44013395/does-oracle-netsuite-advanced-pdf-template-have-group-by-and-sum-functions/44030039?noredirect=1#comment134502813_44030039:
<#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>
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)