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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    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.

  • Suggested answer
    JodeRuiter Profile Picture
    JodeRuiter 982 User Group Leader on at

    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.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans