Notifications
Announcements
No record found.
Which Tables are needs to be joined . I need to get Total no o entries entered by each user . Is that possible . Please comment.
*This post is locked for comments
Hello Rinson
What type of transactions are you looking for , Sub ledger or general ledger ?
Does it make sense enough for you to count the number of journal entries on the GL; considering it as the main source for all the sub ledger entries ?
Your feedback is highly appreciated,
For General Ledger only . I have this column USWHPSTD from GL20000 and GL30000 . This column refers to "USER WHO POSTED" . Is it possible to get more details like "all the users involved in the entry". I need to count all the entries done by individual users for each . It is fine if it is available GLwise. Lets say the purpose like, I want to pay the users according to the effort ( entries ) they made. ( I already have Activity Tracking )
I would think you would want to take a look at Audit Trails. There will be associated overhead, but you would be able to report on the users editing transactions, not just posting them.
Thank You . I will check Audit trails .
Activity Tracking can cover this request, you need to activate this to be able to get User who entered the transaction.
Yes Activity Tracking needs to be enabled to see each users work and time. Thank you for the response..
Hope the below link helps to give the data that you are looking for :
victoriayudin.com/.../sql-view-for-all-posted-gl-transactions-in-dynamics-gp
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
