SQL Downloads

This is a permanent post that will always contain the latest SQL Downloads list.

• LOTS of GP SQL Scripts at GP-Dynamics.com
• GP Internal Metrics
• Get GP Table Sizes
• Check if Reconcile Needed
• Change Inventory U of M
• AP Historical Aged Trial Balance SQL Code (Steve Gray?)
• View that combines Current and Historical GL
• Views for Balancing Subledgers to GL
• See What Companies Users Can Access. (thx Steve Gray)
• Remove Carriage Returns (Can occur with Copy/Paste)
• Rename Report Files for Archiving (vbscript)
• Find in any table (Jivtesh Singh)
• Find all tables with a particular value (Jivtesh Singh)
• Backup all Databases (Jivtesh Singh)
  
• Release Stuck Batches and Transactions Without Exiting All Users (David Musgrave)
• Identifying Duplicate Transactions (David Musgrave)
• How to automatically send all posting reports to screen (Mariano Gomez)
• How to split Dynamics GP's alphanumeric column values in SQL Server (Mariano Gomez)
  
• Create your own taGetNextNumber stored procedure (Mariano Gomez)
  
• How to automate a PDF file output name for a posting journal report (Mariano Gomez)
  
• Restricting access to metrics on Microsoft Dynamics GP Homepage (Mariano Gomez)
  
• Resolving SQL duplicate key error messages when executing RM Paid Transaction Removal (Mariano Gomez)
  
• How to enable Auto-complete for all GP users (Mariano Gomez)
  
• How to reconcile SOP batches (Mariano Gomez)
  
• How to fix a PO Number (Mariano Gomez)
  
• How to move SOP transactions from one batch to another (Mariano Gomez)
  
• How to find a column in any table (Mariano Gomez)
  
• How to remove child records from a National Account (Mariano Gomez)
  
• How to identify payables transactions not in GL (Mariano Gomez)
• Slow Moving Inventory (Mohammad Daoud)
• Show What Check Paid a PO (Victoria Yudin)
• SOP POP Link (Victoria Yudin)