Mark and Cathy,
Something like you guys are doing is along the lines of what I was planning on. Glad to know something like this would work!
Hello,
Our bank has given us their ACH format for payables and such, and I'm assuming using the Electronic Interface is what I'd use to customize the character and format properties, however I'm not sure what program to use or if this is something I'll have to create as well. I'm honestly wondering if it's just not better to create something in Crystal Reports instead.
I'd love to hear some experiences on what everyone does for ACH and EFT payments on Epicor 9, and if I'm on the right track.
Thanks,
Epicor doesn't have a standard ACH format they use some oddball format that most banks don't accept you'll have to customize this (Epicor has this code written and you can usually just get it from them, or conversely you can write your own)
They may have included it with the most recent releases though I haven't checked.
On Tue, Jun 24, 2014 at 9:07 AM, jockthemotie@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p></p><p><span>Hello, </span></p><p><span><br></span></p><p>Our bank has given us their ACH format for payables and such, and I'm assuming using the Electronic Interface is what I'd use to customize the character and format properties, however I'm not sure what program to use or if this is something I'll have to create as well.  I'm honestly wondering if it's just not better to create something in Crystal Reports instead.</p>
I'd love to hear some experiences on what everyone does for ACH and EFT payments on Epicor 9, and if I'm on the right track.
Thanks,
</div> <div style="color:#fff;min-height:0;"></div>
I did create a support call on this and they said it's a customization issue; no mention of whether they had the code. Do you have a contact I could talk to to get a look at it?
On Jun 24, 2014 9:14 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:
Â<div> <p><div dir="ltr"><div class="ygrps-yiv-824755654gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Epicor doesn't have a standard ACH format they use some oddball format that most banks don't accept you'll have to customize this (Epicor has this code written and you can usually just get it from them, or conversely you can write your own)</div>They may have included it with the most recent releases though I haven't checked.On Tue, Jun 24, 2014 at 9:07 AM, jockthemotie@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p></p><p><span>Hello, </span></p><p><span><br></span></p><p>Our bank has given us their ACH format for payables and such, and I'm assuming using the Electronic Interface is what I'd use to customize the character and format properties, however I'm not sure what program to use or if this is something I'll have to create as well.  I'm honestly wondering if it's just not better to create something in Crystal Reports instead.</p>
I'd love to hear some experiences on what everyone does for ACH and EFT payments on Epicor 9, and if I'm on the right track.
Thanks,
</div> <div style="color:#fff;min-height:0;"></div></div> <div style="color:#fff;min-height:0;"></div>
No I do not sorry. I do know someone who I used to work with that has the customization made they might be able to sell it to you. Contact me off the list of you want that information.
Thanks!
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, Jun 24, 2014 at 9:24 AM, Kyle Maurer jockthemotie@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p></p><p dir="ltr">I did create a support call on this and they said it's a customization issue; no mention of whether they had the code. Do you have a contact I could talk to to get a look at it? </p><div class="ygrps-yiv-1933076147">On Jun 24, 2014 9:14 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:
Â<div> <p></p><div dir="ltr"><div class="ygrps-yiv-1933076147gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Epicor doesn't have a standard ACH format they use some oddball format that most banks don't accept you'll have to customize this (Epicor has this code written and you can usually just get it from them, or conversely you can write your own)</div>They may have included it with the most recent releases though I haven't checked.On Tue, Jun 24, 2014 at 9:07 AM, jockthemotie@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p></p><p><span>Hello, </span></p><p><span><br></span></p><p>Our bank has given us their ACH format for payables and such, and I'm assuming using the Electronic Interface is what I'd use to customize the character and format properties, however I'm not sure what program to use or if this is something I'll have to create as well.  I'm honestly wondering if it's just not better to create something in Crystal Reports instead.</p>
I'd love to hear some experiences on what everyone does for ACH and EFT payments on Epicor 9, and if I'm on the right track.
Thanks,
</div> <div style="color:#fff;min-height:0;"></div></div> <div style="color:#fff;min-height:0;"></div>
</div>
<div style="color:#fff;min-height:0;"></div>
I used a product called EasyACH from Coastal Software in Vancouver, WA. Very easy to set up to take a specifically formatted file and convert to a standard ACH format for sending to the bank. I used Report Builder but Crystal would have worked fine.  I then had a Crystal Report for creating remittance advices to be sent to the vendors and used CRD (Crystal Reports Distribution from Christian-Steven) to email the PDFs based on a specific vendor contact’s email address. The people at Coastal were very easy to work with. About 2/3 of the vendors were on electronic payment when I left saving a ton of people time and postage.
-Todd C.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, June 24, 2014 8:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Electronic Interface for ACH payments
Hello,
Our bank has given us their ACH format for payables and such, and I'm assuming using the Electronic Interface is what I'd use to customize the character and format properties, however I'm not sure what program to use or if this is something I'll have to create as well. I'm honestly wondering if it's just not better to create something in Crystal Reports instead.
I'd love to hear some experiences on what everyone does for ACH and EFT payments on Epicor 9, and if I'm on the right track.
Thanks,
THanks guys, seems a very odd thing to not have available as it seems a pretty standard format. There's a million ACH converters available, I might just grab something and have it auto process a csv export.
We setup a query, using payment method as a filter. We created a new payment method called ACH and attached it to the bank we pay from. We then worked with the bank on a very simple format (check number, amount, routing number, supplier ID, date, and one or two other fields)
We use the BAQ export to send this as a csv file to a shared drive every night. The AP Person logs into the
bank, goes to the ACH file import screen, finds the .csv file and uploads it. When they are done they move the file to an archived folder)
The bank may send you a document with ACH formats that can be a lot more involved, header records and line records, but we worked with several different banks and if you get to the right person you will usually find they will accept a very simple format. Some banks let you decide the file format when you create the ACH upload on their web site
On Tuesday, June 24, 2014 10:23 AM, "jockthemotie@... [vantage]" <vantage@yahoogroups.com> wrote:
<div id="ygrps-yiv-250413195yiv5451120532ygrp-text">
<div>THanks guys, seems a very odd thing to not have available as it seems a pretty standard format. There's a million ACH converters available, I might just grab something and have it auto process a csv export. </div>
</div>
<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mkp hr {
border:1px solid #d8d8d8;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mkp #ygrps-yiv-250413195yiv5451120532hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mkp #ygrps-yiv-250413195yiv5451120532ads {
margin-bottom:10px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mkp .ygrps-yiv-250413195yiv5451120532ad {
padding:0 0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mkp .ygrps-yiv-250413195yiv5451120532ad p {
margin:0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mkp .ygrps-yiv-250413195yiv5451120532ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-sponsor #ygrps-yiv-250413195yiv5451120532ygrp-lc {
font-family:Arial;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-sponsor #ygrps-yiv-250413195yiv5451120532ygrp-lc #ygrps-yiv-250413195yiv5451120532hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-sponsor #ygrps-yiv-250413195yiv5451120532ygrp-lc .ygrps-yiv-250413195yiv5451120532ad {
margin-bottom:10px;padding:0 0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532activity span {
font-weight:700;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532activity span:first-child {
text-transform:uppercase;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532activity span a {
color:#5085b6;text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532activity span span {
color:#ff7900;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532activity span .ygrps-yiv-250413195yiv5451120532underline {
text-decoration:underline;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532attach div a {
text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532attach img {
border:none;padding-right:5px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532attach label {
display:block;margin-bottom:5px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532attach label a {
text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 blockquote {
margin:0 0 0 4px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532bold {
font-family:Arial;font-size:13px;font-weight:700;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532bold a {
text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 dd.ygrps-yiv-250413195yiv5451120532last p a {
font-family:Verdana;font-weight:700;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 dd.ygrps-yiv-250413195yiv5451120532last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 dd.ygrps-yiv-250413195yiv5451120532last p span.ygrps-yiv-250413195yiv5451120532yshortcuts {
margin-right:0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532attach-table div div a {
text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532attach-table {
width:400px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532file-title a, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532file-title a:active, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532file-title a:hover, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532file-title a:visited {
text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532photo-title a, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532photo-title a:active, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532photo-title a:hover, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div.ygrps-yiv-250413195yiv5451120532photo-title a:visited {
text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 div#ygrps-yiv-250413195yiv5451120532ygrp-mlmsg #ygrps-yiv-250413195yiv5451120532ygrp-msg p a span.ygrps-yiv-250413195yiv5451120532yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532green {
color:#628c2a;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532MsoNormal {
margin:0 0 0 0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 o {
font-size:0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532photos div {
float:left;width:72px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532reco-category {
font-size:77%;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532reco-desc {
font-size:77%;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 .ygrps-yiv-250413195yiv5451120532replbq {
margin:4px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mlmsg table {
font-size:inherit;font:100%;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mlmsg select, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 input, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mlmsg pre, #ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 code {
font:115% monospace;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mlmsg * {
line-height:1.22em;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-mlmsg #ygrps-yiv-250413195yiv5451120532logo {
padding-bottom:10px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-msg p a {
font-family:Verdana;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-msg p#ygrps-yiv-250413195yiv5451120532attach-count span {
color:#1E66AE;font-weight:700;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-reco #ygrps-yiv-250413195yiv5451120532reco-head {
color:#ff7900;font-weight:700;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-reco {
margin-bottom:20px;padding:0px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-sponsor #ygrps-yiv-250413195yiv5451120532ov li a {
font-size:130%;text-decoration:none;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-sponsor #ygrps-yiv-250413195yiv5451120532ov li {
font-size:77%;list-style-type:square;padding:6px 0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-sponsor #ygrps-yiv-250413195yiv5451120532ov ul {
margin:0;padding:0 0 0 8px;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-text {
font-family:Georgia;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-text p {
margin:0 0 1em 0;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-text tt {
font-size:120%;}
#ygrps-yiv-250413195 #ygrps-yiv-250413195yiv5451120532 #ygrps-yiv-250413195yiv5451120532ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-250413195
Back in 2008, we wrote a Crystal report with the Header and Footer required.
Exported it to a text File and then uploaded to the bank.
I am sure there is an easier way now.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, June 24, 2014 7:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Electronic Interface for ACH payments
I used a product called EasyACH from Coastal Software in Vancouver, WA. Very easy to set up to take a specifically formatted file and convert to a standard ACH format for sending to the bank. I used Report Builder but Crystal would have worked fine. I then had a Crystal Report for creating remittance advices to be sent to the vendors and used CRD (Crystal Reports Distribution from Christian-Steven) to email the PDFs based on a specific vendor contact’s email address. The people at Coastal were very easy to work with. About 2/3 of the vendors were on electronic payment when I left saving a ton of people time and postage.
-Todd C.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, June 24, 2014 8:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Electronic Interface for ACH payments
Hello,
Our bank has given us their ACH format for payables and such, and I'm assuming using the Electronic Interface is what I'd use to customize the character and format properties, however I'm not sure what program to use or if this is something I'll have to create as well. I'm honestly wondering if it's just not better to create something in Crystal Reports instead.
I'd love to hear some experiences on what everyone does for ACH and EFT payments on Epicor 9, and if I'm on the right track.
Thanks,