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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payroll Information On...
Microsoft Dynamics GP (Archived)

Payroll Information On Detailed Trial Balance

(0) ShareShare
ReportReport
Posted on by Matafwali 310

What settings am I supposed to have in place to ensure that payroll-related transactions such as employee names and each payroll transaction is reflected on the Trial Balance. Currently we see all transactions, but there are no employee names associated with those transactions.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Hi,

    I don't think Trial Balance Temp table is carrying Employee Name field. If you want you need to do VBA coding to pull those information from UPR30401 table.

    In Payroll -->Report-->History-->Distribution BreakDown History is available.

    Let me know how it goes.

    Thanks

    Sandip

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    In the GL transaction table there are field names for originating master ID and name. Are you saying those fields are blank? If not, you will need to modify the report to include those fields.

  • Matafwali Profile Picture
    Matafwali 310 on at

    Thank you very much.  I'm not good at VBA coding but I will have to figure it out real fast. But thank you for the payroll report advice. It's much closer to where I need to be.

    Thanks,

    David

  • Matafwali Profile Picture
    Matafwali 310 on at

    Yes Richard, those two fields are blank. Is that what I need to link up with the UPR30401 table as suggested by Sandip?

    Thanks,

    David

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    If those two fields had values you would not need the link the Sandip is suggesting. The question now is why are they blank? They simply hold the employid ID and employee name. Under Tools->Setup->Posting->Posting->Payroll do you post by transaction or by batch? You need to post by Transaction to get that detail into the ledger records.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Richard,

    We do post by Trsansaction but in GL20000 originating master ID and name is blank. It populate those field only when Payroll Transaction get voided.

    Thanks

    Sandip

  • Community Member Profile Picture
    Community Member on at

    Look at your settings under Tools>Setup>Posting>Posting

    For your payroll options, make sure that for the Payroll series, your option shows 'All'

    Perhaps just the 'Void Checks' option was chosen

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Since you cannot void checks in a batch, they get voided as on line transactions so they occur individually.  Definitely check the posting status and look at either All or Computer checks to make sure you are posting payroll by transactions.

  • Verified answer
    Matafwali Profile Picture
    Matafwali 310 on at

    Thank you very much Richard. It worked like a charm.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans