Open Forum

Expand all | Collapse all

Who created an inventory item

  • 1.  Who created an inventory item

    Posted 14 days ago
    First, I want to say I am thankful for all of the sharing that has happened through the years by both Users and Partners.   I truly value this site.

    Is there a way to see who created an inventory item?

    ------------------------------
    Debbie Janssen
    Accounting (AR and AP) and GP Maint
    Sure Controls Inc.
    Greenville WI
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Who created an inventory item

    GPUG ALL STAR
    Posted 14 days ago
    Hi Debbie,
    yes and no..
    No, because the GP Inventory master table doesn't track who changed which item, but only when it was modified the last time (IV00101..DEX_ROW_TS).

    Yes, because if you enable in GP the Activity File Tracking option on all users for all companies, you will be able to report on that activity later.
    In the Activity Tracking Setup form, select the type "File Tracking" and then check the boxes for Activity you want to be tracked and for which user(s) in which company(ies).
    Likely Addtions, Deletions & Modifications on Master Files is what you're looking for...

    Once this is done and users have started making changes to Master records in GP (be aware, this isn't limited to Inventory, but all master data!!), you can inquiry / report against that activity.

    Be careful on how many users and companies you're selecting/enabling this tracking, as the activity table is filling quickly and can become quite large over time..  It is important that you go from time to time to the Activity Detail window and remove old records based on dates (for example).

    You can also setup a SQL job that cleans up the DYNAMICS..SY05000 table based on the date entries, so you don't let that grow too large over time.
    Run the job once a month for entries older than 6 or 12 months.. Your mileage may vary depending on how many users & companies you're going to track.
    Hope that helps.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Who created an inventory item

    Posted 14 days ago
    That is what I thought too.
    I will let management know about the tracking ability and let them decide.
    Thank you.

    ------------------------------
    Debbie Janssen
    Accounting (AR and AP) and GP Maint
    Sure Controls Inc.
    Greenville WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role