REFERENCE FIELD : <refFields type="CPA-005 DD"> <refField id="custrecord_2663_bank_num" label="Financial Institution Number" mandatory="true" helptext="Enter the number that identifies the bank in the Financial Institutions Directory, which is maintained by the Canadian Payment Association."/> <refField id="custrecord_2663_branch_num" label="Branch Transit Number" mandatory="true" helptext="Enter the routing number of the bank branch where your company's account is maintained. Bank branch routing numbers of Canadian financial institutions are listed in the Financial Institutions Directory of the Canadian Payment Association."/> <refField id="custrecord_2663_acct_num" label="Account Number" mandatory="true" helptext="Enter your company's bank account number (maximum of 12 digits)."/> <refField id="custrecord_2663_issuer_num" label="Client Number" mandatory="true" helptext="Enter the 10-digit number that identifies your company as a client of the bank. The first six numbers is assigned by the bank and the last 4 numbers is assigned by your company and can be used to indicate a subsidiary or division."/> <refField id="custrecord_2663_processor_code" label="Data Centre" mandatory="true" helptext="Enter the number of the bank processing center where the payment file will be processed. This information should be provided by the bank."/> <refField id="custrecord_2663_statement_name" label="Statement Name" helptext="Enter a name for electronic payment transactions made with this bank."/> </refFields> Entity Reference Fields * : <refFields type="CPA-005 DD"> <refField id="custrecord_2663_entity_bank_no" label="Financial Institution Number" mandatory="true" helptext="Enter the code used to identify the vendor's/employee's/customer's bank within the banking industry."/> <refField id="custrecord_2663_entity_branch_no" label="Branch Transit Number" mandatory="true" helptext="Enter the code that identifies the bank branch where the vendor's/employee's/customer's account is maintained."/> <refField id="custrecord_2663_entity_acct_no" label="Account Number" mandatory="true" helptext="Enter the vendor's/employee's/customer's bank account number."/> </refFields> Field validator : <fieldValidatorList> <fieldValidator> <fieldName>custrecord_2663_bank_num</fieldName> <validatorList> <validator type="num"> <param name="min">1</param> </validator> <validator type="len"> <param name="maxLength">4</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_branch_num</fieldName> <validatorList> <validator type="num"> <param name="min">1</param> </validator> <validator type="len"> <param name="maxLength">5</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_acct_num</fieldName> <validatorList> <validator type="num"> <param name="min">1</param> </validator> <validator type="len"> <param name="maxLength">12</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_issuer_num</fieldName> <validatorList> <validator type="alpha"> <param name="specialChars">!"#$%&'()*+,-.\/:;<=>?@[\]^_`{|}~0-9</param> </validator> <validator type="len"> <param name="minLength">10</param> <param name="maxLength">10</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_processor_code</fieldName> <validatorList> <validator type="num"> <param name="min">1</param> </validator> <validator type="len"> <param name="minLength">5</param> <param name="maxLength">5</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_statement_name</fieldName> <validatorList> <validator type="alpha"> <param name="specialChars">!"#$%&'()*+,-.\/:;<=>?@[\]^_`{|}~1-9</param> </validator> <validator type="invalidChars"> <param name="invalidChars">0</param> </validator> <validator type="len"> <param name="maxLength">15</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_legal_name</fieldName> <validatorList> <validator type="alpha"> <param name="specialChars">!"#$%&'()*+,-.\/:;<=>?@[\]^_`{|}~1-9</param> </validator> <validator type="invalidChars"> <param name="invalidChars">0</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_entity_bank_no</fieldName> <validatorList> <validator type="num"> <param name="min">1</param> </validator> <validator type="len"> <param name="maxLength">4</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_entity_branch_no</fieldName> <validatorList> <validator type="num"> <param name="min">1</param> </validator> <validator type="len"> <param name="maxLength">5</param> </validator> </validatorList> </fieldValidator> <fieldValidator> <fieldName>custrecord_2663_entity_acct_no</fieldName> <validatorList> <validator type="num"> <param name="min">1</param> </validator> <validator type="len"> <param name="maxLength">12</param> </validator> </validatorList> </fieldValidator> </fieldValidatorList> Bank file template : <#-- format specific processing --> <#assign totalAmount = 0> <#assign totalPayments = 0> <#assign recordCount = 1> <#function computeSequenceId> <#assign seqId = getSequenceId(false)> <#if seqId == 9999> <#assign seqId = 1> #else <#assign seqId = seqId + 1> </#if> <#return seqId> </#function> <#function getReferenceNote payment> <#assign paidTransactions = transHash[payment.internalid]> <#if paidTransactions?size == 1> <#assign transaction = paidTransactions[0]> <#assign tranId = transaction.tranid> <#if tranId?has_content> <#return tranId> </#if> </#if> <#return ""> </#function> <#assign newSeqId = computeSequenceId()> <#-- template building --> #OUTPUT START# A${setPadding(recordCount,"left","0",9)}${setLength(cbank.custpage_dd_custrecord_2663_issuer_num,10)}${setPadding(newSeqId,"left","0",4)}${setPadding(pfa.custrecord_2663_file_creation_timestamp?string("yyDDD"),"left","0",6)}${setPadding(cbank.custpage_dd_custrecord_2663_processor_code,"left","0",5)}${setLength("",20)}CAD${setLength("",1406)} <#list payments as payment> <#assign ebank = ebanks[payment_index]> <#assign entity = entities[payment_index]> <#assign amount = getAmount(payment)> <#assign totalAmount = totalAmount + amount> <#assign totalPayments = totalPayments + 1> <#assign recordCount = recordCount + 1> D${setPadding(recordCount,"left","0",9)}${setLength(cbank.custpage_dd_custrecord_2663_issuer_num,10)}${setPadding(newSeqId,"left","0",4)}450${setPadding(formatAmount(amount),"left","0",10)}${setPadding(pfa.custrecord_2663_process_date?string("yyDDD"),"left","0",6)}${setPadding(ebank.custrecord_2663_entity_bank_no,"left","0",4)}${setPadding(ebank.custrecord_2663_entity_branch_no,"left","0",5)}${setLength(ebank.custrecord_2663_entity_acct_no,12)}${setPadding("","left","0",25)}${setLength(cbank.custpage_dd_custrecord_2663_statement_name,15)}${setLength(buildEntityName(entity,false),30)}${setLength(cbank.custrecord_2663_legal_name,30)}${setLength(cbank.custpage_dd_custrecord_2663_issuer_num,10)}${setLength(entity.internalid,19)}${setPadding(cbank.custpage_dd_custrecord_2663_bank_num,"left","0",4)}${setPadding(cbank.custpage_dd_custrecord_2663_branch_num,"left","0",5)}${setLength(cbank.custpage_dd_custrecord_2663_acct_num,12)}${setLength(getReferenceNote(payment),15)}${setLength("",24)}${setPadding("","left","0",11)} </#list> Z${setPadding(recordCount + 1,"left","0",9)}${setLength(cbank.custpage_dd_custrecord_2663_issuer_num,10)}${setPadding(newSeqId,"left","0",4)}${setPadding(formatAmount(totalAmount),"left","0",14)}${setPadding(totalPayments,"left","0",8)}${setPadding("","left","0",1418)}#rt #OUTPUT END# #RETURN START# sequenceId:${newSeqId} #RETURN END# Electronic Bank Payments - Custom DD Payment File Format Context: configure a DD bannk payment template I got this error when opening the Company Bank Details where my template is selected an unexpected error occured in a script running on this page. customscript_14552_field_validator_cs (pageinit)JS_EXCEPTIONSyntaxError Unexpected token '<', "<!DOCTYPE "...is not valid JSON does anyone faced the same issue?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that users are discussing issues and solutions related to the Electronic Bank Payments module in NetSuite. In the first conversation, a user is encountering an error when changing the ACH CCD/PPD Template in the "Company Bank Details". The error message suggests an issue with parsing XML. Another user suggests comparing the new template with the old one that worked, and if everything seems fine, to contact NetSuite as it's their bundle. The original user later confirms that they found a solution. In the second conversation, a user is having trouble with a template in the Electronic Bank Payments module. They found that removing "9" from the template code resolved the issue. Another user suggests that the quotes around the "9" might have caused the problem. There's also a discussion about populating the bank code with custom templates. One user mentions that the fields on the Bank Details and Vendor Bank Details records remain blank when using a custom ACH template, as opposed to being auto-populated when using the native ACH template. In the third conversation, a user is trying to display the Parent Vendor on the Bank Details records. They added the field to the ENTITY REFERENCE FIELDS section in the Payment File Format record, but the contents of the field aren't a hyperlink on an existing record. They are asking if there's additional text they can add to make it appear as a hyperlink and whether "mandatory=\"true\"" is required. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******