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;
9. Order Comments
Display all comments for a particular order.. (viewed 1490 times)
10. How to unlock a Dynamics user
This is useful in solving Dynamics GP error: "User is already logged-in" when you are trying to log .. (viewed 3397 times)
Technorati Tags: Dynamics GP