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) / direct deposit bank nu...
Microsoft Dynamics GP (Archived)

direct deposit bank number (routing number)

(0) ShareShare
ReportReport
Posted on by Q Factor 107

I have a customer using payroll direct deposit. One of their employees has a routing number (bank number) that begins with zero. When they process the ach file, the preceding zero is stripped off and they have to manually fix the file to add the missing zero.  Is there any way to make GP handle the routing number as a string field so the zero won't be removed?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Q Factor Profile Picture
    Q Factor 107 on at
    Re: direct deposit bank number (routing number)

    Payroll's ACH is all preconfigured and there is no way to change the format that I can determine. At any rate, I believe this issue was user error, as she changed the employee's bank number to add the preceding zero AFTER she had run the payroll. I suspect it will work fine going forward.

  • Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: direct deposit bank number (routing number)

    We operate in GP 2010 sp2.  While we do not work with payroll, we do utilize ACH payments to vendors which is a file submitted to our bank via an upload.  The bank then makes the payments out of our account based on the data provided.  That data is put into a specified format from our bank.  My assumption is your organization's issue lies with the format setup for ACH payments (but maybe the payroll side is very different).  For vendor ACH, the format is found at the checkbook level under Financial>Checkbook>EFT Bank>Payables Options 9the window is called Checkbook EFT Payables Options.  On this screen, at the top right is a field File Format.  By clicking on the blue arrow or using the magnifying glass to choose the format used for the payroll, it will launch/open the EFT File Format Maintenance window.  This is where the design/setup is which puts GP data into our bank's specified format in order for the bank to convert it and make the payments as instructed.  One of these fields references the ABA number for the vendor (I assume it would work similar for payroll, but I cannot be certain).

    Best regards,

    Dale

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans