Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - Customization and Integration
  New Posts New Posts RSS Feed - SQL data extract
  FAQ FAQ  Forum Search   Register Register  Login Login


SQL data extract

 Post Reply Post Reply
Author
Message
jharden View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: March 13 2012
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote jharden Quote  Post ReplyReply Direct Link To This Post Topic: SQL data extract
    Posted: November 07 2013 at 6:25am
I need to export (SQL) all GL journal entries for last year. I know I can do via Smartlist, but would like to be able to run via sql. Anyone already have some sql code for pulling out from the correct tables - or at least be able to point me at the correct tables?

Thanks much!!
Back to Top
Sponsored Links


Back to Top
jharden View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: March 13 2012
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote jharden Quote  Post ReplyReply Direct Link To This Post Posted: November 07 2013 at 7:01am
Nevermind - should have checked Victoria Yudin's site first.

Thanks Victoria - your code worked great (posted here) http://victoriayudin.com/2009/08/11/sql-view-for-all-posted-gl-transactions-in-dynamics-gp/
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com