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) / 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi, the Dynamics GP EFT for Payables module may be what you need.

    However it is a specific US and Canada module i.e. if you have a UK & Ireland install of GP, you will not be able to licence the software without asking Microsoft to make an exception in your case and grant you access to the module. I have been able to do this successfully in the past for customers. There was talk that all modules would be available worldwide, but I don't think this has happened yet.

    The advantages are that it is a core GP module. I have used it here in Ireland and in the UK and elsewhere to create EFT files for a variety of banks. The EFT file setup / configuration area is very good and allows you to create EFT files to spec. And it follows the normal automatic cheque run procedures in GP - except you get an EFT file at the end instead of a cheque.

    Best regards,

     

  • Ashish Pandya Profile Picture
    Ashish Pandya 750 on at

    Hi,

    Thanks for your response, do you have any guideline on how to get that module for trial before contacting local parter source? What I need is, to satisfy our finance within our strict audit rules & then to make it officially installed.

  • Community Member Profile Picture
    Community Member on at

    Hi Ashish,

    You can't really get the module 'on trial'. I would suggest you install a seperate evaluation copy of GP and select US as the location during the install. Choose the EFT for Payables option during the application install. Install the lesson company.

    You should now be able to access the EFT for payables module. It is likely that there won't be a default EFT file format that will meet the needs of your bank (If its a UK bank). However you should be able to create a file format using the GP EFT File Setup tools.

    Installing an evaluation copy won't tell you what you need though. The software works in that it gathers payments that need to be made through EFT and includes these in a file for export to your bank. The only way you are going to know for sure if it is what you need is by exporting a test EFT file and sending it to your bank for evaluation. If they accept it then you're good to go. I have yet to find a bank whose EFT format cannot be accommodated using the GP EFT for payables module.

    Which bank / banks are you dealing with?

     Best regards,

  • Ashish Pandya Profile Picture
    Ashish Pandya 750 on at

    Hi, Ian

    Thanks so much for quick come back. Well, surprisingly I managed to see EFT for Payables even in UK instance. I can see Cards>Financials>Chequebook>EFT & also Purchasing>Creditors>Address>EFT. Even for EFT File Format Maintenance via Cards>Financials>Chequebook>Payables Options & File Formats.

    Our current scenario is, we have piece of codes which exports text file in Albany BACs format when actual cheque batch gets posted, then Albany processes this file for final payout. Our aim is, if at any ease we can get rid of this hardcode customization which can be less hassels in any migration. The step forward, anyway we can bypass Albany so as it can be transferred to banks straight from GP (but this does not seem a possibility from microsoft in near future)

    Have you ever been to these issues before?

    Regards

  • Community Member Profile Picture
    Community Member on at

    Hi Ashish, not sure I understand your problem. The EFT for Payables module for Dynamics GP is a core module and works fine with European banks (at least any I have created EFT file formats for anyway!!). You are right, anything you can do to replace bespoke software with standard GP functionality is a good move and makes upgrades that much simpler (and cheaper!).

    Why do you say its does not seem a possibility from Microsoft? What doesn't seem a possibility?

    I have customers who process their EFT file in GP, and them upload it to their banks on line system for processing. There is no direct link from GP to the bank. The EFT file gets generated, then they log on to their on line banking system, select to upload a file and select the file just created by GP.

    Hope this helps. Let me know if you need any more info.

    Best regards,

  • Jon Eastman Profile Picture
    Jon Eastman 170 on at

    We, at Touchstone, have an EFT module for GP (versions 8 and above) which includes over 25 pre-defined UK and european bank formats.

    Alternatively Nolans Computers have an Electronic payment module which allows you to define the output formats.

    Jon Eastman.

    Touchstone Computers.

  • Ashish Pandya Profile Picture
    Ashish Pandya 750 on at

    Hi, Ian 

    "You can't really get the module 'on trial'. I would suggest you install a seperate evaluation copy of GP and select US as the location during the install. Choose the EFT for Payables option during the application install. Install the lesson company"

    As you said this previously in your response, is there anyway I can change the installation via query or something from UK/ireland to US just to avoid rebuilding the test environment & to have evaluation of EFT payables? & then via add/remove to install EFT Payables features?

    Thanks

     

  • Community Member Profile Picture
    Community Member on at

    Hi Ashish, sorry for the late reply, checking through old emails and found your post updte.

    No, you can't really change the geographic location easily. Better to re-install.

    The good news is that EFT for Payables is generally available now, so you should be able to get it with a UK install. Out of interest, which bank are you dealing with?

    Also, reading back through your post, one thing you might need to wtch out for. It looks like you are using custom software to produce your BACS data. I presume that this utilises the Automatic Cheque Run functionality in GP. The EFT module also uses this functionality to gather information on what needs to b paid. The two may not exist that well together. I don't know, but its worth investigating before you go live just in case there is a conflict (assuming you want to use the BACS aswell as the EFT).

    Let me know how you get on anyway. If you need assistance off line, drop me an email. I deal quite a bit with UK companies using the EFT module so may be able to point you in the best direction.

    Ian.

  • Einar Simonarson Profile Picture
    Einar Simonarson 85 on at

    Hello Ian,

    Thanks for taking the time for your thoughful replies. It was an interesting read. I you seem to know all about this, I thought I'd check if you could help me.

    We are an organisation in Belgium, currently using Albany eBanking with our Dynamics GP 9. We are looking for a SEPA compliant solution that would be able to generate a payment file in SEPA XML (ISO 20022). Albany doesn't seem to have this on their plan. I guess that the EFT for Payables in Dynamics can only deliver flat files, so I am not sure if it is an option for us. Do you have any ideas?

     Thank you,

    Einar Simonarson

  • Community Member Profile Picture
    Community Member on at

    Hi Einar,

    Dynamics GP 10 EFT for Payables does have a standard format for ISO 20022 XML file. Not sure about GP 9, but I will endeavour to find out. If you want I can email you a sample of the XML file.

    Best regards,

    Ian.

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