Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Positive Pay report

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Positive Pay report

    Perry, I would love to have the setup for Chase that you mention.

    greg.waddell@jbsunited.com

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Positive Pay report

    Hello - Can you send me an email with your contact info and I would be happy to send you the PNC format.  My email address is perryk@tmgroupinc.com .

    Thanks - Perry K

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Positive Pay report

    Can I get the PNC format?  It would be appreciated

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Positive Pay report

    mbarton@americanshare.com  

    Thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Positive Pay report

    I do have the actual .txt file that you can import for Chase and you won't have to do the exercise of setting it up.

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    RE: Positive Pay report

    First check and make sure that you don't already own SafePay.  Go to About Great Plains >> Options and look and see if SafePay is checked off, or look at the document that had your registration keys.  It could be that you already own SafePay and don't have to purchase a thing, it all depends on when you bought the software and whether it was included or not.

    I have the Wells Fargo and we use Safe Pay.  We upload a file to Wells Fargo on a nightly basis.  So, if you send me your e-mail can send you the setup needed. 

     

    BTW, here is what we got from Wells Fargo:

     

    ACCOUNT RECONCILEMENT - ISSUE INPUT FILE   FORMAT - DATA TRANSMISSION
      (File sent to bank)
    Customer   Name       Account Number   Date  
           
           
    To   ensure accurate implementation and/or timely revision, please supply the   desired information and return to your Treasury Sales  
    Officer   within 10 days.  
                                   REQUIRED FILE   SPECIFICATIONS          
     
         
       File Type (check one)            
                               Record Length
               
             
             ASCII                       EBC DIC                                           80                                                                       
                                         
                   
       Data Field Content
           Character Only   All numeric fields are   Right Justified Zero Filled (RJ/ZF).      
               HEADER RECORD FORMAT
    The use of a Header   Record must precede all Detail Records for this and each subsequent account.
    On   stacked accounts Header Records are required and must precede all Detail   Records for this and each subsequent account.
           
             Position                                                        Field Description   Field Size                Type
           
                 01-20   RECONCILIATIONHEADER (literal)     20 Alpha  
               NC - 0001, FL - 0003,   SC - 0004, GA - 0005, VA - 0007,   MD - 0014      
               CT - 0020, CTZ (TX, TN, AL, MS) -   0028, MTZ - 0042, PTZ - 0044  
                 21-24   Bank Number          DE - 0049, DC - 0052,   PA, NY, NJ - 0075   04 Numeric (RJ/ZF)
         
                 25-37   Account Number       13 Numeric (RJ/ZF)
         
                 38-49   Total Dollar Amount of   File or all Zeros (without the decimal point)       12 Numeric (RJ/ZF)
         
                 50-54   Total Item Count of File   or all Zeros (without the commas)   05 Numeric (RJ/ZF)
         
                 55-80   Filler (check one)          
    zero
                                         
    blank 26 Alphanumeric
                               DETAIL RECORD All standards are   assumed unless otherwise indicated.    
                 Position                                                        Field Description         Max. Field Size    
    Std. Other                    
    Std.     Other
                   Type
           
    01-13   Account Number       13       n/a Numeric (RJ/ZF)
           
    14-23   Check Serial Number   10 Numeric (RJ/ZF)
                 
    24-33   Check Amount (without the decimal point)     10 Numeric (RJ/ZF)
         
    34-41   Issue Date   (YYYYMMDD-std.)       08 Numeric  
         
    42   Void Indicator (V-std.)                  Other (except X or -) 01       n/a Alphanumeric
         
    43-72   Additional Data (SSN,   payee name, etc.)     30 Alphanumeric
         
    73-80   Filler (same as above)       08 Alphanumeric
       To ensure the most expedient return of your reconcilement information, checks and bank statement, please transmit your input files
       immediately after checks are written.
    For technical      Format Approved:            
    assistance, please            ________________________________________________________________________________________ __________________________
    call your Customer          Customer Signature Date
    Service Representative            ________________________________________________________________________________________ __________________________
    at 1-800-222-3862,          Customer Technical Contact (please   print) Phone
    option 795.                  
    Bank Use: This customer-completed   form MUST accompany all profiles used in account set-up.
    revised   08-06-07
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Positive Pay report

    mbarton - Can you please send me your email address?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Positive Pay report

    Hi Perry -- Don't know if you still have this but I am looking for the Positive Pay format for Chase.  Thanks in advance for your help!

    Mary

  • Community Member Profile Picture
    Community Member Microsoft Employee 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

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

    Hi,

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

    Thanks

    Sandip

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans