Avatar of jnikodym
jnikodym
 asked on

Dynamics GP - SQL time stamp

Is there a time stamp that is saved somewhere in a SQL table that would tell me the data a Microsoft Dynamics GP Sales Order was entered into the system?  I know there is a document date on the sales order, but that can be changed.  I need to know the date the order was actually entered in the software.
Microsoft DynamicsMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
Steve Endow

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Victoria Yudin

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
jnikodym

ASKER
Thank you, that does work for the header.  Anyway to do this for the line items on the order?
Victoria Yudin

In 2010 (and I believe in 10.0 as well, I cannot check right this minute) there is a time stamp in the SOP10200 table called DEX_ROW_TS.  What I am not certain of is whether that is the create date or the modify date, I suspect it is the latter.  But that is the best you can get.  :-(  The only other option, if you really need this, is to create your own trigger and custom table to track the create date.
jnikodym

ASKER
That is what i thought.  The DEX_ROW_TS tracks the date and time the record was modified.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
jnikodym

ASKER
Do you have any sample code to create the trigger and custom table?
Victoria Yudin

Sorry, that's a question for someone else, I don't do SQL coding of that nature.
Steve Endow

Hi,

If you are looking to track that detailed information at the transaction level, you might consider Activity Tracking and Audit Trails, or perhaps even using the eConnect Requester tool to capture changes and additions to the eConnect_Out table (which uses triggers).  The first two have the benefit of being within GP and having some UI.  The last option only writes to the table and you will need to monitor and clear the table occasionally via SQL Management Studio.

I would NOT recommend writing your own triggers to log GP activity.  It is much more complex than it would seem. (been there, done that, several times)

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.