Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invenotry item set up

Status
Not open for further replies.

swabunn

Technical User
Jan 25, 2006
175
CA
I want to see the user who has set up items in item master.
any body can help where to look -smart list or which table ?

I have seen item master table and item smart list I didn't find it there

Thanks

Swabunn
 
I believe there's a field called user who created and a date. You can use smartfinder or look it up directly in the table.

Alternatively you could set up activity tracking on the inventory master and track all changes

you could also create yourself a trigger to populate an archive table with insert and delete info.



-----------
and they wonder why they call it Great Pains!

jaz
 
my apologies, that table does not have that field. It only has a created date CREATDDT and a modified date MODIFDT

you'll need to either use activity tracking or some home brewed solution.



-----------
and they wonder why they call it Great Pains!

jaz
 
If this is something you want to keep constant tabs on there are some Auditor Tools out there. One you might take a look at is Rockton Software's Auditor. There is an online demonstration on the web at:
It will allow you to track changes, additions, and deletions in your Dynamics GP SQL install. In addition to capturing the changes you can make the user put in a reason or have an email sent as soon as the change is committed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top