[ad_1]
Microsoft Dynamics GP, or as this ERP is now known and popular among the IT community – Great Plains Dynamics is at this time Microsoft SQL Server-based applications. SQL means tables, their names, fields, data flow that reflects business processes, such as sales account, posting, customer payments against these accounts, termination, etc. As you can imagine, Great Plains MRP is not just a collection of tables has software logic, which is realized in Microsoft Dexterity (or as it was formerly known Great Plains Dexterity). If you have intentions to customize Great Plains, you can do it either on the SQL level or dexterity, as well as new tools are now available, such as eConnect, which is actually the replication of Dex logic in encrypted SQL stored procedures with rich interface stack: COM +, BizTalk, Web Services. Dexterity has also such extensions as Extender (or full version of eone extender, available from eone). Let’s get technical highlights:
1. GP tables structure. The best and most appropriate way to get the core of GP tables and their interactions, is to set up and review GP SDK, available from CD 2. However, the more practical is quick access tables structure in GP workstation interface, simple go to Microsoft Dynamics gp > tools> Resource Descriptions-> Tables, then select a series: finance, production, project, system, economy, trade accounts payable, payroll, HR
2. Data in and send workflow. GP is mid-market ERP and business processes are not trivial. In order to get them compared through SQL stored procedures, you need to enter simulate trading in testing business environment. A good example – if you want to simulate Sales Order Processing cycle: a bill of sale, then after that and take customer payment – monitor every step in SQL to verify the unit’s record and at any level
3. handcrafted . Great Plains Dex is the source of the current GP version, 10.0 and March 2008. Dex business logic in Dynamics.dic and related third-party dictionaries. Handcrafted in-house programming is not recommended due to the complexity and long learning for Dexterity programmers
4. eConnect. This SDK is a new GP welcomed tool, but Dex. We recommend that if you try to make GP changes, mergers, DB business internally
5. GP Ecommerce Shopping Carts and catalogs. The best approach is first to explore Microsoft Great Plains Dynamics GP Business Portal Order Management module, which is seamlessly integrated with GP SOP and Inventory Control modules native
[ad_2]