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) / Payroll trx missing ca...
Microsoft Dynamics GP (Archived)

Payroll trx missing cash account sporadically

(0) ShareShare
ReportReport
Posted on by WindyCityGP 1,069

Sporadically, let's say every 3-5 months, when posting a huge payroll, the GL trx posting will fail.  Most of the time, the Cash account is missing for 1 individual (not always the same individual).  I've looked at the GL00105 and GL00100 and the index for the cash account is the same in both.  So far, it has only happened in 1 of our 4 companies.  Can anyone think of why this would occur?  My thought is the workstation that is doing the posting (GP is installed locally on all machines) has a brief communication issue with the SQL server.  I'm going to try recreating in an entirely separate environment and see if I can recreate.

*This post is locked for comments

I have the same question (0)
  • George_YYC Profile Picture
    George_YYC 175 on at
    RE: Payroll trx missing cash account sporadically

    Hello,

    How long does the process take?  It sounds like it could be a network issue.. are you running the DB in a virtual environment?

    As you mentioned, trying to create the issue in a different environment would be a good start.  Let us know what you find.

    George

  • WindyCityGP Profile Picture
    WindyCityGP 1,069 on at
    RE: Payroll trx missing cash account sporadically

    From Build to Post, it takes roughly an hour.  The server is a virtual server.  In the process of the restoring the database now...it will take a while.

  • Sherlene Sorenson Profile Picture
    Sherlene Sorenson 967 on at
    RE: Payroll trx missing cash account sporadically

    If the issue is occurring on different people, and not happening consistently when that same individual is paid again using the same paycode/department/position combination, I would first point toward a possible network disconnect also. Do you have any companion products that may be affecting this?

  • WindyCityGP Profile Picture
    WindyCityGP 1,069 on at
    RE: Payroll trx missing cash account sporadically

    I was able to recreate in an entirely separate environment.  I does not pull the account number for 1 deduction that has an amount of $.01, but then it entirely removes the credit to cash for the net pay for this 1 employee.  The deduction is setup in the Payroll Posting Accounts.  I'm going to restore again, and remove the payroll transactions for this 1 individual and see if it processes OK.  If it does, then I will create a separate batch with the one employee and manually enter the payroll transactions for them and see if I get the same results processing it with just the 1 employee in the batch.

    We do have a few 3rd parties, Mekorma, Greenshades, eOne Smartlist Builder and 1 custom Dexterity code (used to create a file with W2 info used at year end), so I doubt it would be related to those.

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

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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