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.
|
Administration >> Setup >> System >> Activity Tracking
|
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.
|
Administration >> Inquiry >> System >> Activity Tracking
|
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).
|
Administration >> Utilities >> System >> Activity Detail
|
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.comMontreal QC GPUG Chapter Leader
MBS MVP (2015-2018)
------------------------------
Original Message:
Sent: Feb 17, 2021 08:41 AM
From: Debbie Janssen
Subject: Who created an inventory item
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
------------------------------