Sage 100

is there a way to include an 820 in an ACH file sent to the bank for vendor payment. This is not anything I've ever heard of but our client's vendor is requiring this in order to continue doing business with them. It started with the vendor (Merck) telling our client they need to submit payments via ACH. We turned on ACH for that vendor, and created a test file to send to the bank (JP Morgan Chase). The file was rejected by the bank because it did not include the 820 information. One of our consultants just got off a conference call with our client and the bank. On the call, JP Morgan seemed to think this was not anything out of the ordinary. they said that they typically receive the ACH file, transfer the funds, and then send on the 820 portion of the ACH file to the vendor. We now have the 820 data file layout that is required and we can design what is needed. But has anyone else run into this? Is there any enhancement? Should I be asking the EDI providers that integrate with Sage100? if there isn't something pre built, we can build it, but It just seems to be out in left field to me for some reason

Have you tried putting a CTX in the Standard Entry Class field on Vendor Maintenance for that vendor?

No. Is that all we need to do?

Well, in theory. CTX is supposed to create the 820 data. I've never tried it, though, so I don't know if it works, but it is an option, so one would HOPE!

I will have them try that tomorrow! Thanks Beth!

Good question. We have not run into an 820 request related to ACH before but here is the info from the internal help screen on what the CTX record adds to the file. How does this mesh with the file layout you received?