If you’ve explored or implemented electronic payment options within Dynamics GP, you’ve probably heard of SafePay, aka Positive Pay. This is a module within GP that allows you to create an electronic file of the transactions entered into the system over a given period of time. This file is then sent to the bank to compare against when the bank receives a claim against that account. This provides additional security for ensuring that only valid payments are made from your account.
The setup of SafePay can be somewhat tricky, so I’ve attached below two articles to assist with this process. One of them is written by Microsoft, and contains the official documented steps. The latter is written by a KTL consultant and goes into a little more depth on the subject, complete with screenshots:
- https://support.microsoft.com/en-us/help/850752/steps-to-set-up-the-safepay-configurator-in-microsoft-dynamics-gp
- https://www.ktlsolutions.com/erp/3-safepay-setup-tips-for-microsoft-dynamics-gp/
Sometimes, even after a lengthy and thorough setup, you will find that no transactions populate into the SafePay Transactions Upload window. Typically, this is related to the specific setup in the checkbook or in the dates. Here’s another KB article from Microsoft which addresses this problem.
If the steps in this article do not address the issue, below is a script provided by one of the fantastic Sr. Support Engineers on the Microsoft Support team that may help with the issue. You can change the 3 variables (2 dates and your checkbook) to the appropriate values that you have in your upload window. This will tell you if the problem is likely with your dates or with the actual data. If this script returns data when the window does not, then there is probably a bigger issue, and you will have to troubleshoot further to find out why the data isn’t populating. If the script does not return data same as the window, you’ll want to adjust the dates again to make sure to include the recently posted checks.
Declare
@LastUploadDate datetime,
@UploadCutoffDate datetime,
@CheckBook varchar(50)
Set @LastUploadDate = ‘2017-04-12 00:00:00.000’ –Set the Last Upload Date here
Set @UploadCutoffDate = ‘2017-04-12 00:00:00.000’ –Set the Upload Cutoff Date here
Set @CheckBook = ‘CHECKBOOK NAME’ –Set the checkbook ID from the Safe Pay Bank Link Maintenance window
select * from PM30200 where
DOCDATE >= @LastUploadDate and
DOCDATE <= @UploadCutoffDate and
VCHRNMBR in (select CNTRLNUM from PM00400 where CHEKBKID in (@CheckBook)) and
DOCNUMBR not in (select CMTrxNum from ME123504 where CHEKBKID in (@CheckBook))
UNION
select * from PM20000 where
DOCDATE >= @LastUploadDate and
DOCDATE <= @UploadCutoffDate and
VCHRNMBR in (select CNTRLNUM from PM00400 where CHEKBKID in (@CheckBook)) and
DOCNUMBR not in (select CMTrxNum from ME123504 where CHEKBKID in (@CheckBook))
If you have issues with your SafePay setup in Microsoft Dynamics, or if you have any questions on the information in this article, please don’t hesitate to contact me at jnorberg@ktlsolutions.com. I look forward to hearing from you!
