Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
How to insert data into csv into file Payment File Format in EFT?
Hi,
I created a custom Payment File Format for Positive Pay.
I want the output file as CSV. I written code as follows.
#OUTPUT START#
<table>
<Worksheet>
<#list payments as payment>
<#assign entity = entities[payment_index]>
<row>
<Cell><Data ss:Type="String"> ${cbank.custpage_pp_custrecord_2663_acct_num} </Data></Cell>
<Cell><Data ss:Type="String"> </Data></Cell>
<Cell><Data ss:Type="String"> ${payment.trandate?string("MMddyy")} </Data></Cell>
<Cell><Data ss:Type="String"> ${buildEntityName(entity,true)} </Data></Cell>
<Cell><Data ss:Type="String"> ${formatAmount(getAmount(payment),"dec")} </Data></Cell>
<Cell><Data ss:Type="String"> </Data></Cell>
</row>
</#list>
</Worksheet>
</table>