Here's an update for other Canadian Vantage Users...
Upon receipt of Julie's comments (Thanks Julie) I redirected my
efforts to create a crystal report (off the CheckHed table) that
generates either a domestic Canadian$ export file or a cross border
US$ export file. TD Canada Trust accepted both my test files, so I
don't need the delays or costs of custom programming. Now I can focus
on the other pieces of this project, such as controls, procedures and
getting bank account info from vendors.
Upon receipt of Julie's comments (Thanks Julie) I redirected my
efforts to create a crystal report (off the CheckHed table) that
generates either a domestic Canadian$ export file or a cross border
US$ export file. TD Canada Trust accepted both my test files, so I
don't need the delays or costs of custom programming. Now I can focus
on the other pieces of this project, such as controls, procedures and
getting bank account info from vendors.
--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@...> wrote:
>
> Steve:
> Our bank also requires a specified file format. We tried using the
CCD format (NACHA), but then because we had more addenda records (for
invoice information) then the CCD could handle - we had to switch to
the CTX format. We went thru Epicor's custom programming to create
the correct file format.
> It is working very well. (We're on 6.1)
> Good luck!
> Julie Lehmann
> Mercury Minnesota Inc.
>
> ----- Original Message -----
> From: Ashton, Steve
> To: vantage@yahoogroups.com
> Sent: Friday, July 06, 2007 12:49 PM
> Subject: [Vantage] A/P EFT Remittance
>
>
> I'm trying to implement A/P EFT in Vantage 6.00.
>
> Our bank insists on a file format that includes header and footer
lines,
> something that Bank Account's 3 electronic payment export formats
> (generic, BTL91 or Clieop03) do not provide.
>
> Is this a common issue in the US, or is it particular to Canadian
banks
> only?
>
> What are your methods of creating an acceptable output file?
>
> Steve Ashton
>
> Database Specialist
>
> Decoustics Limited
>
> 65 Disco Road
>
> Toronto, Ontario
>
> Canada M9W 1M2
>
> T (416) 675-3983 x336
>
> F (416) 679-8838
>
> sashton@... <mailto:sashton@...>
>
> Steve.Ashton2@...
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>