Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com - help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale.
Nowadays Microsoft Great Plains or any other ERP application should be rather considered as the platform for integration of your peripheral applications: CRM, eCommerce, Custom Sales Order Processing, EDI (Electronic Document Interchange) and others. Plus of-the-shelf available business logic often requires customization, where you got to select appropriate software development tools to do the job. Since the time of Great Plains Software being purchased by Microsoft, Great Plains was under the way of being redesigned to be tightly integrated with .Net and Microsoft Outlook and Office stack of products. Let’s take a look at the GP technical layer:
1. Microsoft Dynamics GP Dexterity architecture. Great Plains Dex was designed to serve as Great Plains Dynamics platform in earlier 1990th, when similar approaches were taken by SAP – ABAP and Navision – C/SIDE. Dexterity is in turn written in C++ programming language. To give you Dex architecture surface signs: DYNAMICS.DIC, DEX.INI files, DEX_ROW_ID that you see in each GP table. If you plan to use Dexterity for customization, then you need to locate Dex developer, especially the one who has access to Dexterity source code
2. eConnect. This SDK was specially created for e-commerce developers to enable GP backoffice integration for eCommerce web sites. Since the initial version back in earlier 2000th, eConnect covered more GP modules and business objects: SOP, POP, Project Accounting, General Ledger, Receivable Management, Payables Management modules. The core of eConnect are encrypted SQL stored procedures
3. GP Integration Manager. If you review GP IM 10.0, you will see that IM connectors are now available in most of the business logic cases in eConnect. EConnect connectors drastically improve IM performance and doesn’t require GP workstation running on the same computer (old IM connectors were using GP workstation as OLE server)
4. SQL Scripting and Stored Procedures. If performance is the imperative, then you should consider SQL scripting, which will allow you to create primitive business logic, where you don’t need complete business logic validation, made by eConnect. Also stored procedures will allow you to utilize aggregations in SQL, versus SQL cursors, deployed in eConnect
- Related Videos
- Related Articles
- Ask / Related Q&A
- Microsoft Dynamics Gp Great Plains Consultants With Industry Expertise
- Microsoft Dynamics Gp Great Plains East European Options Overview for Consultant
- Microsoft Dynamics Gp Great Plains Integration and Upgrade in Chicago
- Crystal Reports for Microsoft Dynamics Gp Great Plains – Overview & Faq
- Microsoft Dynamics Gp Great Plains Series and Modules Faq
- Microsoft Dynamics Gp Great Plains Custom Logic Programming
- Microsoft Dynamics Gp Great Plains Ecommerce Considerations
- Dynamics GP Great Plains in Russia, please consider instead SAP Business One
Acronis Disk Director Suite 10.0 helps solve all your HDD problems
By: topsofts | 08/01/2010Acronis Disk Director Suite 10.0 is the best program for manageing your HDD. It comes with 5 more programs incorporated that will help solve all you Hard disk drive problems, and meets all your needs.
Custom Software: When Result Does Matter
By: Arun Kumar | 08/01/2010With the exploration of new business avenues, the entire scene of online business has seen a drastic change today. People are now venturing into those fields, departments and processes which were once out of one’s reach, even in their dreams. But things are completely different today, they have not only made entries into those lands, they have also shown great amount of success.
Don’t Worry about Your Slow PC from Today
By: topsofts | 08/01/2010Asmw PC Optimizer pro is a collection of over 30 system-maintenance and optimization utility to tuneup windows performance. Registry Repairs, Remove junk files and other optimizer functions.
Pass4side 642-746 Training materials
By: aminalee | 08/01/2010Pass4side provides Cisco 642-746 exam study materials,such as Cisco 642-746 Braindumps, 642-746 Study Guide, 642-746 exam Questions with Answers, 642-746 Training materials, free 642-746 demo and so on.
Convert flip to Gphone/G1/Nexus One on Mac
By: jolly | 08/01/2010Free download flip video to Gphone WMV/MP4/3GP, putting/importing flip video into T-mobile G1/G2/G3/Nexus One/ Android phones on Mac.
ECommerce Integration Developing for Microsoft Dynamics GP Notes
By: Andrew Karasev | 07/01/2010When you have legacy in-house programmed ecommerce web application in production with shopping cart, credit card payment interface, B2B or B2C items catalogs and promotional pricing - which does the job - likely that you will favor the idea to leave it there and try the way of ecommerce integration connectors to your Microsoft Dynamics GP Corporate ERP application.
BGI completes labeling portfolio with PTI-compliant traceability software solution from TraceGains
By: Thomas Cutler | 07/01/2010BGI completes labeling portfolio with PTI-compliant traceability software solution from TraceGains
8 Hidden Secrets Of Mozilla FireFox
By: HeLLZ RuLLZ | 07/01/2010The best thing about Firefox is that just when you think you know everything there is to know about the browser, something new comes along and surprises you. Here are few hidden tips and tricks. Maybe these are old hat and you know them already. Or maybe you had no idea these could be done. Lets see how many of these you know already.
Microsoft Dynamics GP User Training Notes
By: Andrew Karasev | 06/01/2010 | SoftwareThe best results in user training for your Corporate ERP application could be achieved if trainer role is performed by your original Dynamics GP Implementation consultant. In that case you do not have to waste your users time and concentration on the features and procedures, which are not directly related to their day to day Dynamics GP data entry routines
Microsoft Dynamics GP 2010 Payroll Tax Update Notes
By: Andrew Karasev | 05/01/2010 | SoftwareIf your organization processes US Payroll internally in Microsoft Dynamics GP 10, 9.0 or earlier version: GP 8.0, 7.5, Great Plains 7.0, 6.0, 5.5, 5.0, in this small publication we would like to review annual Payroll Tax rates update methods.
Microsoft Dynamics GP: Recovering Failed Implementation Notes
By: Andrew Karasev | 04/01/2010 | SoftwareYour Microsoft Dynamics GP (Microsoft Great Plains, Great Plains Dynamics or Great Plains Accounting for DOS, Windows or Macintosh), not successful implementation story might be not unique. GP is mid-market Corporate ERP application, where industry expertise might be required, plus profound technical exposure for your chosen Dynamics GP Partner. Of course, if you are insisting on coming through quick Sales cycle, there is often a temptation to sell you Dynamics GP software license...
Exporting Data from Dynamics GP Notes for Consultant
By: Andrew Karasev | 03/01/2010 | Information TechnologyThere might be situations, where you need to extract info from Microsoft Dynamics GP (formerly known as Great Plains Dynamics or Microsoft Great Plains) table. In this small publication we will describe you two scenarios. First, when you need one tame data export for following data conversion into future Corporate ERP accounting system (when you are walking away from Dynamics GP to something like SAP Business One, Oracle eBusiness Suite, etc.), and second - when you need ongoing data export
SAP Business One Full Service in Chicago and Atlanta Consulting Notes
By: Andrew Karasev | 02/01/2010 | SoftwareThis small and mid-size business Corporate ERP and MRP application is relatively new on US accounting software market, however it is so flexible and robust (plus it has SAP brand, which is important in the sense of reliability and future commitment), that it provides tough competition to such traditional lower mid-market Corporate ERP applications as Microsoft Dynamics GP (formerly known as Great Plains Dynamics), Microsoft Small Business Financials (this small business corporate ERP...
Great Plains US Payroll Tax Update Service Notes
By: Andrew Karasev | 31/12/2009 | SoftwareFor customers on older versions of Microsoft Dynamics GP, Great Plains Dynamics and eEnteprise, in the case when you are processing Payroll internally (including W2 printout and mailing to your employees) - we would like to let you know that it is possible to update Federal, State and Local Taxes directly in Dynamics GP Payroll tables. We traditionally offer this service at the end of the calendar year, or in January at your convenience.
Microsoft Dynamics GP Applying Service Packs Technology
By: Andrew Karasev | 30/12/2009 | SoftwareIf your organization deploys Microsoft Dynamics GP Corporate ERP, formerly known as Great Plains Dynamics, Microsoft Great Plains, we would like to review new Service Packs applying technology in this small publication, especially after hearing opinions from former Great Plains Consultants, who are now working in Industry IT departments.
Migration to SAP Business One from Great Plains Accounting Notes
By: Andrew Karasev | 30/12/2009 | SoftwareThere are still customers, who are on Great Plains Accounting for DOS, Windows or Macintosh, typically versions 9.5, 9.2, and earlier. When Great Plains Software encouraged its GPA customers to convert to Great Plains Dynamics at the end of 20th Century (as there was a concern of GPA not being year 2000 compliant, plus support for GP Accounting was about to expire those old good days), large number of GPA customers followed the advise and migrated.