Microsoft Dynamics GP (Archived)

How to find or trace UserID who already input transaction on Transaction Entry

(0) Share

Report

Posted on by Dedy Alamsyah

510

Dear all Master !

Does anyone know how to trace what UserID who already input Transaction Entry?

or how to log the UserId who doing transaction on Transaction Entry on GP

Sorry for my poor english

Regard

Dedy

*This post is locked for comments

All responses (3)

Answers (0)

Richard Whaley 25,195 on at

Like (0)

Report

Re: How to find or trace UserID who already input transaction on Transaction Entry

Most of the transaction tables have a field for user ID. Typically, this is the last user to touch the record. If the transaction is posted, then the user that posted will have their id there, overwriting the ID of the person that entered the transaction.

The Sales Order Processing is different. There is a field called USER2ENT that records the ID of the user that entered the transaction and a field called PTDUSRID that shows the id of the user that posted the final invoice. This is in table SOP10100.
Community Member Microsoft Employee on at

Like (0)

Report

Re: How to find or trace UserID who already input transaction on Transaction Entry

Hi Dedy,

No problem. If the transaction was posted direct (ie was not saved to a batch), then the User ID of the person who posted it will usually appear in the Batch Number field on the transaction.

To track specific actions within the system (not just transaction posting), you should look at the audit trails functionality.
Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

Re: How to find or trace UserID who already input transaction on Transaction Entry

You can only see the user who posted a transaction, not the user who entered it, unless you have Activity Tracking enabled for transaction processing. To see the user who posted, go to the respective transactions SmartList and add the field "User who Posted'.