Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : nhMcfzlNmZcStrG7YMaAa6
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Where is the item Crea...
Microsoft Dynamics GP (Archived)

Where is the item Create Date, Modified Date, and Created By (user) in GP2010

Like (0) ShareShare
ReportReport
Posted on 26 Apr 2018 19:32:50 by Goloknath

I'm trying to located the following inventory item level fields:

  • Created Date (CREATDDT): I currently have this on an inventory/item level Smart List but can't find it anywhere in the item maintenance screens
  • Modified Date (MODIFDT): I currently have this on an inventory/item level Smart List but can't find it anywhere in the item maintenance screens
  • Created User ID (CRUSRID): Not listed in any smart list but I would like to see the user that created the item.

Any help would be appreciated!

*This post is locked for comments

  • Suggested answer
    JodeRuiter Profile Picture
    JodeRuiter 980 User Group Leader on 27 Apr 2018 at 13:46:05
    RE: Where is the item Create Date, Modified Date, and Created By (user) in GP2010

    Hi GP_Questionnaire:

    These are fields that only exist in the SQL tables - IV00101.  They keep track of these dates for auditing purposes, but you will not find them in the GP User Interface.

    The fields are usually available to query in SmartList as columns - since that is a direct connection to the database.

    The field Created User ID - is probably in the table - If you are on the right GP version you can use SmartList Designer to directly query the table, otherwise, if you will want to do a bit of direct table querying or write more complex reports, then look into eOne's SmartList Builder.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,824 Moderator on 27 Apr 2018 at 13:25:11
    RE: Where is the item Create Date, Modified Date, and Created By (user) in GP2010

    Tools->Resource Descriptions->Tables and the choose Inventory. This will provide a listing of all the inventory tables and then look for IV00101. There is no created user (CRUSERID) field.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on 26 Apr 2018 at 20:18:48
    RE: Where is the item Create Date, Modified Date, and Created By (user) in GP2010

    I don't think there is a gui interface that shows that info...but they definitely reside in the IV00101 table

    not sure about the CRUSERID

    Tami

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

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,518 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,594 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans