I stumbled upon this a new Dynamics GP site tonight, gp-dynamics.com. This site lists nearly one hundred useful SQL scripts to use when working with Microsoft Dynamics GP ERP system. I glanced down the list of scripts and dipped into some of them and it all looked like a good resource.
The site is orientated towards selling a technical manual on Dynamics GP, but this section is free. Of the scripts I looked at, some of them were naive, but not dangerous. Certainly enough to get out of jail free, I certainly would have relished such a resource back in 2001 when I started with GP, as it happens I have strikingly similar resource of scripts I’ve built up myself on my hard drive. A couple of examples from the site to give you the idea follow;