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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Duplicate Entry in ACH file and direct deposit history tables

(0) ShareShare
ReportReport
Posted on by 5

For several pay periods a duplicate direct deposit is being created for the same employee in the ACH transmittal file and in the Direct Deposit ACH Items (DD10500) and the Direct Deposit Transaction History Detail (DD30101) tables  It is easily fixed by removing the duplicates.  I need to determine why this happens and fix the cause of the issue.

Only one employee is being effected by this and I cannot confirm, but it seems the issue began after upgrade  to Dynamics GP 18.3. There does not appear to be anything incorrect on the employee setup..

Has anyone ran into this and did you solve it?

Categories:
I have the same question (0)
  • Suggested answer
    Terry R Heley Profile Picture
    Microsoft Employee on at

    Hi Brian, this is not something we typically see, but there could be something stuck in the tables for this one employee.

    Here are the steps I would take.

    First in the generate ACH window on a week that is a non-payroll week, I would remove all "old" payroll files from this generate window.

    Since all the files have been sent to the bank, there is no reason to leave them hanging out there.  We have also found with larger payrolls that this could cause performance issues during the posting process, so I would just have 1 week back in this window.

    Next for this employee, take a screen shot of the current accounts you have active or want in there.

    Then delete all the employee accounts and save out of the window so it is blank.

    Now go back in and key your active accounts, run the next payroll and see if this now works for you.

    Thanks

    Terry Heley

    Microsoft

  • jechegoyen Profile Picture
    50 on at

    Hi Terry - I have a similar issue with a client, but I am not sure what you mean by by the next step. Are you referring to the bank accounts in the direct deposit window or some other account field? 

    Next for this employee, take a screen shot of the current accounts you have active or want in there.

    Then delete all the employee accounts and save out of the window so it is blank.

    Now go back in and key your active accounts, run the next payroll and see if this now works for you.

    Thank you,

    Jackie

  • HT-08101531-0 Profile Picture
    2 on at
    Hello - We are experiencing this same issue and do not have a solution after following the suggestions in these posts. Does anyone have a new solution they can share? Thanks!

    Update - 10.18.24
    I removed the old payroll files from the ACH window - that seemed to fix our issue!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 658

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 468 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 333 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans