AP- NACHA PPD/CCD ACH Balance file

Summary

Bank Error -Hash entry total

Content

Bank requires a debit offset or balanced ACH file, using the Generic US ACH template the outbound Payer bank account number and the entry hash is not totaling correctly.  How do I get the output to include the Payer bank account number in record 627 debit line and record 8 and 9? 

Do I need to make updates to the RTF? 

Any assistance would be greatly appreciated!  Thank you!

 

Record 6 (the payer bank account number is not populating in the output.  

OutboundPayment/Payer/PartyNumber || ‘ ‘ || OutboundPayment/BankAccount/BankAccountNumber || ‘ ‘ || TO_CHAR(OutboundPayment/PaymentDate, ‘MMDD’)

 

Record 8 

SUBSTR(to_char(SUM