Dynamics,ISV,Partner,Newsflash computer Dynamics GP ISV Partner Newsflash: Great Plains Tables Struc
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
Typically GP DB structure knowledge is required when you areplanning to develop real time or batch mode integration from legacy applications,such as Lotus Notes, Oracle Sales Order Processing, MySQL/PHP ecommercewebsite, or when you plan to design complex Crystal Reports, SSRS. It is also helpful in custom simple EDIinterface design: 1. Whereto find tables structure. There areseveral options. First, you can installDynamics GP SDK from CD #2, where you can find complete picture on the GreatPlains architecture. Second, you canlogin GP and go to Tools->Resource Description->Tables (also Windows andFields, if required to understand desired Window or Field association with theset of tables). Of course, second optiondoesnt give you holistic picture of the tables clustering and relations, keepreading on GP data flow 2. Tableclassification. In Dynamics GP you haveseveral types of tables: Setup (normally prefix is 4XXX module setup, such asGeneral Ledger which account is used for Retained Earnings, to give you theidea on what is there), Master records (normally prefixing with 0XXX: RM00101is Customer Master table), Work tables (prefix 1XXX, example is SOP10100 Sales Transaction Header), Open records (when you post work transaction, itgoes to open status, prefix 2XXX, example RM20101 Receivable Open TransactionFiles), Historical records (prefix 3XXX, example RM30101 Receivable TransactionHistory Files). Example of data flow inGeneral Ledger module: when you create GL transaction it sits in GL10000 Headerand GL10001 Lines, then you post transaction and it moves to GL20000Year-to-Date transaction Open, and then when you close the Year, GL20000 ismoved to GL30000 Account Transaction History 3. Somecautions. If you think that you can do directSQL data feeding to GP Tables, think about business logic possible dataintegrity compromises. There are greatDynamics GP integration tools and SDK: Great Plains Integration Manager module andeConnect. Both of them validate businessrules and do not allow SQL insert, which compromises the rules. In our opinion, it is probably more efficientand time consuming way to invest into Dynamics GP IM or eConnect training orself discovery and avoid possible future data corruption and recovery expenses 4. Ifyou need Great Plains and FRx Architecture precise training, please give us acall: 1-866-528-0577, or [email protected] our experience, four hours is very efficient time frame to communicate toyou Great Plains architecture, we offer training Worldwide through web sessionand skype
Dynamics,ISV,Partner,Newsflash