So far so good...except for little quirks like the routing number. Thanks for the info. Waiting for a response from the EZ-ACH people about how to pass the addenda records for CCD+ format that the bank wants. Anyone else out there using EZ-ACH still and passing invoice details for payments?
Dumping the data to a spreadsheet for use by EZ-ACH has been a struggle. I thought I could modify the Crystal APremit.rpt report but found Epicor decided Vendor ID was not worthy to include in the DBF files. And the canned electronic payment CSV file is a joke. It DOES have the vendor number (not the ID) which is worse than worthless but no provision for identifying the invoices being paid. I decided nuts to all that and wrote the export with Report Builder. Would have used Access but did not want to mess with ODBC for the person that will be running it.
Bottom line is Epicor claiming AP in 6.10 does NACHA payments is only true in the most minimal way. Unusable without modification by 99% of sites. But as usual a great way to push their custom programming services. Hopefully 8.x or E9 actually have it usable as a standard feature.
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Julie Lehmann
Sent: Thursday, December 03, 2009 7:40 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] AP Vendor Bank Routing Number
Hi Todd,
Yes, the routing number goes in the swift number field..
Hope your ACH task is going well!
Julie
Mercury Minnesota Inc.
Dumping the data to a spreadsheet for use by EZ-ACH has been a struggle. I thought I could modify the Crystal APremit.rpt report but found Epicor decided Vendor ID was not worthy to include in the DBF files. And the canned electronic payment CSV file is a joke. It DOES have the vendor number (not the ID) which is worse than worthless but no provision for identifying the invoices being paid. I decided nuts to all that and wrote the export with Report Builder. Would have used Access but did not want to mess with ODBC for the person that will be running it.
Bottom line is Epicor claiming AP in 6.10 does NACHA payments is only true in the most minimal way. Unusable without modification by 99% of sites. But as usual a great way to push their custom programming services. Hopefully 8.x or E9 actually have it usable as a standard feature.
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Julie Lehmann
Sent: Thursday, December 03, 2009 7:40 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] AP Vendor Bank Routing Number
Hi Todd,
Yes, the routing number goes in the swift number field..
Hope your ACH task is going well!
Julie
Mercury Minnesota Inc.
----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Wednesday, December 02, 2009 1:44 PM
Subject: [Vantage] AP Vendor Bank Routing Number
Easy question probably applies for all versions prior to E9. When setting up the bank info for an AP Vendor for electronic payments where do you enter their bank routing number? The help screens don't address this. If we are not using a Swift Number do we put it in that field? I need to get it from somewhere to pass through an export file that goes into a NACHA file creator.
Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]