web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM 30600 - User ID field
Microsoft Dynamics GP (Archived)

PM 30600 - User ID field

(0) ShareShare
ReportReport
Posted on by ElmerUXC 505

I have a user who is wants to create a report related to historical payable transactions.  He would like the user id of the user who created the distribution line for the payable in history.  PM30600 has a user id column but my local environment has no user id data in this table.

Can someone tell me what process updates the user id field in this table?  My first thought is that it is related to account security but I cannot confirm that.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    I have just been testing your inquiry to determine when the user id field gets populated in the distribution tables, if we get back to the PM distribution work table, the user id is supposed to be populated upon posting (according to SDK), then this data shall be moved to the PM30600. Although, the field is empty and still can't find any justification as further intensive testing is required. 

    If you track down the transaction either to the PM History File (PM30200) or PM Control Table (PM00400), you will find the "PTDUSRID" field indicating the user who posted the transaction as a whole regardless of the distribution line. In your company, do you have users entering transaction and users modifying the distribution?

    After all, the User ID field will help you figure out who posted, regardless of who entered or modified. If you are looking for such details, you might need to consider further tracking represented with Dynamics GP Activity Tracking (Tools > Setup > System > Activity Tracking).

    Your feedback is highly appreciated, 

  • ElmerUXC Profile Picture
    ElmerUXC 505 on at

    Thank you for the information Mahmoud.  I really appreciate your time.

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.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans