Electronic Payments CSV

It should automatically create a new remittance number for each ach
payment as well as print out the advice. When you process payments
it should ask if you want to print checks, remittance or both. If
you have vendors set up for electronic payment & are paying them in
this group with other paper checks then it should default to both.
Just choose your export file name and print. First print is checks,
you will get a box to wait until done. Click OK and then choose the
printer the ACH advice will go to. We go to APM ERM printer to
email the advices automatically. That should be it.

--- In vantage@yahoogroups.com, "wibaux52" <wibaux52@...> wrote:
>
> --- In vantage@yahoogroups.com, "Michael McWilliams"
> <mmcwilliams22@> wrote:
> >
> > I figured it out through trial and error some time ago. We
were
> > exporting for a while, but we had an issue with paying credit
card
> &
> > child support payments etc. that needed addnedums. We are using
> the
> > reference field for the addendum & it is working alright.
> > --- In vantage@yahoogroups.com, "wibaux52" <wibaux52@> wrote:
> > >
> > > --- In vantage@yahoogroups.com, "Michael McWilliams"
> > > <mmcwilliams22@> wrote:
> > > >
> > > > I am trying to find definitions for each field placing in
the
> > csv
> > > > bank export file. Called Epicor and amazingly they don't
have
> a
> > clue.
> > > > I see about 10 blank fields and cannot find where they come
> from.
> > > >
> > >
> > > Were you able to find the file layout - if not I have one I
think
> > will
> > > work. I was chasing the same problem and had someone from
Easy
> > ACH
> > > send it to me. I cannot believe how EPICOR gets away with not
> > > providing that file. In reading about ACH payment I see that
the
> > same
> > > problems have been around with older versions and it doesn't
seem
> > like
> > > this is a big thing with them. Let me know if I can help
> > >
> > > Thanks,
> > > Don
> > >
> >
> I am new to Vantage ACH but have been using ACH payments for over
20
> years. The only issue I have now in rel 803.404BP in writing ACH
> payments is that it doesn't increment the ACH number (check
number).
> Also, when I tested it with a regular check and an ACH, I got the
> check printed 2 times. In my reasearch the check number seems to
> have been an issue for a long time. What rel are you on and do
you
> have a process for writing ACH that you could share with me?
>
> Thanks
>
> Don Jones
> Roscoe Steel & Culvert Co.
>
I am trying to find definitions for each field placing in the csv
bank export file. Called Epicor and amazingly they don't have a clue.
I see about 10 blank fields and cannot find where they come from.
Hi Michael,
What version are you on?
We're on 6.1 and are looking to implement electronic payments but have the
same issue as yourself, i.e. getting a definitive layout of the generic csv
file.
We can make a pretty educated guess about most of the columns but a layout
would be nice!

Also, when testing the process, I can't seem to get the Checknum to advance
from 50000000 even after posting the payment group etc.
Have you had any success with this?


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Michael McWilliams
Sent: 25 April 2008 20:28
To: vantage@yahoogroups.com
Subject: [Vantage] Electronic Payments CSV


I am trying to find definitions for each field placing in the csv
bank export file. Called Epicor and amazingly they don't have a clue.
I see about 10 blank fields and cannot find where they come from.






[Non-text portions of this message have been removed]
We are using it now in 8.03.403C. We export the file & then pass it
through a program called Eazy Ach to create our NACHA file. Just
started last week. It works well but we want to find out about adding
descriptions or reference numbers from the csv to our NACHA file.







--- In vantage@yahoogroups.com, "Richard Bailey" <rbailey@...> wrote:
>
> Hi Michael,
> What version are you on?
> We're on 6.1 and are looking to implement electronic payments but
have the
> same issue as yourself, i.e. getting a definitive layout of the
generic csv
> file.
> We can make a pretty educated guess about most of the columns but
a layout
> would be nice!
>
> Also, when testing the process, I can't seem to get the Checknum
to advance
> from 50000000 even after posting the payment group etc.
> Have you had any success with this?
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of
> Michael McWilliams
> Sent: 25 April 2008 20:28
> To: vantage@yahoogroups.com
> Subject: [Vantage] Electronic Payments CSV
>
>
> I am trying to find definitions for each field placing in the csv
> bank export file. Called Epicor and amazingly they don't have a
clue.
> I see about 10 blank fields and cannot find where they come from.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Amazingly, we have found that the csv or txt file version of the
remittance does not reference an invoice while the same form in pdf
format has the invoice number listed.



Regards,





Andrew Best



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Monday, April 28, 2008 8:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Electronic Payments CSV



We are using it now in 8.03.403C. We export the file & then pass it
through a program called Eazy Ach to create our NACHA file. Just
started last week. It works well but we want to find out about adding
descriptions or reference numbers from the csv to our NACHA file.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Richard Bailey" <rbailey@...> wrote:
>
> Hi Michael,
> What version are you on?
> We're on 6.1 and are looking to implement electronic payments but
have the
> same issue as yourself, i.e. getting a definitive layout of the
generic csv
> file.
> We can make a pretty educated guess about most of the columns but
a layout
> would be nice!
>
> Also, when testing the process, I can't seem to get the Checknum
to advance
> from 50000000 even after posting the payment group etc.
> Have you had any success with this?
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of
> Michael McWilliams
> Sent: 25 April 2008 20:28
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Electronic Payments CSV
>
>
> I am trying to find definitions for each field placing in the csv
> bank export file. Called Epicor and amazingly they don't have a
clue.
> I see about 10 blank fields and cannot find where they come from.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I am still waiting to hear back from Epicor with an answer on the
mappings. Maybe in November.. If I figure them out I will let you
know. This is keeping quit a few accounts using paper checks due to
reference requirments.

--- In vantage@yahoogroups.com, "Andrew Best" <abest@...> wrote:
>
> Amazingly, we have found that the csv or txt file version of the
> remittance does not reference an invoice while the same form in pdf
> format has the invoice number listed.
>
>
>
> Regards,
>
>
>
>
>
> Andrew Best
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Michael McWilliams
> Sent: Monday, April 28, 2008 8:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Electronic Payments CSV
>
>
>
> We are using it now in 8.03.403C. We export the file & then pass
it
> through a program called Eazy Ach to create our NACHA file. Just
> started last week. It works well but we want to find out about
adding
> descriptions or reference numbers from the csv to our NACHA file.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Richard Bailey" <rbailey@> wrote:
> >
> > Hi Michael,
> > What version are you on?
> > We're on 6.1 and are looking to implement electronic payments
but
> have the
> > same issue as yourself, i.e. getting a definitive layout of the
> generic csv
> > file.
> > We can make a pretty educated guess about most of the columns
but
> a layout
> > would be nice!
> >
> > Also, when testing the process, I can't seem to get the Checknum
> to advance
> > from 50000000 even after posting the payment group etc.
> > Have you had any success with this?
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ]On
> Behalf Of
> > Michael McWilliams
> > Sent: 25 April 2008 20:28
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Electronic Payments CSV
> >
> >
> > I am trying to find definitions for each field placing in the csv
> > bank export file. Called Epicor and amazingly they don't have a
> clue.
> > I see about 10 blank fields and cannot find where they come from.
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Has anyone been able to successfully implement ADP labor reporting with
Vantage? We are considering this and would like to know of any
potential hurdles.



Regards,





Andrew Best



[Non-text portions of this message have been removed]
We have Kronos Timekeeper and Activities. I'm pretty sure that this
is what ADP sells. Since we run the database in-house, we can easily
extract the data from Kronos. For Epicor, we had to import with a
service connect workflow. Service connect was not quite as easy as
getting the data out of Kronos.

I'm not sure how easy it will be to extract the data from ADP. We
used to have ADP payroll. It is much easier to access the data when
you have control of the database.

--- In vantage@yahoogroups.com, "Andrew Best" <abest@...> wrote:
>
> Has anyone been able to successfully implement ADP labor reporting
with
> Vantage? We are considering this and would like to know of any
> potential hurdles.
>
>
>
> Regards,
>
>
>
>
>
> Andrew Best
>
>
>
> [Non-text portions of this message have been removed]
>
They called today to tell me it uses the Table APelecpy which is a
temp table that only holds the data until posting.

--- In vantage@yahoogroups.com, "Andrew Best" <abest@...> wrote:
>
> Amazingly, we have found that the csv or txt file version of the
> remittance does not reference an invoice while the same form in pdf
> format has the invoice number listed.
>
>
>
> Regards,
>
>
>
>
>
> Andrew Best
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Michael McWilliams
> Sent: Monday, April 28, 2008 8:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Electronic Payments CSV
>
>
>
> We are using it now in 8.03.403C. We export the file & then pass
it
> through a program called Eazy Ach to create our NACHA file. Just
> started last week. It works well but we want to find out about
adding
> descriptions or reference numbers from the csv to our NACHA file.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Richard Bailey" <rbailey@> wrote:
> >
> > Hi Michael,
> > What version are you on?
> > We're on 6.1 and are looking to implement electronic payments
but
> have the
> > same issue as yourself, i.e. getting a definitive layout of the
> generic csv
> > file.
> > We can make a pretty educated guess about most of the columns
but
> a layout
> > would be nice!
> >
> > Also, when testing the process, I can't seem to get the Checknum
> to advance
> > from 50000000 even after posting the payment group etc.
> > Have you had any success with this?
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ]On
> Behalf Of
> > Michael McWilliams
> > Sent: 25 April 2008 20:28
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Electronic Payments CSV
> >
> >
> > I am trying to find definitions for each field placing in the csv
> > bank export file. Called Epicor and amazingly they don't have a
> clue.
> > I see about 10 blank fields and cannot find where they come from.
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> I am trying to find definitions for each field placing in the csv
> bank export file. Called Epicor and amazingly they don't have a clue.
> I see about 10 blank fields and cannot find where they come from.
>

Were you able to find the file layout - if not I have one I think will
work. I was chasing the same problem and had someone from Easy ACH
send it to me. I cannot believe how EPICOR gets away with not
providing that file. In reading about ACH payment I see that the same
problems have been around with older versions and it doesn't seem like
this is a big thing with them. Let me know if I can help

Thanks,
Don
I figured it out through trial and error some time ago. We were
exporting for a while, but we had an issue with paying credit card &
child support payments etc. that needed addnedums. We are using the
reference field for the addendum & it is working alright.
--- In vantage@yahoogroups.com, "wibaux52" <wibaux52@...> wrote:
>
> --- In vantage@yahoogroups.com, "Michael McWilliams"
> <mmcwilliams22@> wrote:
> >
> > I am trying to find definitions for each field placing in the
csv
> > bank export file. Called Epicor and amazingly they don't have a
clue.
> > I see about 10 blank fields and cannot find where they come from.
> >
>
> Were you able to find the file layout - if not I have one I think
will
> work. I was chasing the same problem and had someone from Easy
ACH
> send it to me. I cannot believe how EPICOR gets away with not
> providing that file. In reading about ACH payment I see that the
same
> problems have been around with older versions and it doesn't seem
like
> this is a big thing with them. Let me know if I can help
>
> Thanks,
> Don
>
--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> I figured it out through trial and error some time ago. We were
> exporting for a while, but we had an issue with paying credit card
&
> child support payments etc. that needed addnedums. We are using
the
> reference field for the addendum & it is working alright.
> --- In vantage@yahoogroups.com, "wibaux52" <wibaux52@> wrote:
> >
> > --- In vantage@yahoogroups.com, "Michael McWilliams"
> > <mmcwilliams22@> wrote:
> > >
> > > I am trying to find definitions for each field placing in the
> csv
> > > bank export file. Called Epicor and amazingly they don't have
a
> clue.
> > > I see about 10 blank fields and cannot find where they come
from.
> > >
> >
> > Were you able to find the file layout - if not I have one I think
> will
> > work. I was chasing the same problem and had someone from Easy
> ACH
> > send it to me. I cannot believe how EPICOR gets away with not
> > providing that file. In reading about ACH payment I see that the
> same
> > problems have been around with older versions and it doesn't seem
> like
> > this is a big thing with them. Let me know if I can help
> >
> > Thanks,
> > Don
> >
>
I am new to Vantage ACH but have been using ACH payments for over 20
years. The only issue I have now in rel 803.404BP in writing ACH
payments is that it doesn't increment the ACH number (check number).
Also, when I tested it with a regular check and an ACH, I got the
check printed 2 times. In my reasearch the check number seems to
have been an issue for a long time. What rel are you on and do you
have a process for writing ACH that you could share with me?

Thanks

Don Jones
Roscoe Steel & Culvert Co.