Safe Pay File Date Append

(0) Share

Report

Posted on by Community Member

We are currently having to manually add a date to our positive pay files exported from Dynamics before uploading them to the bank. Is there a quick way to append a current date (YYYYMMDD) to the file name as it is exported?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Evan,

I fear that there is no such thing possible in GP.. The location where to export the EFT file is defined in : Financial >> Routines >> Financial >> Safe Pay >> Upload Maintenance

Unfortunately I don't think you're allowed to use any 'variables' in the path & file name, which leaves only with an option of post-processing, outside of GP.

I'd look for some resident application on the system that would pick the file in folder it was generated and append a date-time stamp to it..

If you own a product like SmartConnect, this is something that should be possible, but there are certainly other ways of doing it for less $$.

Hope this helps.

PS: you still could give it a try.. I don't have any EFT format setup right now, but try to add the %date% variable to your file name (i.e. EFT_export.txt would become EFT_Export_%date%.txt)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, Beat! That's kind of what I figured. We have a developer onsite that is looking at this as well - he may be able to create a quick program to append as it comes into the folder. I'll look at that route.

Was this reply helpful? Yes No
Suggested answer

MG-16101311-0 26,225 on at

Like (1)

Report

I already did this for you and you can download the code for free. Take a look at my article:

Microsoft Dexterity: Customizing Safe Pay file name

All I ask is that you do not take credit for the code or that it is not commercially distributed. Your developer can feel free to modify as he/she sees fit, but never with an intention to distribute commercially. Thanks in advance for accepting these conditions.

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Great job Mariano!

Going to download the code and play a bit with it in my 2016 test system :-)

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

Thank you Béat :-)

Are you coming to Tech Conference in Fargo? You are an MVP, so the partner restriction does not apply to you.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Excellent! I'm going to drop this into our test system and run it through the paces. And by the way - big fan of your blog! It's one of my go-to's when researching things.

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Mariano,

I'd have loved to.. but bad timing and limited company budget prevents this from happening this year again.. I've to make tough choices and GPUG Summit will be my only GoTo this year :-(.

Enjoy & see you in Nashville !

Was this reply helpful? Yes No