170
Hi All
I hope everyone is well
I'm using this SQL code to view all GL transactions:
https://victoriayudin.com/2011/04/27/sql-view-for-all-gl-transactions-in-dynamics-gp/
I'm not brilliant in SQL, just wondering how can I adjust the codes a little bit to add Originating Doc Date, to get the document dates for both PM & RM transactions posted to GL.
Kind regards
I tried this but I'm not sure if it would be possible without combining a lot more tables. The GL20000 table has a field called ORPSTDDT for the Originating Posted Date. I was able to add it but then I found that it isn't the original transaction date but the literal date it is posted. I entered a transaction in AP for 04/01/2027 but the originating posted date showed 03/22/2023 because of the day I posted it.
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
