ACH and EDI

KB #5438508 - ACH Setup and AP160 Technical Specification

That's the ACH setup which AP already has set up. It's the EDI setup that's not clear. From What I can see from the KB is that instead of AP160, we run AP161 which creates a seperate remittance file when seperate remittance is selected in CB00.5. Of course being in supply chain I don't have security access to the CB screens so I can't see this setup. But according to the KB we will have two files...

the payment file- $LAWDIR/productline/work/AP161ELECTPMT/AP161ELECTPMT

and

the remittance file- $LAWDIR/productline/work/AP161ELECTREM/AP161ELECTREM

Can anyone show me an example of the remittance file. Our AP manager is saying the problem with ACH is that we can send the check to the vendor's bank via the MHC software but there's nothing in the file that says what the payment is for, i.e. a listing of invoice numbers.

I think the Lawson EDI setup is a very small footnote in either the AP User Guide or the EDI user guide. I think that works with the AP160 only though, not AP161.

If you're using MHC to do the EDI though, you want to create a combined remittance in CB00.5. Their standard import routines will not read in a separate remittance.

Ok, thanks. How does the vendor know which invoices are being paid through the ACH payment? On a manual check the invoices that are being paid are printed. But according to the AP manager he can see no invoice information on the ACH file.

If you want remittance information you have to use the AP161 so it creates a CTX format file. PPD and CCD ACH records (AP160 output) do not include remittances. If they do it as Attached remittance on CB00.5 it will nest the remittance records (invoices) with the payment. If that file is sent to your bank, then your bank would send the remittances on to the vendor's bank and they get the information that way I believe.

We use AP161 and Payment Manager through Wells Fargo. The invoices and amounts are included in the AP161 file. Wells Fargo creates and sends PDF remittances to the designated e-mail address in the vendor file.