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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to identify which ...
Finance | Project Operations, Human Resources, ...
Unanswered

How to identify which user entered a Payables Voucher (Not posted the Batch)

(0) ShareShare
ReportReport
Posted on by chuck_appelquist 5

I need to track user Productivity.

I want to do something like:

SELECT /USER/ , count(*) as Cntr 
FROM PM10000 -- Work / Un-posted Transactions

But there does not seem to be any user info in the Work table.

PM20000 -- Open/Posted Transactions   has the user who posted the batch not who entered the voucher.

Is there a way to see who entered the voucher?

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • chuck_appelquist Profile Picture
    chuck_appelquist 5 on at

    Thanks. That answered my question.

    Just wanted to make sure I did miss something.

    Chuck

  • Jeff Grant Profile Picture
    Jeff Grant on at

    Hello,

    You are correct that there isn't a created/saved field in the PM series tables to designate the creator of the document, only the posting user.  As such, you may want to develop a SQL trigger to update a separate shadow table when 'Save' is selected that would record such information at your discretion if needed for purposes of logging productivity.  I am not aware if such an item already exists in the partner channel but hopefully we will get additional recommendation based on your thread content.

    Best Regards,

    Jeff Grant

    Microsoft Dynamics GP Support

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

Season of Giving Solutions is Here!

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 December Top 10 Community Leaders!

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 324 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans