I was looking at some records in the GL20000 table to identify when they were added to the table, but it appears that the time value isn't correct - it's showing the records as having been added at 9:00pm or so, when nobody was working.
I checked the time on the database server, and it's set properly. I also checked the time on the user's computer who appears in the USWHPSTD field, and it's OK, too.
It's a mystery....
The Dex_Row_TS stores the time in UTC: en.wikipedia.org/.../Coordinated_Universal_Time
Victoria Yudin - Dynamics GP MVP (2005-2015)
Want to use Excel, Crystal and SSRS with Dynamics GP? Check out GP Reports Viewer