Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2010 Safe Pay - How Do You Get Check Totals in the Footer?

Posted on by 35

I'm new to GP and the person who set up Safe Pay is no longer with the company.

Our office is receiving notices from the bank that the footer totals in our Safe Pay file do not match the detail amounts when they are totaled. After reviewing the file, it appears to me that this problem occurs when there is a voided check in the Safe Pay file.  Currently, we have a Footer Account and Footer Transmission record with a Check Sum field defined as Check Amount, Currency - no $ / no decimal, and an Amount Type of Checks Total. This setting produces a footer total with the voided check subtracted from the total.  The bank requires that all checks be summed up as positive numbers.

Upon reading Chapter 4 Safe Pay Setup in the Electronic Banking Users Guide, it appears to me that the only way to get totals for all checks in a transmission is by selecting an Amount Format of Checks Total.  However, the documentation states this format applies to "an account **header** record line" or a "transmission **header** record line".

Is there a way to set up Safe Pay so that the total currency amount of all checks in the entire transmission appears in the Footer Account and Footer Transmission record lines?  The bank requires the totals at the bottom of the Safe Pay file.

*This post is locked for comments

  • Allan H Profile Picture
    Allan H 35 on at
    RE: GP 2010 Safe Pay - How Do You Get Check Totals in the Footer?

    Thanks Susan.  

    Getting the .cnk file from my VAR who in turn got it from Microsoft did the trick.  Seems like a lot of trouble to go through just to get Dynamics GP to perform a hash total.  Don't see why this isn't an option built into the application if there are banks requiring this type of calculation.

    Thanks again!

  • Verified answer
    sueconrod Profile Picture
    sueconrod 335 on at
    RE: GP 2010 Safe Pay - How Do You Get Check Totals in the Footer?

    Give your VAR a call.  There is a .cnk file available called sptotals.  This does a hash total for your checks.  I ran into this year's ago with Bank of America and they want a hash total of all the checks.  

    Here were the instructions when I got the file from Microsoft Dynamics Support years ago:

    1. Put this file in the local code directory of each workstation that uses SafePay. When launching, the client will be asked to "include new code now". Please say yes to this.

    2. Verify that there is a Net Total in the SafePay footer. This file will cause the Net Total to calculate an absolute value of checks plus voids.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans