You’re offline. This is a read only version of the page.
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?
Thanks. That answered my question.
Just wanted to make sure I did miss something.
Chuck
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,900
Super User 2024 Season 2
#2
Martin Dráb
229,275
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (