web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    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.

  • Suggested answer
    JodeRuiter Profile Picture
    JodeRuiter 980 User Group Leader on at
    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.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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