web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Positive Pay report
Microsoft Dynamics GP (Archived)

Positive Pay report

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I was requested to pull some check information (routing number, account number, serial number, issue date, amount, and payee name) to create a positive pay report to send to Wells Fargo. Is there a GP contact that I could work with to help me figure out what tables I need to look in for this information. I am new to the databases and am having a tough time navigating through the tables. Perhaps someone can contact me through the forums or send me a contact I can work with further?

Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: Positive Pay report

    You can use use Electronic Banking Module and generate file as per given format.

    Zubair

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: Positive Pay report

    Do you have the information inside GP? And what modules do they use for having the needed fields?

    routing number,

    account number,

    serial number,

    issue date,

    amount,

    payee name

  • Community Member Profile Picture
    Community Member on at
    Re: Positive Pay report

    I think is the information you are looking for..

    We are looking at the Accounts Payable module.

    Thinking more on it, the routing number and the account numbers will actually be manually entered. It will the same routing for all the accounts we are trying to pull and I have a list of the account numbers we are looking at. So I would just be trying to set up a query to find:

    serial number:  Check Number

    issue date:        Check Date

    amount:             Check Amount

    payee name:     Vendor Check Name

    I hope this clarifies it more

  • Community Member Profile Picture
    Community Member on at
    Re: Positive Pay report

    Try following

    SELECT     [Vendor ID], [Document Date] AS [Check Date], [Document Number] AS [Check Number], [Document Type], [Document Amount], [Vendor Check Name],

                         [Vendor Check Name from Vendor Master]

    FROM         PayablesTransactions

    WHERE     ([Document Type] = 'Payment')

  • Community Member Profile Picture
    Community Member on at
    Re: Positive Pay report

    Thanks for the suggestion, but I'm not sure PayablesTransactions is quite what I'm looking for. From what i can tell, I need to qualify off of CM Checkbook Master (CM00100) or Bank Master (SY04100) to find my routing number. Neither of these are used in the PayablesTransactions view. I will try to work off this, but please let me know if you have any more suggestions.

    Thanks!

  • Community Member Profile Picture
    Community Member on at
    Re: Positive Pay report

    Sir, Dynamics GP has a module you need to purchase called Safe Pay. Banks call it Positive Pay.  How it works is, after you install Safe Pay it will create a text file from a check run. You then need to upload that file to the bank but of course you need to establish a Positive Pay service with the bank. They will provide you with an FTP or internet address to upload the file.  However, banks do not take plain text files.  Most banks will require you to encrypt the file first.  Last time I did this we use PGP and exchanged public keys with the bank.  

    In Summary here is what you  need to do:

    Purchase, install & test GP Safe Pay

    Find out what encryption your bank requires

    Encrypt the text file Safe Pay creates

    Transfer the encrypted file to the bank’s address they provide you.

  • Royce Holden Profile Picture
    Royce Holden 105 on at
    Re: Positive Pay report

    I have the same question, but for Dynamics SL.  Is it really necessary to purchase a product for a simple report each month?  How about creating a report off the query above and making two static fields for bank account number and routing number?  Can anyone show us how to do that?

  • Community Member Profile Picture
    Community Member on at
    Re: Positive Pay report

    The Safe Pay module in GP does the job.  You will spend more time and effort trying to create this report in a reporting tool then the cost and setup of the module.  I would check with your partner as well.  They may already have the Wells Fargo format and you can import the setup into GP.  I have 6 bank setups that I give to my clients if the need it at no charge.  I don't have the Wells Fargo one or I would send it to you.

    Thanks - Perry K

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at
    Re: Positive Pay report

    Hi,

    Do we have Postive Pay format for "FORST Bank"?

    Thanks

    Sandip

  • Community Member Profile Picture
    Community Member on at
    Re: Positive Pay report

    Sorry.  I do not have FORST Bank.  I do have Chase, Comerica, Fifth Third, National City, and PNC if anyone needs them.

    Thanks,

    Perry K

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans