This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello - I don't see a dedicated `EFT` channel, so I'll shoot here:
we need to have the reference numbers of invoices paid via EFT added to the XML, so that these are visible on the bank statement (e.g. paid invoice ref numbers: 001, 002, 003)
this is for SEPA payments... is this possible with EFT? what needs to be added on the EFT payment template?
Thanks!

<@U01KPKP7SP5> A lot of this is going to be highly dependent on what the bank's requirement is for the payment file layout, There may not be space in the import file to add that info.

If there is space, then it depends on where that info is in relation to the the record the payment is being generated from.

Are the ref numbers stored in a custom field on the bill payment record, or are you trying to pull info from the apply sublist of the bill payment record?

I usually use the `tranid` value of the bills

you have to be careful about customizing the EFT template. Your bank generally provides a precise model so that the xml file is accepted. Adding unnecessary fields could block the validation of your file

I'm aware of that - I've customized tens of templates : )
Thanks for the input everyone : )

```&lt;#function getCreditReference payment&gt;
&lt;#assign paidTransactions = transHash[payment.internalid]&gt;
&lt;#assign reference = ""&gt;
&lt;#assign paidTransactionsCount = paidTransactions?size&gt;
&lt;#if (paidTransactionsCount &gt;= 1)&gt;
    &lt;#list paidTransactions as transaction&gt;
       &lt;#if transaction.custbody_poziv_na_broj?has_content&gt;
          &lt;#assign reference = transaction.custbody_poziv_na_broj&gt;
       &lt;/#if&gt;
    &lt;/#list&gt;
&lt;/#if&gt;
&lt;#return reference&gt;
&lt;/#function&gt;```


Ok, not exactly what are you looking for, but just for an example

Function iterates through all paid transactions (one payment multiple invoices) and get some data. I thinki you can just replace logic with “reference = reference + transaction.YOUR_FIELD”

<@U02RLLUNH6H> - thanks for the input, I think I can use this indeed : )