More SQL Scripts for Dynamics GP
The premise of my blog as I indicted before is to inform and disseminate information I feel is important or useful to partners and customers and sometimes that may be redirecting you to another blog where I find information that you may not normally find or know about. I have done this a few times with Dave's "Developing for Dynamics Blog" but this time another Dynamics GP Blogger, Mariano Gomez of "The Dynamics GP Blogster " has posted several great SQL Scripts that you will find useful as well.
- 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