David Musgrave unleashes his toolbox of useful SQL scripts in his traditional Developing for Dynamics GP blog. David will address this topic in a series of articles that you must be sure to check out.
The articles will be released in the following order:
Mon, 12/01/2008: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database
Wed, 12/03/2008: Releasing Stuck Batches and Transactions without exiting all Users
Fri, 12/05/2008: Identifying Duplicate Transactions
The links will be available on or after the posting date according to your time zone. While you enjoy these scripts, be sure to check my own collection:
- How to automatically send all posting reports to screen
- How to split Dynamics GP's alphanumeric column values in SQL Server
- Create your own taGetNextNumber stored procedure
- How to automate a PDF file output name for a posting journal report
- Restricting access to metrics on Microsoft Dynamics GP Homepage
- Resolving SQL duplicate key error messages when executing RM Paid Transaction Removal
- How to enable Auto-complete for all GP users
- How to reconcile SOP batches
- How to fix a PO Number
- How to move SOP transactions from one batch to another
- How to find a column in any table
- How to remove child records from a National Account
- How to identify payables transactions not in GL
These are just a few I have written over the years and that you may certainly find useful throughout your daily operations.
Until next post!
Mariano Gomez, MVP, PMP
Maximum Global Business, LLC