Date and time of user activity

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

Is there a report or a utility to identify which user did what at a certain point in time. One of our users added an inventory item number and now cannot remember what item was added.

Thanks,

Zeeshan

*This post is locked for comments

All responses (6)

Answers (3)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Date and time of user activity

I'd like to know when an adjustment to inventory was actually posted, t he The modified, nor the created date is not giving me the actual user date of the adjustment transaction. How would I get that info?

Thanks,

Kim
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Date and time of user activity

I used to think the DEX_ROW_TS field could be used to identify when a record was added or modified, but then I found this discussion that indicates it's sometimes updated when another table is updated:

http://www.timwappat.info/post/2014/12/04/Beware-DEX_ROW_TS-for-data-synchronisation

So, don't depend on that field to give you what you need!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Date and time of user activity

Thanks so much. We found the item.
Verified answer

Mahmoud Saadi 32,738 on at

Like (1)

Report
RE: Date and time of user activity

Of course, there is always another way :)

Go to Smart lists > Inventory > Items.

Press on "Columns", and then "Add"

You can find both fields (Created Date) and (Modified Date)

Add them to your smart lists

On the Search, get the following Search Criteria (Created Date "is greater than" '#Date')

You can go one step further as well, to make this favorite smart list, associated with a reminder. You may set the reminder to show a notification on the Dynamics GP homepage in case any items is added "today" for instance.

Never hesitate to share any further inquiries,
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Date and time of user activity

Thanks Mahmoud. Our database is managed by our service provider so I am a bit hesitant to touch it. Would you think something can be done via smart list.
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Date and time of user activity

Of course there is, you will need to access this piece of information on the database level. In Dynamics GP, there is a column called "Dex Row Time Stamp", it records the date and time at which the record was inserted in the table.

For this inquiry specifically (regarding the new item added), you will need to check the "Dex_Row_TS" in IV00101 (Item Master),

Another option is to simply check the "Created Date", which indicate when this item was created. Further details regarding item modification can be found under "Modified Date"

Consider the following SQL query, on your company database:

SELECT * FROM dbo.IV00101 WHERE CREATDDT > '2014-01-31 00:00:00.000'