Payment Format- Mapping for Accounts Payable ACH/EFT (NACHA) Template
Summary
Update NACHA TemplateContent
Trying to update the Accounts Payable ACH (NACHA) template that is generated from electronic payments. This file is then sent to the bank.
We are bringing in the routing number and bank account number using DFF's. We can bring these into the template but there is a requirement for Entry Hash which is the sum of all transit routing numbers (first eight digits only) from each entry detail record in the batch.
The default in our template is SUM(TO_NUMBER(SUBSTR(OutboundPayment/PayeeBankAccount/BranchNumber,1,8)))
Since we use a DFF to bring in the routing number (DocumentPayable/SrcDocDescriptiveFlexField/Attribute3), I've tried to update everything after SUBSTR to look at DocumentPayable/SrcDocDescriptiveFlexField/Attribute3 but I'm not successful.