Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP UK EFT - BACs
Microsoft Dynamics GP (Archived)

Dynamics GP UK EFT - BACs

(0) ShareShare
ReportReport
Posted on by Ashish Pandya 750

We are on GP 9.0 & using Albany as BACs payment solutions which is an approved provider for UK BACS payment services. Our Cheque batch posting module is a modified window with custom codes which generates text file for BACS & also posts batch. Now our company has requirement to setup another non-BACS payment, is there any solution readily available via GP inbuilt such as EFT or SafePay or any other provider offer such functionality apart from Albany in UK?

 Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP UK EFT - BACs

    Hey, not sure if you're still looking but I've actually created these and a few other UK based files. You can find them on the prospr store here.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP UK EFT - BACs

    Hi All,

    I am aware this is quite an old topic, but we are also currently in process of setting up EFT in GP for UK HSBC, which uses BACS STD 18.

    Does anyone have a file that could share.

    Any help would be much appreciated.

    Many thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP UK EFT - BACs

    Ian,

    do you have a suggestion on what format to use/modify to meet UK banking requirments.  I have a client that will be processing EFT throught Barclays and I can't seem to find the appropriate format.  do you suggest sthe ISO format?    I tried the user defined format and it will not pull from the open file.  what am I doing wrong?

    thanks

    Carolyn

  • SimonLaw99 Profile Picture
    SimonLaw99 120 on at
    RE: Dynamics GP UK EFT - BACs

    Ian, you mention that you have partnered up with an EFT processor who takes files from GP and generates the required SEPA formats. Please can you introduce me to this company.

  • Jon Eastman Profile Picture
    Jon Eastman 170 on at
    RE: Dynamics GP UK EFT - BACs

    Hi Denise,

    It varies from bank to bank but in most cases we would use a unique incremental number stored in DUOS.  In turn we expose this using VBA\modifier on the chequebook bank maintenance window.

    Jon.

  • Denise Fuel Profile Picture
    Denise Fuel 5 on at
    RE: Dynamics GP UK EFT - BACs

    Jon

    You seem to have a working BACS std 18 file format.  I'm wondering which Dynamics GP fields you used for Header Label 1- "Serial Number" &  Batch Header - "File Number" ?  I'm having trouble identifying unique fields in GP that can populate this information.  Any help or suggestions your can provide will be greatly appreciated.

    thank you,

    Denise

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP UK EFT - BACs

    Hi Brian, Yes - we have. Not through GP though. It can be done in GP of course but the authorisation effort required is uneconomical [certainly for us!!]. We have partnered up with an EFT processor who takes files from GP and generates the required SEPA formats. Including Mandate management, issuing UMR's etc - the lot. We can also convert existing bank data etc. The benefits to GP users is that its a much reduced cost and you are guaranteed the SEPA files will be compliant - I've seen examples of where institutions interpret the XML nodes differently etc.

    Ian.

  • Brian P Connell Profile Picture
    Brian P Connell 859 on at
    RE: Dynamics GP UK EFT - BACs

    Has anyone resolved the bank format file for sepa compliant payments ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP UK EFT - BACs

    Hi Ian,

    We are based in Australia. I have a client who is expending into countries Germany, Thailand and South Africa. The banks they are using are Deutsche Bank, Kasikorn Bank and Nedbank respectively in these conuntries.

    I understand that Deutsche Bank can accept SEPA file format. I think the standard GP EFT payment module should be able to generate a SEPA file, right?

    Do you know if the standard GP EFT payment module can generate EFT files for Kasikorn Bank and Dedbank?

    Thanks for the information in advance.

    Kind Regards,

    Susan

  • Zheng Profile Picture
    Zheng 5 on at
    RE: Dynamics GP UK EFT - BACs

    Hi André, can you share this spreadsheet with me and send it  to zhengzeng@outlook.com please?

    Thanks very much

    Zheng

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans