web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • James McCullough Profile Picture
    James McCullough 371 on at
    RE: EFT File Format Setup ( Scotiabank Canada )

    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

  • Haydee Mirador Profile Picture
    Haydee Mirador 120 on at
    RE: EFT File Format Setup ( Scotiabank Canada )

    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

  • Haydee Mirador Profile Picture
    Haydee Mirador 120 on at
    RE: EFT File Format Setup ( Scotiabank Canada )

    Thanks!

  • juggernaut Profile Picture
    juggernaut 110 on at
    RE: EFT File Format Setup ( Scotiabank Canada )

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

  • Haydee Mirador Profile Picture
    Haydee Mirador 120 on at
    RE: EFT File Format Setup ( Scotiabank Canada )

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

    Thanks!

  • juggernaut Profile Picture
    juggernaut 110 on at
    RE: EFT File Format Setup ( Scotiabank Canada )

    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
    RE: EFT File Format Setup ( Scotiabank Canada )

    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

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans