News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) link activity to a cha...

Microsoft Dynamics GP (Archived)

link activity to a changed sales transaction entry

(0) Share

Report

Report

Posted on by tp37

175

How do I link a user listed in SY00800 to a transaction listed in sop10100? I see that the SY00800.bachnum shows the user in the batch. And, I see the sop10100.dex_row_tx show when the sales transaction was updated. But I cannot find the link between the specific user and the cahnge to the sales transaction. Does anyone know? I am not interested in using activity tracking or audit trails. I want to know the custom/SQL Server tabular link. I am using SQL Server 2008 and GP 10

Thanks.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

tp37 175 on at

Like (0)

Report

Re: Re: link activity to a changed sales transaction entry

Thanks, Mariano. But there has to be a way to track the user with the existing tables. If one person opens a sales transaction then no one else can open it. So that says the system is tracking it.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,321 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans