Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
EFT Help
I am trying to customize a template according to bank requirements. The customized template generates the file, but it's missing the Company bank details. Not sure where I am making the mistake. Any insights are highly appreciated.
HEADER,${setMaxLength(pfa.custrecord_2663_file_creation_timestamp?date?string("yyyyMMdd"),8)}${setMaxLength(pfa.custrecord_2663_file_creation_timestamp?time?string("HHmmss"),6)},1,
<#list payments as payment>
<#assign ebank = ebanks[payment_index]>
<#assign cbank = cbanks[payment_index]>
<#assign entity = entities[payment_index]>
P,WIRES,,${setMaxLength(cbank.custrecord_2663_bic?upper_case,11)},${setMaxLength(cbank.custrecord_2663_acct_num?upper_case,34)},${setMaxLength(getCurrencySymbol(payment.currency)?upper_case,3)},${setMaxLength(formatAmount(getAmount(payment),"dec"),15)},,,,,,${setMaxLength(pfa.custrecord_2663_process_date?string("yyyyMMdd"),8)},,,${encloseString(setMaxLength(ebank.custrecord_2663_entity_acct_no?upper_case,34),34,",","\"")},${encloseString(setMaxLength(ebank.custrecord_2663_parent_vendor?upper_case,35),35,",","\"")},${encloseString(setMaxLength(ebank.custrecord_2663_entity_address1?upper_case,35),35,",","\"")},${encloseString(setMaxLength(ebank.custrecord_2663_entity_address2?upper_case,35),35,",","\"")},${encloseString(setMaxLength(ebank.custrecord_2663_entity_city?upper_case,35),35,",","\"")},${setMaxLength(ebank.custrecord_2663_entity_country_code?upper_case,2)},,,${setMaxLength(buildIBAN(ebank)?upper_case,34)},${setMaxLength(ebank.custrecord_2663_entity_bic?upper_case,11)},${encloseString(setMaxLength(ebank.custrecord_2663_entity_bank_name?upper_case,35),35,",","\"")},${encloseString(setMaxLength(ebank.custrecord_2663_entity_payment_desc?upper_case,35),35,",","\"")},OURS