Database,Development,for,Micro computer Database Development for Microsoft Great Plains Dynamics GP
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
So, if you plan to hook up your custom tables in GP workstation interface, you should initially create (and design) you custom tables in GP Dexterity IDE. It this is not required, you can create your custom tables directly in SQL and then link them with GP tables via SQL scripts (in this case you will not be able to produce the link in dex)Updating. If you plan to update GP tables from SQL stored procedures, please be very conservative and try to get help from professional GP Dex SQL developer. GP application business logic is complex and if you think you can update just one table without destroying internal links you may be too optimisticSelecting. Select statement is OK, as it doesnt update GP tables recordsPlacing custom tables into DYNAMICS or Company db. This is allowed, if you come from MS CRM world, where all custom objects should be placed into custom database please, know that in the case of GP you can place your custom objects into both system and entity DBIntegrations Design. This is the most popular GP SQL scripting direction integration with legacy databases, Microsoft Retail Management System (MS RMS), integration with heterogeneous database platforms, such as Oracle, Pervasive SQL, Ctree/Faircom, Sybase. When you develop integration, you should try to imitate GP table distribution records and if you integration logic goes beyond simple imitation you should consider getting the help from GP developer who has access to DYNAMICS.DIC with source code (sanscript dex code not stripped out)eOne Extender. If you plan to deploy the Enterprise version, purchased directly from eOne, you should consider reviewing its table structure and how you can address new tables in SQL scripting
Database,Development,for,Micro