Financials Unlocked

EBP Looping Applied Invoices



Here’s a quick tip to include remittance detail in any payables file produced by the Electronic Payments module in NetSuite.

The primary file loops over all payments in the batch.  To include remittance details, loop over applied invoices within each payment.  That will produce a nested loop, but is required for this purpose.  To do that, use the following:

          <#list transHash[payment.internalid] as transaction>

          …enter logic here…

          </#list>

If you need any summary information posted on the payment lines, this will require the loop to be run twice – once to calculate the summary data and once to print each applied invoice.

START A CONVERSATION