If you have Microsoft Dynamics GP ERP and MRP application implemented in your organization and you are IT programmer, who needs precise training on connecting to Dynamics GP database and reviewing data flow and table structure, we would like to give you short orientation in this publication. We assume that you are familiar with relational databases and SQL Querying technique.
Typically GP DB structure knowledge is required when you are planning to develop real time or batch mode integration from legacy applications, such as Lotus Notes, Oracle Sales Order Processing, MySQL/PHP ecommerce website, or when you plan to design complex Crystal Reports, SSRS. It is also helpful in custom simple EDI interface design:
1. Where to find tables structure. There are several options. First, you can install Dynamics GP SDK from CD #2, where you can find complete picture on the Great Plains architecture. Second, you can login GP and go to Tools->Resource Description->Tables (also Windows and Fields, if required to understand desired Window or Field association with the set of tables). Of course, second option doesn’t give you holistic picture of the tables clustering and relations, keep reading on GP data flow
2. Table classification. In Dynamics GP you have several types of tables: Setup (normally prefix is 4XXX – module setup, such as General Ledger – which account is used for Retained Earnings, to give you the idea on what is there), Master records (normally prefixing with 0XXX: RM00101 is Customer Master table), Work tables (prefix 1XXX, example is SOP10100 – Sales Transaction Header), Open records (when you post work transaction, it goes to open status, prefix 2XXX, example RM20101 – Receivable Open Transaction Files), Historical records (prefix 3XXX, example RM30101 – Receivable Transaction History Files). Example of data flow in General Ledger module: when you create GL transaction it sits in GL10000 Header and GL10001 Lines, then you post transaction and it moves to GL20000 Year-to-Date transaction Open, and then when you close the Year, GL20000 is moved to GL30000 Account Transaction History
3. Some cautions. If you think that you can do direct SQL data feeding to GP Tables, think about business logic possible data integrity compromises. There are great Dynamics GP integration tools and SDK: Great Plains Integration Manager module and eConnect. Both of them validate business rules and do not allow SQL insert, which compromises the rules. In our opinion, it is probably more efficient and time consuming way to invest into Dynamics GP IM or eConnect training or self discovery and avoid possible future data corruption and recovery expenses
4. If you need Great Plains and FRx Architecture precise training, please give us a call: 1-866-528-0577, or help@albaspectrum.com In our experience, four hours is very efficient time frame to communicate to you Great Plains architecture, we offer training Worldwide through web session and skype
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
