How can I created a hash total in PM EFT for a Vendor IBAN?

(0) Share

Report

Posted on by dgreer

My client is a US Bank working with international banks. They are currently working with Bank of America and need to send PM EFT payments to BOA. The EFT setup requirements from BOA require that a hash total on the Vendor IBAN (international bank account number). GP does not handle this. Has anyone done anything like this before?

Thanks,

Dan

*This post is locked for comments

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I created a hash total in PM EFT for a Vendor IBAN?

...
Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I created a hash total in PM EFT for a Vendor IBAN?

IBAN Entry Hash Total = Sum of first eight digits of the routing-transit numbers within the batch, right justify, left truncate
Community Member Microsoft Employee on at

Like (0)

Report

Re: How can I created a hash total in PM EFT for a Vendor IBAN?

Just so I understand - what do you need to hash? Is it EFT amounts grouped by IBAN - or do you need to count the number of NAN's inthe EFT file?

Ian.
L Vail 65,271 on at

Like (0)

Report

Re: How can I created a hash total in PM EFT for a Vendor IBAN?

Hi Dan,

My solution wasn't pretty, but it's been working for years. We brought the file produced by the system into an Access database (it was Ctree days!), calculated the hash total, and then created the ending file from Access.

Like I said, not pretty. Let's hope for an updated version of the answer :)

Kind regards,

Leslie