Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

USER ID on a Great Plains general journal entry

USER ID on a Great Plains general journal entry

USER ID on a Great Plains general journal entry

I would like to view or see the USER ID on a general journal entry.... in Great Plains. I can pull up the entry via the audit trail code or the journal entry #.... but it does not show or print out the USER ID for that particular journal entry. Is there another way to see this info? thanks, b.p.

RE: USER ID on a Great Plains general journal entry

Victoria (love your blog btw),
Not to derail, but what determines who is "Last User"? Our parent company wants us to show the user who created, and user who approves(posted) a particular journal entry in a report. I would think, as long as the manager is posting via the batch, and not getting into and/or changing the entry itself, these two fields would be creator/poster. However when we run a smartlist, we often get the same user ID in both fields.

RE: USER ID on a Great Plains general journal entry

Thanks for your kind words! Unfortunately, I do not know the logic used to determine these. I also suspect it may differ by GP version, but have no concrete proof of that. There are 2 ways I can think of to answer this more definitively:
1. Open a support incident with GP Support. They should (hopefully) be able to look at the code and give you the exact answer of how these are populated.
2. Test this yourself with all possible variations of what could happen.

One other thought - since GP does not track a 'created user' and that is really what you want, another option may be to make sure that when your users create journal entries, they are always in a batch and the batch ID always has the user initials or some other identifier in place. (Or maybe put that identifier in the reference field instead - just do not use the batch comment, that's not saved.) This way you can report on the data you know is there and populated as you want it to be. A slightly more complicated option (but possibly preferable, as it does not require users to do anything) would be to create a SQL trigger and a custom table to track this data.

Victoria Yudin
Dynamics GP MVP 2005 - 2013
Use Crystal Reports and SSRS with GP:
blog: http://victoriayudin.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close