We also use EZ-ACH and it works quite well. My research before we chose
EZ-ACH indicated that trying to make a valid BACS file would be a lot of
work, and you would NOT want to be responsible for any errors since this
is payroll - other people's money!
I think we paid $200 for EZ-ACH.
Randy Weber
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Wednesday, January 20, 2010 12:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage - Set up AP to generate Electronic
Payment file
Not doing BACS, sorry, but some things we've run into lately getting set
up for NACHA CTX format. Much of this with a lot of help from group
member Julie Lehmann (thanks!).
1. The CSV output file for electronic payments from Vantage (6.10) is
pretty much worthless. Especially if you need payment details for each
invoice. There is no provision for addenda records. Given the weak
*useless?) nature of this "capability" or lack of attention to I suspect
later versions are no better.
2. I created my own export using Report Builder, which is not a solution
for later versions but Crystal Reports or BAQ might work. It used the
CheckHed table (linked to Vendor, VendBank and APTran) and selects for a
specific group and ElecPayment = yes. Then it outputs in CSV format.
3. We purchased a product called EZ-ACH File Creator from Coastal
Software. to convert the CSV to NACHA CTX format. CTX was the only one
that would support variable numbers of addenda records. These are plain
text explanations of the invoice number, amount, discount and net amount
and will appear on the recipients bank statement (or in their electronic
portal).
4. EZ-ACH is working very well and the bank has approved our test files.
We do our first live file later this week. There is a bit of setup for
it but they remote in and do it for you. They have been very responsive
and helpful.
It's been a struggle and learning curve but should work pretty slick
once we get rolling. Unfortunately I don't see BACS in the formats they
support but they may either have it not listed or may know of another
company that can. http://www.ezdd.com/
-Todd C.
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, January 20, 2010 9:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage - Set up AP to generate Electronic Payment
file
Hi All,
We are trying to set up our electronic payment file (CSV) to be the same
as what is required by our bank so we can import it into our online
banking without having to manually type line by line.
The Bank who are going to accept the BACS payment (I dont know if that's
a UK thing or Worldwide) have requested that the string of text per
entry is always 106 (I think characters) and that ie the Sort Code is
always 6 characters etc etc.
I have set it up (so I thought) in the Electronic Interface section,
with a list of poperties laid out in a list with the min/max characters
per Property. However, it obviously doesnt work because you cant specify
which fields (ie supplier's sort code info) go into which property name
field.
All suppliers details are set up on their record, but when the file is
exported, they information is in the incorrect order.
Has anybody successfully been able to export their AP payments in the
required BACS format for their bank?
Any help would be appreciated.
I can't seem to find anything in the Help which is going to help me.
Thanks,
CHRIS THOMPSON
[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]
EZ-ACH indicated that trying to make a valid BACS file would be a lot of
work, and you would NOT want to be responsible for any errors since this
is payroll - other people's money!
I think we paid $200 for EZ-ACH.
Randy Weber
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Wednesday, January 20, 2010 12:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage - Set up AP to generate Electronic
Payment file
Not doing BACS, sorry, but some things we've run into lately getting set
up for NACHA CTX format. Much of this with a lot of help from group
member Julie Lehmann (thanks!).
1. The CSV output file for electronic payments from Vantage (6.10) is
pretty much worthless. Especially if you need payment details for each
invoice. There is no provision for addenda records. Given the weak
*useless?) nature of this "capability" or lack of attention to I suspect
later versions are no better.
2. I created my own export using Report Builder, which is not a solution
for later versions but Crystal Reports or BAQ might work. It used the
CheckHed table (linked to Vendor, VendBank and APTran) and selects for a
specific group and ElecPayment = yes. Then it outputs in CSV format.
3. We purchased a product called EZ-ACH File Creator from Coastal
Software. to convert the CSV to NACHA CTX format. CTX was the only one
that would support variable numbers of addenda records. These are plain
text explanations of the invoice number, amount, discount and net amount
and will appear on the recipients bank statement (or in their electronic
portal).
4. EZ-ACH is working very well and the bank has approved our test files.
We do our first live file later this week. There is a bit of setup for
it but they remote in and do it for you. They have been very responsive
and helpful.
It's been a struggle and learning curve but should work pretty slick
once we get rolling. Unfortunately I don't see BACS in the formats they
support but they may either have it not listed or may know of another
company that can. http://www.ezdd.com/
-Todd C.
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, January 20, 2010 9:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage - Set up AP to generate Electronic Payment
file
Hi All,
We are trying to set up our electronic payment file (CSV) to be the same
as what is required by our bank so we can import it into our online
banking without having to manually type line by line.
The Bank who are going to accept the BACS payment (I dont know if that's
a UK thing or Worldwide) have requested that the string of text per
entry is always 106 (I think characters) and that ie the Sort Code is
always 6 characters etc etc.
I have set it up (so I thought) in the Electronic Interface section,
with a list of poperties laid out in a list with the min/max characters
per Property. However, it obviously doesnt work because you cant specify
which fields (ie supplier's sort code info) go into which property name
field.
All suppliers details are set up on their record, but when the file is
exported, they information is in the incorrect order.
Has anybody successfully been able to export their AP payments in the
required BACS format for their bank?
Any help would be appreciated.
I can't seem to find anything in the Help which is going to help me.
Thanks,
CHRIS THOMPSON
[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]