Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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 978 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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 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.

  • 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

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans