How To Find Out Who Entered a Transaction in Microsoft Dynamics GP

Short of purchasing and using the Audit Trails package, there is some information concerning the user that last worked on transactions in MS Dynamics GP.

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.