NACHA A/P Processing - Followup

Yahoo Archive
1
I just looked through my old research on NACHA issues and some links I found from very old group threads about NACHA. It seems a number of people were using a product called EZ-ACH or EZ-Direct Deposit for MS-Excel. It is supposed to take an Excel or CSV file (like Vantage outputs) and turn it in to a proper ACH file - with a bunch of customization options. It lists for $199 so if it works would cost less that the rest of my time for this week.

Anyone still using this or have any comments on attempts to use it?

Thanks,
-Todd C.



[Non-text portions of this message have been removed]
2
I think this is mostly generic and not version specific but we are on Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to start processing A/P payment via electronic transfer. So far we have it pretty much set except for fine tuning the file to be sent to the bank. Biggest unresolved issue now is how to communicate remittance advice to the vendor. It seems like it would be too much work to print the electronic advices into one big PDF file and then split out them for manually emailing.

He wants me to check the group and see how other people are handling sending these to the vendor. Is there a more automated method? Especially without having to buy anything else. Or at least is there a way to use Adobe Acrobat's printer to print to PDF and create a new file for each page? Also, for vendors with only one invoice on a check...do you even send them a remittance advice? We have a quite a few occasional and one-item vendors for whom knowing what to apply the payment to needs no advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?

Just trying to streamline the process as much as possible so any hints and tips would be much appreciated.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.



[Non-text portions of this message have been removed]
3
Todd,
We're processing most of our A/P payments electronically and do not send remittance advices to any of our vendors.
If you use the CTX format, the addenda record shows all of the invoice #'s and amount paid. This record is then available from the vendor's bank.
When we first set it up, we let our vendors know that their payments would always arrive in their account on Fridays, and 99% have no problems retrieving the payment information from their bank. You are right - it takes all the "savings" out of processing an electronic payment if you still have to create and/or send a hard copy or fax or email a copy anyway.

Good luck!
Julie
Mercury Minnesota Inc.


----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com
Sent: Thursday, October 22, 2009 2:22 PM
Subject: [Vantage] NACHA A/P Processing


I think this is mostly generic and not version specific but we are on Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to start processing A/P payment via electronic transfer. So far we have it pretty much set except for fine tuning the file to be sent to the bank. Biggest unresolved issue now is how to communicate remittance advice to the vendor. It seems like it would be too much work to print the electronic advices into one big PDF file and then split out them for manually emailing.

He wants me to check the group and see how other people are handling sending these to the vendor. Is there a more automated method? Especially without having to buy anything else. Or at least is there a way to use Adobe Acrobat's printer to print to PDF and create a new file for each page? Also, for vendors with only one invoice on a check...do you even send them a remittance advice? We have a quite a few occasional and one-item vendors for whom knowing what to apply the payment to needs no advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?

Just trying to streamline the process as much as possible so any hints and tips would be much appreciated.

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]
4
We use APM doclink to do this. We are working on getting all vendors to electronic payment. When they print the advise they just choose the APM printer and it emails each vendor a copy.


--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehm

ann@...> wrote:
>
> Todd,
> We're processing most of our A/P payments electronically and do not send remittance advices to any of our vendors.
> If you use the CTX format, the addenda record shows all of the invoice #'s and amount paid. This record is then available from the vendor's bank.
> When we first set it up, we let our vendors know that their payments would always arrive in their account on Fridays, and 99% have no problems retrieving the payment information from their bank. You are right - it takes all the "savings" out of processing an electronic payment if you still have to create and/or send a hard copy or fax or email a copy anyway.
>
> Good luck!
> Julie
> Mercury Minnesota Inc.
>
>
> ----- Original Message -----
> From: Todd Caughey
> To: vantage@yahoogroups.com
> Sent: Thursday, October 22, 2009 2:22 PM
> Subject: [Vantage] NACHA A/P Processing
>
>
> I think this is mostly generic and not version specific but we are on Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to start processing A/P payment via electronic transfer. So far we have it pretty much set except for fine tuning the file to be sent to the bank. Biggest unresolved issue now is how to communicate remittance advice to the vendor. It seems like it would be too much work to print the electronic advices into one big PDF file and then split out them for manually emailing.
>
> He wants me to check the group and see how other people are handling sending these to the vendor. Is there a more automated method? Especially without having to buy anything else. Or at least is there a way to use Adobe Acrobat's printer to print to PDF and create a new file for each page? Also, for vendors with only one invoice on a check...do you even send them a remittance advice? We have a quite a few occasional and one-item vendors for whom knowing what to apply the payment to needs no advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?
>
> Just trying to streamline the process as much as possible so any hints and tips would be much appreciated.
>
> 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]
>
5
Todd, I'm beginning to set this up to. Are you creating the file that
goes to the bank with Crystal Reports? We're also on 6.1


Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830

For ITAR/EAR sensitive communications please e-mail me at:
norm.watkins@...

This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.




Todd Caughey <caugheyt@...>
Sent by: vantage@yahoogroups.com
10/22/2009 02:21 PM
Please respond to
vantage@yahoogroups.com


To
"vantage@yahoogroups.com" <vantage@yahoogroups.com>
cc

Subject
[Vantage] NACHA A/P Processing










I think this is mostly generic and not version specific but we are on
Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to
start processing A/P payment via electronic transfer. So far we have it
pretty much set except for fine tuning the file to be sent to the bank.
Biggest unresolved issue now is how to communicate remittance advice to
the vendor. It seems like it would be too much work to print the
electronic advices into one big PDF file and then split out them for
manually emailing.

He wants me to check the group and see how other people are handling
sending these to the vendor. Is there a more automated method? Especially
without having to buy anything else. Or at least is there a way to use
Adobe Acrobat's printer to print to PDF and create a new file for each
page? Also, for vendors with only one invoice on a check...do you even
send them a remittance advice? We have a quite a few occasional and
one-item vendors for whom knowing what to apply the payment to needs no
advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?

Just trying to streamline the process as much as possible so any hints and
tips would be much appreciated.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[Non-text portions of this message have been removed]
6
Actually I am not sure what is creating the file. I suspect a Progress routine though. When it detects an electronic payment in the group it prompts for a file name and creates a CSV type file (Generic format option).

Which prompts me to ask what people are doing "best practices" wise with the output file(s). I am thinking I will create a standard folder and retain the files with date based names. If the bank requires a standardized file name we'll send a renamed copy. Probably retain the files for a year.

-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Watkins, Norm
Sent: Thursday, October 22, 2009 3:39 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] NACHA A/P Processing



Todd, I'm beginning to set this up to. Are you creating the file that
goes to the bank with Crystal Reports? We're also on 6.1

Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830

For ITAR/EAR sensitive communications please e-mail me at:
norm.watkins@...<mailto:norm.watkins%40defense.us.schott.com>

This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.

Todd Caughey <caugheyt@...<mailto:caugheyt%40harveyvogel.com>>
Sent by: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
10/22/2009 02:21 PM
Please respond to
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>

To
"vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
cc

Subject
[Vantage] NACHA A/P Processing

I think this is mostly generic and not version specific but we are on
Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to
start processing A/P payment via electronic transfer. So far we have it
pretty much set except for fine tuning the file to be sent to the bank.
Biggest unresolved issue now is how to communicate remittance advice to
the vendor. It seems like it would be too much work to print the
electronic advices into one big PDF file and then split out them for
manually emailing.

He wants me to check the group and see how other people are handling
sending these to the vendor. Is there a more automated method? Especially
without having to buy anything else. Or at least is there a way to use
Adobe Acrobat's printer to print to PDF and create a new file for each
page? Also, for vendors with only one invoice on a check...do you even
send them a remittance advice? We have a quite a few occasional and
one-item vendors for whom knowing what to apply the payment to needs no
advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?

Just trying to streamline the process as much as possible so any hints and
tips would be much appreciated.

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]
7
Todd,
Our bank couldn't accept the "out of the box" Vantage CSV file and I am almost certain that one doesn't give any of the addenda records showing invoice # and amount paid - in fact, it really wasn't very complete at all :-( - so I hope it works okay for you.

We also used date-named files and retain them for 1 year.

Good luck!
Julie
Mercury Minnesota Inc.


----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com
Sent: Friday, October 23, 2009 7:56 AM
Subject: RE: [Vantage] NACHA A/P Processing


Actually I am not sure what is creating the file. I suspect a Progress routine though. When it detects an electronic payment in the group it prompts for a file name and creates a CSV type file (Generic format option).

Which prompts me to ask what people are doing "best practices" wise with the output file(s). I am thinking I will create a standard folder and retain the files with date based names. If the bank requires a standardized file name we'll send a renamed copy. Probably retain the files for a year.

-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Watkins, Norm
Sent: Thursday, October 22, 2009 3:39 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] NACHA A/P Processing

Todd, I'm beginning to set this up to. Are you creating the file that
goes to the bank with Crystal Reports? We're also on 6.1

Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830

For ITAR/EAR sensitive communications please e-mail me at:
norm.watkins@...<mailto:norm.watkins%40defense.us.schott.com>

This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.

Todd Caughey <caugheyt@...<mailto:caugheyt%40harveyvogel.com>>
Sent by: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
10/22/2009 02:21 PM
Please respond to
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>

To
"vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
cc

Subject
[Vantage] NACHA A/P Processing

I think this is mostly generic and not version specific but we are on
Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to
start processing A/P payment via electronic transfer. So far we have it
pretty much set except for fine tuning the file to be sent to the bank.
Biggest unresolved issue now is how to communicate remittance advice to
the vendor. It seems like it would be too much work to print the
electronic advices into one big PDF file and then split out them for
manually emailing.

He wants me to check the group and see how other people are handling
sending these to the vendor. Is there a more automated method? Especially
without having to buy anything else. Or at least is there a way to use
Adobe Acrobat's printer to print to PDF and create a new file for each
page? Also, for vendors with only one invoice on a check...do you even
send them a remittance advice? We have a quite a few occasional and
one-item vendors for whom knowing what to apply the payment to needs no
advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?

Just trying to streamline the process as much as possible so any hints and
tips would be much appreciated.

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]
8
Late follow-up. Julie, or anyone else creating the file to be sent to the bank, what are you using?

I just got the specs from our bank and they harken back to my punched card days. Several specific record formats each with exactly 94 characters and all the fields set as fixed lengths. Nothing at all like what Vantage 6.10 produces. I am not even sure if the Vantage text output file has all the data the bank requires.

I have a mandate to get a test file created by the end of this week. I think my first stab will be to modify the APRemit.rpt Crystal report. I can bolt in a bunch of constants like bank account and Fed Tax ID and probably get the summary in the Batch Control Record at the end. Anyone else out there try Crystal and run into any roadblocks from limited data in the DBF files?

Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Julie Lehmann
Sent: Friday, October 23, 2009 8:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] NACHA A/P Processing



Todd,
Our bank couldn't accept the "out of the box" Vantage CSV file and I am almost certain that one doesn't give any of the addenda records showing invoice # and amount paid - in fact, it really wasn't very complete at all :-( - so I hope it works okay for you.

We also used date-named files and retain them for 1 year.

Good luck!
Julie
Mercury Minnesota Inc.

----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Friday, October 23, 2009 7:56 AM
Subject: RE: [Vantage] NACHA A/P Processing

Actually I am not sure what is creating the file. I suspect a Progress routine though. When it detects an electronic payment in the group it prompts for a file name and creates a CSV type file (Generic format option).

Which prompts me to ask what people are doing "best practices" wise with the output file(s). I am thinking I will create a standard folder and retain the files with date based names. If the bank requires a standardized file name we'll send a renamed copy. Probably retain the files for a year.

-Todd C.

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Watkins, Norm
Sent: Thursday, October 22, 2009 3:39 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] NACHA A/P Processing

Todd, I'm beginning to set this up to. Are you creating the file that
goes to the bank with Crystal Reports? We're also on 6.1

Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830

For ITAR/EAR sensitive communications please e-mail me at:
norm.watkins@...<mailto:norm.watkins%40defense.us.schott.com><mailto:norm.watkins%40defense.us.schott.com>

This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.

Todd Caughey <caugheyt@...<mailto:caugheyt%40harveyvogel.com><mailto:caugheyt%40harveyvogel.com>>
Sent by: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
10/22/2009 02:21 PM
Please respond to
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>

To
"vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>>
cc

Subject
[Vantage] NACHA A/P Processing

I think this is mostly generic and not version specific but we are on
Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to
start processing A/P payment via electronic transfer. So far we have it
pretty much set except for fine tuning the file to be sent to the bank.
Biggest unresolved issue now is how to communicate remittance advice to
the vendor. It seems like it would be too much work to print the
electronic advices into one big PDF file and then split out them for
manually emailing.

He wants me to check the group and see how other people are handling
sending these to the vendor. Is there a more automated method? Especially
without having to buy anything else. Or at least is there a way to use
Adobe Acrobat's printer to print to PDF and create a new file for each
page? Also, for vendors with only one invoice on a check...do you even
send them a remittance advice? We have a quite a few occasional and
one-item vendors for whom knowing what to apply the payment to needs no
advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?

Just trying to streamline the process as much as possible so any hints and
tips would be much appreciated.

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]





[Non-text portions of this message have been removed]
9
Todd,
Vantage 6.1 will not give you the output that you can use, but do you know if the format is CTX? We started with a CCD, but had to change it to a CTX format for our bank. We actually had a custom program written to create that file. However, it would have been a nightmare, if I hadn't been so familiar with the file type from our previous software to kind of walk the programmer through it. I can certainly send you an example for you to try to copy (if you'll be using CTX). It's nearly impossible to follow the ACH rule book and get the format right. But with an example, it probably wouldn't be that difficult.

Let me know if you'd like an example to go by & overall I'd probably beg for an extension!

Julie
Mercury Minnesota Inc.




----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com
Sent: Tuesday, November 17, 2009 2:58 PM
Subject: RE: [Vantage] NACHA A/P Processing - Followup



Late follow-up. Julie, or anyone else creating the file to be sent to the bank, what are you using?

I just got the specs from our bank and they harken back to my punched card days. Several specific record formats each with exactly 94 characters and all the fields set as fixed lengths. Nothing at all like what Vantage 6.10 produces. I am not even sure if the Vantage text output file has all the data the bank requires.

I have a mandate to get a test file created by the end of this week. I think my first stab will be to modify the APRemit.rpt Crystal report. I can bolt in a bunch of constants like bank account and Fed Tax ID and probably get the summary in the Batch Control Record at the end. Anyone else out there try Crystal and run into any roadblocks from limited data in the DBF files?

Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Julie Lehmann
Sent: Friday, October 23, 2009 8:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] NACHA A/P Processing

Todd,
Our bank couldn't accept the "out of the box" Vantage CSV file and I am almost certain that one doesn't give any of the addenda records showing invoice # and amount paid - in fact, it really wasn't very complete at all :-( - so I hope it works okay for you.

We also used date-named files and retain them for 1 year.

Good luck!
Julie
Mercury Minnesota Inc.

----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Friday, October 23, 2009 7:56 AM
Subject: RE: [Vantage] NACHA A/P Processing

Actually I am not sure what is creating the file. I suspect a Progress routine though. When it detects an electronic payment in the group it prompts for a file name and creates a CSV type file (Generic format option).

Which prompts me to ask what people are doing "best practices" wise with the output file(s). I am thinking I will create a standard folder and retain the files with date based names. If the bank requires a standardized file name we'll send a renamed copy. Probably retain the files for a year.

-Todd C.

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Watkins, Norm
Sent: Thursday, October 22, 2009 3:39 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] NACHA A/P Processing

Todd, I'm beginning to set this up to. Are you creating the file that
goes to the bank with Crystal Reports? We're also on 6.1

Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830

For ITAR/EAR sensitive communications please e-mail me at:
norm.watkins@...<mailto:norm.watkins%40defense.us.schott.com><mailto:norm.watkins%40defense.us.schott.com>

This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.

Todd Caughey <caugheyt@...<mailto:caugheyt%40harveyvogel.com><mailto:caugheyt%40harveyvogel.com>>
Sent by: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
10/22/2009 02:21 PM
Please respond to
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>

To
"vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>>
cc

Subject
[Vantage] NACHA A/P Processing

I think this is mostly generic and not version specific but we are on
Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to
start processing A/P payment via electronic transfer. So far we have it
pretty much set except for fine tuning the file to be sent to the bank.
Biggest unresolved issue now is how to communicate remittance advice to
the vendor. It seems like it would be too much work to print the
electronic advices into one big PDF file and then split out them for
manually emailing.

He wants me to check the group and see how other people are handling
sending these to the vendor. Is there a more automated method? Especially
without having to buy anything else. Or at least is there a way to use
Adobe Acrobat's printer to print to PDF and create a new file for each
page? Also, for vendors with only one invoice on a check...do you even
send them a remittance advice? We have a quite a few occasional and
one-item vendors for whom knowing what to apply the payment to needs no
advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?

Just trying to streamline the process as much as possible so any hints and
tips would be much appreciated.

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]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
10
It seems to be CCD but shows options for the 'Standard Entry Class' of PPD, CCD+ and CTX but never describes them. The last page of their document is a raw dump and the example uses PPD. Then again the example is clearly for payroll and not paying various vendors so I am not sure what the difference is.

I'll probably take a wile stab with the Crystal version and use PPD and then let the bank clarify things when it does not work.

Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Julie Lehmann
Sent: Tuesday, November 17, 2009 3:31 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] NACHA A/P Processing - Followup



Todd,
Vantage 6.1 will not give you the output that you can use, but do you know if the format is CTX? We started with a CCD, but had to change it to a CTX format for our bank. We actually had a custom program written to create that file. However, it would have been a nightmare, if I hadn't been so familiar with the file type from our previous software to kind of walk the programmer through it. I can certainly send you an example for you to try to copy (if you'll be using CTX). It's nearly impossible to follow the ACH rule book and get the format right. But with an example, it probably wouldn't be that difficult.

Let me know if you'd like an example to go by & overall I'd probably beg for an extension!

Julie
Mercury Minnesota Inc.

----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Tuesday, November 17, 2009 2:58 PM
Subject: RE: [Vantage] NACHA A/P Processing - Followup

Late follow-up. Julie, or anyone else creating the file to be sent to the bank, what are you using?

I just got the specs from our bank and they harken back to my punched card days. Several specific record formats each with exactly 94 characters and all the fields set as fixed lengths. Nothing at all like what Vantage 6.10 produces. I am not even sure if the Vantage text output file has all the data the bank requires.

I have a mandate to get a test file created by the end of this week. I think my first stab will be to modify the APRemit.rpt Crystal report. I can bolt in a bunch of constants like bank account and Fed Tax ID and probably get the summary in the Batch Control Record at the end. Anyone else out there try Crystal and run into any roadblocks from limited data in the DBF files?

Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Julie Lehmann
Sent: Friday, October 23, 2009 8:49 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] NACHA A/P Processing

Todd,
Our bank couldn't accept the "out of the box" Vantage CSV file and I am almost certain that one doesn't give any of the addenda records showing invoice # and amount paid - in fact, it really wasn't very complete at all :-( - so I hope it works okay for you.

We also used date-named files and retain them for 1 year.

Good luck!
Julie
Mercury Minnesota Inc.

----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Sent: Friday, October 23, 2009 7:56 AM
Subject: RE: [Vantage] NACHA A/P Processing

Actually I am not sure what is creating the file. I suspect a Progress routine though. When it detects an electronic payment in the group it prompts for a file name and creates a CSV type file (Generic format option).

Which prompts me to ask what people are doing "best practices" wise with the output file(s). I am thinking I will create a standard folder and retain the files with date based names. If the bank requires a standardized file name we'll send a renamed copy. Probably retain the files for a year.

-Todd C.

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Watkins, Norm
Sent: Thursday, October 22, 2009 3:39 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] NACHA A/P Processing

Todd, I'm beginning to set this up to. Are you creating the file that
goes to the bank with Crystal Reports? We're also on 6.1

Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830

For ITAR/EAR sensitive communications please e-mail me at:
norm.watkins@...<mailto:norm.watkins%40defense.us.schott.com><mailto:norm.watkins%40defense.us.schott.com><mailto:norm.watkins%40defense.us.schott.com>

This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.

Todd Caughey <caugheyt@...<mailto:caugheyt%40harveyvogel.com><mailto:caugheyt%40harveyvogel.com><mailto:caugheyt%40harveyvogel.com>>
Sent by: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
10/22/2009 02:21 PM
Please respond to
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>

To
"vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>>
cc

Subject
[Vantage] NACHA A/P Processing

I think this is mostly generic and not version specific but we are on
Vantage 6.10 in case it matters. My boss, the Chief Bean Counter, wants to
start processing A/P payment via electronic transfer. So far we have it
pretty much set except for fine tuning the file to be sent to the bank.
Biggest unresolved issue now is how to communicate remittance advice to
the vendor. It seems like it would be too much work to print the
electronic advices into one big PDF file and then split out them for
manually emailing.

He wants me to check the group and see how other people are handling
sending these to the vendor. Is there a more automated method? Especially
without having to buy anything else. Or at least is there a way to use
Adobe Acrobat's printer to print to PDF and create a new file for each
page? Also, for vendors with only one invoice on a check...do you even
send them a remittance advice? We have a quite a few occasional and
one-item vendors for whom knowing what to apply the payment to needs no
advice. Perhaps some tricks within Crystal Reports in APREMIT.RPT?

Just trying to streamline the process as much as possible so any hints and
tips would be much appreciated.

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]

[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]