BTT | Blog The Tech

Microsoft Dynamics GP ERP has robust set of data integrating tools and modules.  Just the fact that Great Plains is hosted in Microsoft SQL Server opens for programmer the whole spectrum of Microsoft SQL Server integration options: DTS package, SQL stored procedures, ADO.Net programming, XML data feed

However, GP data conversion might be potentially dangerous, as you, as software integration developer may compromise business logic data integrity.  In this small publication we are giving you highlights on the integration tool, which validates business logic and weeds out non-compliant records ? Microsoft Dynamics GP Integration Manager:

Share This

Filed under: 468 | No Comments »

Microsoft Dynamics GP, or former ERP name is Great Plains Software Dynamics / eEnterprise gives you, programmer or software developer vide spectrum of report design tools: Crystal Reports, Microsoft SQL Server Reporting Services, GP ReportWriter, MS Access, MS Excel to name some of the popular. 

In this small technical paper we would like to introduce you into Crystal Reports design for Dynamics GP, assuming that you are new to GP and need some starting help.  We also assume here, that you are on MS SQL Server Database: GP 10.0, 9.0 and 8.0, if you are on GP 7.5 and earlier: 7.0, 6.0, 5.5, 5.0 or 4.0 where Great Plains was available on Ctree or Pervasive SQL/Btrieve, please review database connection options, described in our earlier articles ? you will need to install Ctree/Faircom or Pervasive ODBC drivers.  Let’s come back to Crystal for GP on MS SQL Server:

Share This

Filed under: 313 | No Comments »

Microsoft Dynamics GP ERP, or former Great Plains Software Dynamics and eEnteprise have wide range of modification, software development, integration, EDI, reporting tools.  However, please take into consideration the fact, that GP is mid-market accounting, ERP and MRP platform, meaning that its business logics and processes might be too complex for newcomers with natural good intention to help her or his company to deliver and implement tailored business logic in a few days or weeks

Share This

Filed under: 313 | No Comments »

Microsoft Dynamics GP ERP has pretty cool and end user friendly integrating module: Great Plains Integration Manager.  With Dynamics GP version 10.0, IM got revolutionary improvements in the form of eConnect connectors.  a

Now, where these connectors are available, IM performance issue virtually evaporated and you can integrate thousand of SOP invoices per minute, as eConnect deploys SQL stored procedures, versus OLE server for old IM connectors.  However we often see the problem of finding GP programmer, who is a maestro with advanced ODBC query to make integration manager work with pretty rigid and cumbersome text file, produced from your legacy MRP or EDI application.  Let’s move to the bullets:

Share This

Filed under: 313 | No Comments »

Microsoft Dynamics GP functional and technical consulting requires strong backing in technology experience, background, training and certification. 

Modern ERP consultant should be familiar (or be capable to involve fellow consultants) with industries, managerial and financial accounting, be reasonable good in reports design, system modification, have some knowledge and be aware about specific programming techniques and customization tools.  We would like to introduce our company to you, GP user in your organization for advanced technology challenging projects: Dexterity customizations, Crystal Reporting (based on SQL Stored Procedures and Views), eConnect eCommerce programming, integrations (including EDI, GP Integration Manager, SQL Scripting and eConnect).  Here is the introduction:

Share This

Filed under: 313 | No Comments »

Microsoft Dynamics GP add-ons are often written in Great Plains Dexterity ? with new and sometimes alternative GP forms and windows where the buttons, have scripts and forms themselves have procedures and functions. 

These programming parts are written in Dex Sanscript programming language.  Sanscript is sort of proprietary scripting language, typically you can get Dex programmer from GP ISV and customization partners, you should check with your Great Plains VAR for details.  When newer Dynamics GP version is released, if you plan to update to it, you have to take into consideration Dex modification upgrade requirement.  In this small publication w would like to orient you what you could expect from technical side:

Share This

Filed under: 313 | No Comments »

Microsoft Dynamics GP is popular ERP in USA and we would like to recommend you our company Alba Spectrum as GP reseller, integration, consulting partner and ISV with local office in San Diego, California.  Considering San Diego business diversity, our lead consultants are fluent in both ? English and Spanish and we have experience in implementing Great Plains for US companies with manufacturing facilities in Maquiladora area of Mexico as well as n Baja California

You should expect exceptional technological expertise of our Microsoft Great Plains Dynamics consultants and programmer to help you with the projects where other companies give up.  GP highlights:

Share This

Filed under: Computers | 1 Comment »

If you are in process of identifying requirements for the next generation ERP, MRP or accounting system and you are thinking to check out and get presentation in Microsoft Dynamics GP, then you should select local, regional or nationwide GP reseller. 

GP software licenses are sold through VAR channel and following software installation, data conversion, user training, modifications, system setup, integration and reporting are normally done by the same GP implementation partner.  Let’s review GP implementation phases:

Share This

Filed under: Computers | No Comments »

Microsoft Dexterity or former name is Great Plains Dexterity is Integrated Development Environment and programming language (Sanscript).  Current version of Microsoft Dynamics GP is 10.0 and software programmers have broader number of customization tools: eConnect, SQL scripting, Visual Studio SDK, Modifier with VBA. 

However if you look at earlier versions: 5.0, 6.0, 7.5 then you will discover that large number of existing Great Plains ERP installations have modifications programmed in GP Dexterity.  Dex is still all-mighty and extremely powerful tool ? you will see Dexterity foundation in GP tables, forms, atomic stored procedures (deployed by Dex table indexes).  Let’s review the bullets of Dex customization maintenance:

Share This

Filed under: Computers | No Comments »

Microsoft Dynamics GP, or also commonly known as Great Plains is Microsoft SQL Server database application and at the same time it has its own IDE and programming language, known as Great Plains Dexterity. 

Dexterity in turn is written on C as a shell.  Recent versions, such as 10.0, 9.0 are tightly integrated with Microsoft Outlook, plus version 10.0 has integration with Sharepoint and SQL Server Reporting Services (or SRS).  Having said that, however we would like to inform you that installation itself is streamlined and not overly difficult.  Let’s review:

Share This

Filed under: Computers | No Comments »