Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Duplicate Entry in ACH file and direct deposit history tables

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?

  • jechegoyen Profile Picture
    jechegoyen 50 on at
    RE: Duplicate Entry in ACH file and direct deposit history tables

    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

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: Duplicate Entry in ACH file and direct deposit history tables

    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

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans