Welcome to GP-DYNAMICS Custom Programming!
Our document contains specific information that can help you decipher those complex tables and columns in creating your own Dynamics GP extension programs using your own favorite programming language like Visual Basic, C++, Delphi, C language; or reporting tools like Crystal Reports, etc . Custom programs and reports may range from pulling information directly from Dynamics GP database, creating new records, and modifying records - all without using the Dynamics program but through your own customized Dynamics GP compatible program. Directly accessing the correct database objects is more powerful than using integration programs like eConnect.
Owning this technical brief will save you valuable time and effort in researching, testing, and countless hours of experimenting in creating your own custom programs for Dynamics GP database.
Why is being able to program the database on my own useful?
The programming know-how is very useful when you want to create new integration programs, customization, or add-ons modules that will unleash more power of the huge set of information that is stored in the database used by Dynamics GP. It is very useful because you can extract and present information in your own way especially for those that Dynamics GP alone program cannot accomplish.
A proof that different businesses demand different ways of information presentation is when Microsoft introduced "Smartlists" on Dynamics. "Smartlists" were designed so you can customize the information that you can get from several Dynamics tables. But of course, those fixed number of lists are still very limited and not enough. Different businesses have different unique requirements. You will have endless capabilities at your disposal by being able to create programs that can manipulate the GP database.
Dynamics GP is a great program in itself. However, it's great to know that if it cannot give you the information you want, you can go directly to the database and get it yourself!
Recommended knowledge set:
This manual is intended for users and/or developers who have:
Basic understanding of the Dynamics Great Plains program, Version 7.5, 8.0, 9.0 or 10.0
Basic knowledge of MS SQL, knows how to use the Query Analyzer of any other program interface that can execute an SQL command.
Optional but very beneficial: Knowledge of other programming languages that can connect to an MS SQL database like Visual Basic, Delphi, C, C++, etc.
"You need to know the specific tables and columns and their relationships to develop extension modules for Dynamics GP. "
Our technical brief can give you that information.
And don't forget DEEPSEARCH - The perfect companion tool when developing MS GREAT PLAINS custom add-on modules.