Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Paying Vendors by Cred...
Microsoft Dynamics GP (Archived)

Paying Vendors by Credit Card utilizing Electronic Banking

(0) ShareShare
ReportReport
Posted on by Jimmy Dixon 100

Our Bank is offering us a service where we submit a file to them, and they will issue credit card payments directly to the vendor.

I have to submit to them a data file showing vendors, invoice numbers, amounts, etc.

In working through utilizing the EFT payment method, I just have a few problems.

In putting in the type of document that I am paying, it should be either an I for invoice, or C for Credit Memo.  All I am getting out of GP is a number.

I also have to submit a total record which is the total amount that is being submitted.  I can get total credits and total debits, but, not just a grand total.

Any suggestions, ideas?

*This post is locked for comments

  • deanne917 Profile Picture
    deanne917 2,035 on at
    RE: Paying Vendors by Credit Card utilizing Electronic Banking

    I am looking into this process as well.  The reason I'd rather not create the file via sql is because an EFT file has the history maintained in GP and I want the end-user to own this.  (I don't want IT to have to create this file every time AP does this process)

    Has this process ever been documented?  

    I would like to use the EFT file and then modify it per the vendor's specs.

  • deanne917 Profile Picture
    deanne917 2,035 on at
    RE: Paying Vendors by Credit Card utilizing Electronic Banking

    Has anyone come up with a solution for this?  

  • Jimmy Dixon Profile Picture
    Jimmy Dixon 100 on at
    RE: Paying Vendors by Credit Card utilizing Electronic Banking

    The project was dropped.  Our support group stated that we could look into using SSRS (SQL Server Reporting Services) to create the file, but, we didn't pursue the issue.

  • Jennifer Rera Profile Picture
    Jennifer Rera on at
    RE: Paying Vendors by Credit Card utilizing Electronic Banking

    Jimmy,

    Were you ever able to accomplish this?  Our credit card company offers a service that will allow us to pay our vendors via credit card as well.  I need to send the bank a file containing the vendors, invoices, etc for each credit card payment run.  If you were able to accomplish this, how did you signify that a vendor was going to be paid via credit card?  The users do not want to have to rely on memory to determine whether or not a vendor should be paid via credit card or some other method.  How did you end up creating the files to send to the bank as well?

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Paying Vendors by Credit Card utilizing Electronic Banking

    Have you considered just creating the file using SQL rather than going through EFT? You could build in the necessary translations from GP's numbers to the characters that the bank requires.

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