web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Creation Date For tran...
Microsoft Dynamics GP (Archived)

Creation Date For transactions in GP

(0) ShareShare
ReportReport
Posted on by Arpit Goyal 200

HI all,

As part of some development , I need to know that whenever a  transaction enters in the system in any type of  module  Is there a table available which stores the creation date of transaction.

Even when the transaction goes thorugh working -->open -->Histroy status  this creation date should not change.

If possible ,Can you please let me know the table name  for such date ?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at

    hi Arpit

    where the created date is stored it is stored on the data table with the transaction rather than on a separate table as you hope.

    the dex row id may have a date time stamp on it, that is available only via sql / crystal (a reporting / querying tool)

    also ponder what you mean by creation of a transaction.

    in the general ledger there are;

    last date edited

    modified date

    originating posted date

    all three of those could be considered the creation date of the transaction depending on your perspective.

    ian

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    The created data is not saved in separate GP tables. Some date field will be saved instead of created date in GP work, open and hist tables of the each module.

    The DEX_ROW_TS field is available all the work, open and history table with holding the date and time of the record inserted. We can see this field in back end not GP.

    For all the open and history tables has the date field called Posted Date this will hold the date value for the transaction posted/created.

    Hope this helps!!!

  • Arpit Goyal Profile Picture
    Arpit Goyal 200 on at

    The problem is to do the vat calculation we have configured a Sql view in our system and we need to capture the date when the transaction was created in great plains system (becomes Working in pm10000) table.

    the second problem is that the transaction moves from PM10000 table ot PM20000 and then to PM30200 table on changing the status from working -Open and History and it deletes the existing records when it was hold in PM10000 table

    Could you please advise is this date get recorded in some TAX table.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    For the first problem use the Dex_ROW_TS field to get the transaction saved from work(PM10000) with using the SQL view. (eg. Select DEX_ROW_TS 'Created Date', * from PM10000).

    For second, we can't track the created date flow from work to open then to hist.

    But, you can do it by creating table trigger for feature transactions.

    Hope this helps!!!

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    It seems to me that you have already gone along with this task achieving a considerable progress. Your point is totally to the point, when a transaction is saved in certain open table such as PM10000, the timestamp field gets updated with the current date-time value as retrieved on the SQL server level. Upon posting, will be retrieved again and recorded along in PM20000 losing the original timestamp value.

    To get back to the point of timestamp, it provides server-based timestamp to be recorded against each new "row" in the table.

    The bottom line is, I don't believe that this information will be available once the record is moved from open to work, which is why you might be unable to get this piece of information for "Historical Transactions."

    On the other hand, for future purposes, you can consider several approaches to save this timestamp somewhere else either by considering Dynamics GP Activity tracking, or creating your own stored procedures to keep this information somewhere else.

    Your feedback is highly appreciated,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans