Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Safe Pay Setup (Vendor ID)

Posted on by Microsoft Employee

I have seen this question asked, but no answers have been given thus far.  I am setting up an EFT transmission to a new bank and they require Vendor ID.  In GP2016 R2, native Safe Pay only passes Vendor Short Name (Payee Name) and not Vendor ID.  Is there a way to add Vendor ID to the Safe Pay output file?

Also, what's up with the "Microsoft Dynamics GP Data" Field Format?  The Safe Pay User Guide says it's not used.  This would be a handy field to pull in additional information such as this and extender data...maybe it was a nice thought that got left to die?

Any guidance is appreciated.

*This post is locked for comments

  • Caye Solutions Profile Picture
    Caye Solutions 30 on at
    RE: Safe Pay Setup (Vendor ID)

    Hey Mariano, I just wanted to update you and say that I built a completely custom process for handling payment file building and transmission to the banks for EFT, Credit Card and Checks. It has been clicking right along for the last couple of years.

    Essentially, I built a separate database and used and Extender action to call a stored proc that builds the flat files for the financial institutions. Once the files are built, SQL sends an HTML formatted dbmail to the approvers that click a button to generate an approval. A "sentry" account (just an inbox that receives mail and has a mess of rules setup to handle the workflow) handles the approval workflow.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Safe Pay Setup (Vendor ID)

    Thanks!  We've decided to not use SafePay altogether.  I am hitting a different issue now whereas the batch file to create the flat files doesn't complete properly if launched from the GP Shortcut bar...but that's a different problem for a different post . :)

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Safe Pay Setup (Vendor ID)

    OMG! Not sure why I was thinking EFT. Effectively, the Vendor ID is not an option with Safe Pay.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Safe Pay Setup (Vendor ID)

    But...then we'd need to still generate the Positive Pay file for printed checks, which I'm not sure is available in conjunction with Generate EFT File.  

    I have emailed my VAR for assistance as well with some direction on this setup.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Safe Pay Setup (Vendor ID)

    Hey Mariano,

    Thank you for your quick reply.  

    It looks like you are in the setup for Purchasing > Transactions > Generate EFT File...more specifically Financial > Checkbook > [Select Checkbook] > EFT Bank > Payables Options > File Format

    Am I wrong to believe this setup is mutually exclusive to the Safe Pay file setup (Financial > Safe Pay > Configurator)?

    Maybe Generate EFT File is the way I should go instead as it seems to be much more flexible than Safe Pay?

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Safe Pay Setup (Vendor ID)

    You can certainly include the vendor ID as part of the Detail line. 

    EftVendor.png

    You need to make sure the field type is a Data Field and the Table Name is PM Vendor Master.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans