Software Information |
Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect - Overview For Programmer
Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. It has multiple customization/modification/reporting tools. Currently there is upgrade campaign to version 8.0 and due to the discontinuation of the technical support for Microsoft Great Plains Standard on Ctree and Pervasive SQL - we see substantial increase in migration needs: migration from ctree/Pervasive to MSDE/MS SQL Server. This in turn increases interest to customization and customization upgrade. If you are developer who is asked: how do we customize Great Plains - read this and you will have the clues on where to look further. 1. Great Plains Dexterity - this is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. Nowadays, however - and this is a good thing - most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures. 2. Modifier with VBA. Unfortunately you have to purchase this tool and get new registration keys. If you are familiar with VBA customization for Access or Excel - you have all the skills needed - then you just attach your scripts to the buttons and fields on GP forms (you can modify these forms with Modifier - or just tough them with it). 3. Continuum for VB/Delphi - we don't recommend this tool, because it is using Great Plains as OLE server - and you probably don't want to be trapped by old technology. 4. Crystal Reports. Great Plains has its own ReportWriter, but its functionality is limited - you can't do cross modules reports (you can't link Sales and Purchasing tables in one report, for example). So - you use Crystal. The GP tables structure is in Tools->Resource Description->Tables ? and you are in control. Feel free to create views and stored procs directly in the companies databases - it doesn't hurt the Dexterity engine 5. Direct web publishing from Great Plains SQL databases, using Visual Studio.net and your language of choice (VB.Net, C#, J#, etc). Plus you probably want to have several SQL stored procs. 6. eConnect - this tool is type of SDK with VB.net samples. It allows you to feed data into Great Plains and was primarily created for eCommerce developers. 7. Integration Manager - it is end-user tool for importing to GP, however if end-user meets some challenges in the integration - you as a developer can help with VBA scripts. IM validates 100% of business logic and uses hidden GP forms - so it maybe slow for big on-going integrations, when you have thousands records per day - in this case you rescue to eConnect or directly to SQL store procedures. 8. SQL queries - as a developer you have unlimited potential in using SQL queries, because the database in MS SQL Server. Be careful, it is kind of surgery - you can easily delete all your customers, by executing: DELETE RM00101 Happy customizing! if you want us to do the job - give us a call. About The Author Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, Georgia, New York and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. 1-866-528-0577! help@albaspectrum.com
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Is Software Tester a Most Infamous Person in a Software Project Team? The fact that a software tester is a most infamous person in a software project team has some grounds underneath it. This is because a software tester usually speaks of the bugs in the developer's code. Unofficial Windows 98 SE Service Pack 2.0 RC2 Microsoft has never released a service pack for Windows98 SE, but I made a Service Pack for Windows98 SE users.It contains all Windows98 SE updates from Windows Update site and more. Microsoft Great Plains PM: Payables Management Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).Great Plains Payables Management (PM) module improves control over your payables. IBM Lotus Domino or Microsoft Exchange? IBM Lotus Domino or Microsoft Exchange?The severe competition continues for many years between two main leaders in collaboration solutions - IBM and Microsoft. Whether the choice of a platform influences the ordinary user? The both of software giants put efforts to improve working conveniences for end Internet users. How a Bug Challenges to a Software Professional It is really interesting that a bug can create problem for a learned person even the bug is not alive. One day my one friend was working and a bug created much problem. ERP Implementation: Success Factors As seeing large number of implementations - in our case these are Microsoft Business Solutions Products: Great Plains, MS CRM, Navision - we would like to give you our opinion on what should you consider to do to secure implementation success. These principles should work as for large corporation as well as for midsize and even small business. 40/sec to 500/sec IntroductionSurprised, by the title? well, this is a tour of how we cracked the scalability jinx from handling a meagre 40 records per second to 500 records per second. Beware, most of the problems we faced were straight forward, so experienced people might find this superfluous. Microsoft CRM or Siebel Siebel is traditional CRM market leader, however and mostly due to recession 200-2003, Siebel lost sizable portion of CRM market to new tiger, such as Microsoft CRM. Microsoft CRM s recent (2001) CRM answer from Microsoft and attempt top get market share from traditional vendors: Siebel, Oracle, Onyx. Great Plains Dexterity Programming - Overview For Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Why Stick With Email Clients Like Outlook? Trying to figure out a stream in banning one email client or another is no easy job. As soon as somebody rises up saying Outlook is bad, somebody else comes saying it's good and the other one is bad. Microsoft CRM Lotus Notes Domino Connector FAQ Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being two groupware products from competing software development leaders, however could coexist within one organization computer network and even work together in collaboration. There maybe multiple reason why corporation would use both products: licensing, commitment to IBM Lotus Notes as legacy product, risk balancing - staking on both Microsoft and Java/EJB/J2EE platforms, deploying Lotus advanced workflow to automate document management, etc. Implementing Microsoft CRM: setup and configuration - notes for IT specialist Microsoft Business Solutions CRM is web-based CRM application, deploying all the spectrum of recent Microsoft technologies. We'll try to analyze different needs and implementation scenarios attributed to specific industries and business types, based on our experience. International Support - Microsoft Great Plains VAR/Partner Selection - Overview for V.P. IT Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. It seems to be goof solution for mid-size and even large multinational corporation with Headquarters in US and branches Worldwide. Is Your Small Business Ready For A CRM Software Solution? I have yet to see a business that, sometimes in spite of themselves, didn't benefit from implementing a Customer Relationship Management (CRM) or a simpler Contact Management software solution.Your small business might be the rare exception, but if you can relate to some of the following scenarios, you may be ready to take advantage of the improved and inexpensive CRM systems coming on-stream. The Secret of the Layer Styles Dialogue When you double-click a layer in the Layer Palette, you will access the Layer Style dialogue box. Here, you can set many eye-catching layer styles such as Bevel & Emboss, Drop Shadow, Inner Shadow, etc. Does Microsoft have any real competition? Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory S. Diehl In a word, yes. Microsoft Great Plains Implementation - Overview for IT Director/Controller What is installation in the language of technology? Installation has server and client sides. Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases. ERP Software Financing: the Future? - Overview for Company Owner In our case - we serve Microsoft Business Solutions ERP and CRM products: Microsoft Great Plains, Microsoft CRM, Navision, Microsoft RMS, as well as we do customization and integration to these products. We would like to share with you our experience with financing through Microsoft Financial Corporation, the entity handling software financing for Great Plains, CRM, Solomon, Navision & Axapta. Five Steps to Rapid Development with TierDeveloper 4.0 Follow the steps below to quickly design, generate, and deploy a great portion of your real-life N-Tier application.STEP 1: HAVE YOUR DATABASE READY1. Ukraine: a Prospective Player on the World Software Outsourcing Market The destruction of the Soviet Union about 15 years ago, made a huge country with a great level of IT science divided into small bricks. Nowadays, despite Russia's expansion into the world software development market, Ukraine keeps playing an important role here too. |
home | site map | contact us |