Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!