ACH format for bank of america- calculating control totals
Summary:
We have just implemented fusion and built ACH payment files to be transmitted to Bank of America.
The bank requires us to put in a control total for supplier bank accounts by summing up the first 15 characters and then displaying sum in 10 characters from right. No query is working out for us. while summing up we needed to substitute alphabets with number 1.
one of the various things we have tried without substituting alphanumeric.
SUBSTR(ROUND(SUM(TO_NUMBER (OutboundPayment/PayeeBankAccount/UserEnteredBankAccountNumber))), GREATEST(LENGTH(ROUND (SUM(TO_NUMBER (OutboundPayment/PayeeBankAccount/UserEnteredBankAccountNumber)))),15)+1-10,10)
Can you please help. we have exhausted all our options.