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
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
The solution worked for me thanks to the community and the members for the solution.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156