Share
ReportDoes anyone know what table/tables stores a user date when posting sales batches?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Does anyone know what table/tables stores a user date when posting sales batches?
*This post is locked for comments
I would like to further add up to this topic, Dynamics GP stores the date in fields like (Created Data, Posted Date, Modified Date, Dex Row Time Stamp) as retrieved from the SQL server date and time, the client machine date is not considered.
In addition to the above mentioned by Mr. Frank you can consider the following:
Furthermore, if you like to have a wider perspective on the SOP tables considered when posting and data flow, nothing better than the legendary article Data Flow and Tables Names by Ms. Leslie Vail. There is specific section for SOP tables and how data moves across tables when saved and posted.
Never hesitate to share any further inquiries,
Posted date = SOP30200.POSTEDDT. User who posted = SOP30200.PTDUSRID
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (