web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / EFT File Format Setup ...
Microsoft Dynamics GP (Archived)

EFT File Format Setup ( Scotiabank Canada )

(0) ShareShare
ReportReport
Posted on by juggernaut 110

Hi there,

I am attempting to set up the EFT File Format for Scotiabank and am having some issues Has anyone set this up for Scotiabank before?

The below link shows the Field Names etc

onlinecustomersupport.scotiabank.com/index.jsp

But I have no idea how to add in Field 2, 8, 16, 17 and 18. They are listed as Alpha Numeric, but there is no option for this in Dynamics GP.

Also, Dynamics GP allows left and right justification, but in the above form, some are listed as N/A

Any help would be appreciated

Thanks

Kieran

*This post is locked for comments

I have the same question (0)
  • Haydee Mirador Profile Picture
    Haydee Mirador 120 on at

    Hi,

    Were you able to setup the EFT File Format for Scotiabank in Canadian Currency?

    What format type did you use? Are you using GP2010?

    I'll be implementing EFT for Scotiabank too.

    Thanks,

    Haydee

  • juggernaut Profile Picture
    juggernaut 110 on at

    Yes I have successfully completed the setup in GP 2010 in CAD. I got the EFT file format from our account manager.

    What specific parts do you require help with?

  • Haydee Mirador Profile Picture
    Haydee Mirador 120 on at

    I just want to know what Format Type was used in EFT File Format Maintenance screen.

    Thanks!

  • juggernaut Profile Picture
    juggernaut 110 on at

    Format Type is 'User Defined', File Type is 'Flat File'

  • Haydee Mirador Profile Picture
    Haydee Mirador 120 on at

    Thanks!

  • Haydee Mirador Profile Picture
    Haydee Mirador 120 on at

    Hi Kieran,

    Did you use the 1464 Byte Transmission File Layout?

    Is it possible if you can provide the EFT Format Setup Report from GP?

    I am wondering how you setup the date as julian format.

    Appreciate your help.

    Thanks,

    Haydee

  • James McCullough Profile Picture
    James McCullough 379 on at

    Hi Haydee:

    1464 (Otherwise known as CPA Standard 005) is the National Bank of Canada file format in GP.  Just make sure that you change the constants in the file - specifically field 6 of the "File Header" >> "Addressee" to be your bank's given number.

    -J

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans