After the success of the Microsoft Dynamics GP Application Level Security Series, I have decided to release a another series which contains some really useful SQL scripts I have collected over time.
The posts in the series (so far) include:
Note: Links will be available on or after the posting date.
I hope you find the information in this series useful. I plan to add more scripts as time goes on.
If you have any scripts you wish to donate to the series, please contact me using the Email link at the top of the blog page.
More scripts available from
02-Dec-2008: Added Link to Mariano Gomez's article.
06-Apr-2009: Added Identifying Payables Transactions with Missing Apply Records post.
21-Jun-2010: Updated links to other blogs for additional scripts.
03-Nov-2010: Added Backing up and Restoring script.
05-Dec-2011: Added Granting Access and Binding Defaults script.
31-Jul-2013: Added link for updated spSearchOnAllDB script.
From the Useful SQL Scripts Series . This stored procedure allows you to search all columns in all tables
From Vaidy Mohan's Blog
From Victoria Yudin's Blog
Posting from the Dynamics GP Blogster
From the Useful SQL Scripts Series . When a system has a batch that is stuck as marked to post or a transaction
From the Useful SQL Scripts Series . Because Microsoft Dynamics GP is designed to have separate tables
This script maybe useful:
Mohammad R. Daoud
I found another script you may need to add, check my post below:
From the Useful SQL Scripts Series . I was assisting on a support case recently where we needed to identify
I recently wrote a script to synchronize a newly updated TEST company's users with the Dynamics user access list. Do you accept contributions? If so, how should I submit it? Or is that script already here. I searched, but couldn't find it.
You can email the script to using the feedback link at the top of the blog.
I am always interested in looking at handy SQL scripts.
Glad to find many great Dynamics resources as it makes learning/teaching the subject so much easier. I wish I could give back by writing and sharing my own script commands but I'm not that proficient yet in this field. There are many more useful Dynamics GP scripts on http://www.gp-dynamics.com which I think a lot of beginning users like me can benefit from.
I am looking for a couple of scripts to automate a couple items...
1. to push in a GL Transaction (I currently use the integration Mgr and I want to totally automate it)
2. to create a check batch
Please look at eConnect as this is the recommended method of integrating transactions. It has an API which in turn calls SQL Stored Procedures which include all the business logic and validation.
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.