Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

GL Entries TIME Column Required

Posted on by 385

How can I see the posted time of GL entries. I checked the whole GL table and found TIME1 column which aslo not showing the correct time.

Any help would be appreciated.

Thanks

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Entries TIME Column Required

    The solution worked for me thanks to the community and the members for the solution.

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: GL Entries TIME Column Required

    Hello,

    We do not track this by default in Microsoft Dynamics GP, only the date.  The TIME1 field is used for Multicurrency rates.  The DEX_ROW_TS field would give you the time that the record was posted to the open year.  However, when you close the year and the transaction moves to the GL30000 table, that DEX_ROW_TS would now be updated again at the time of closing the year.  

    You could look into enabling something like Activity Tracking on General Ledger Posting to get more advanced user, time, and date stamps for Posting.

    System Setup Guide - Dynamics GP | Microsoft Docs\

    I hope this helps!

    Isaac Olson

    Microsoft Support

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans