Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Angela Harris]

Good evening,

we are using GP2013 SP1 where I have just installed the Safe Pay product. I created the confiutration file, however now my bank is requireing to have the full Vendor info on the file – which includes the address.

Is this even possible? I have tried different field options with no decent result.
If I can’t is there another product I can use?

Thanks so much!!
Super desperate currently 🙂

——————————
Angela Harris
Territorial Financial Systems Administrator
The Salvation Army-Central THQ
Hoffman Estates
——————————

[Barbara Gavron]

, in all my years being involved with GP, both as a user and a consultant I have never hear of this. The native GP SafePay configuration does not have this capability. ?But hope is not lost!

One thing you may consider is to create a smart list in the Purchasing >> Payables section that contains most of the information you need, in the correct order, and then export it into Excel.

• Start with the prefabricated smart list already there called Today’s Payments.
• Add the vendor address lines into it (Address 1, City, State, Zip)
• Restrict the query to just the one bank you need to send it to.
• Save the smart list with a name like “Smartlist-Bank Name”.  

Export the results to excel. Then you have 2 choices.

1) Add the other columns that ??the bank requires to this file in the order your bank wants to see it, save it down to a CSV or Text Tab Delimited (whichever you bank will accept) and upload that file. OR
2) Create the SafePay file from within GP and open it in excel, copy the address fields on to the associated lines, re-save it and send that file to the bank.

My fingers are crossed that one of these options will work for you. Keep us posted as to what your ultimate solution was so we can all learn from it.

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————
——————————————-

[David Feenstra]

Hi Angela,

We have had a number of requests from our clients where information is needed on either EFT or Safe Pay files that isn’t compatible with GP’s functionality.  In a number of cases, we have built automated routines that will export the day’s check run(s) through either a SQL job, batch file, or Powershell script.  That also gives us the ability to automatically upload the file to the bank if they have that functionality available. 

If you would like to discuss it further, please let me know. 

Thank you.

——————————
David Feenstra
dfeenstra@manersolutions.com
DIrector of Business Solutions and Technology
Maner Technology Solutions
Lansing, Mi
——————————
——————————————-

[Blair Christensen]

If you’re interested, we just completed a similar project – automated ACH/checks in file to bank.  It’s very possible to get the full address information.  I can give you the SQL scripts we use (check and ACH are different due to bank requirements) if you’re interested.  These are SQL scripts and we use a little Excel workbook with a couple of buttons to make it easy for our accountants to verify the outgoing information.

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise ID
——————————
——————————————-