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

Notifications

Announcements

No record found.

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

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…

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

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans