Software Information |
|
Great Plains Dexterity Customization Options ? Overview For Developers
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. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. If you are developer who is asked: how do we customize Great Plains with its native programming language ? Great Plains Dexterity ? read this and you will have the clues on where to look further. The history of the Dexterity. 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. 1. Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases ? you use Dexterity ranges and loops to manipulate the records 2. Great Plains Dexterity with SQL Stored Procs Nowadays, 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. 3. COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects ? you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet. 4. Dexterity Forms ? if you like VBA and are comfortable to do all the business logic in VBA ? you can use Dexterity as new forms creator/editor. This is OK ? but you have to purchase VBA/Modifier and Customization Site Enabler from MBS. Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary ? DYNAMICS.DIC. If you need cross dictionaries customization ? consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary.. Happy customizing! About The Author Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Texas, California, Florida, 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.
|
RELATED ARTICLES
Groupware as a Document Manager: Collaboration Series #3 This article is the third of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. Some of these characteristics may go hand in hand with business collaborative needs. Other characteristics go beyond what some groupware providers have to offer. The purpose of these articles is to equip the groupware user or investigator with helpful knowledge about the product in order to enable more effective use or to lead the investigator to the groupware service he or she is looking for. This third article explores groupware as a document manager, and provokes a critical approach to finding the right groupware to meet your business's needs. Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexterity. Dexterity in turn was built with conception of graphical cross-platform transferability (in time ? 1992 ? mostly Mac and MS Windows). Plus Dexterity had database abstraction level (through C programming language). The result of such a shrewd future-looking architecture ? Great Plains ReportWriter has multiple restrictions and drawbacks. Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains We would like first emphasize the change in the paradigm. If you look back ? 20 years or even 10 years ? those days you saw ERP/MRP monster applications/systems winning time. Everyone wanted to be looking large and, especially due to traditional business consulting sales efforts ERP applications were sold to large and mid-size clientele. The proposed strategy was: you need three components: 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. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. My Experience - Making a Vision into Reality Disclaimer: All the thoughts expressed are my views only! Your perception might differ... A Simple Guide To Wikis A wiki is an editable text-based website. But you don't need to understand any complex HTML, or anything like that to use a wiki. A wiki is really only a little bit more complex than a word-processor, but MUCH more powerful, because instead of only being 1 page, it can be lots of pages, all linked up together. Lotus Notes Domino and Web: Application Development ? Tips for Programmers Beginning with Domino version R4 it has integration with the Web, and the server itself becomes a HTTP-server. The next releases of Domino Web-server add new functionality (for example servlet managers, supported JVM versions upgrade, etc). To give you general picture and abstracting from details we'll talk about two major Domino Web-server functions: Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Being matured product ? Great Plains provides such horizontal solutions as Collection department automation. The most common question we hear in collection department is how we assign problem clients to specific collection manager and how she/he works with them one by one, simply by hitting next arrow button. This is not possible in Great Plains Accounts Payable module and this is where Collection Management module comes to the scenes. IBM Lotus Domino or Microsoft Exchange? IBM Lotus Domino or Microsoft Exchange? 10 Ways to Learn a Software Following tips help you to learn a software in lesser time and in an efficient manner: Review of TikiWiki Content Management System TikiWiki is open source software - it is written in PHP, uses phpAdmin for mySQL database administration, and uses the Smarty Template Engine. 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. Can Group Collaboration Software Meet Business Needs? According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric Collaboration," 51 percent of businesspeople utilizing technology such as Microsoft Office and e-mail collaborate almost daily as a part of their business operations and need group collaboration software to support electronic collaboration. HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1 The other options available in this interface are for the particular e-mail account. Explore the Internet in a Whole New Way For a long time now Microsoft's Internet Explorer has ruled as 'King of Internet browsers'. Like many of Microsoft's products an initially brutal marketing campaign pushed Internet Explorer into the mainstream's consciousness and from then on it was the logical, default choice. It's free with the operating system, works well, loads any page and is easy to use. Other web browsers soon faded into obscurity and sometimes even died in the shadow of the new king of the pack. Netscape Navigator, the former 'King of the browsers', has now ceased commercial operations and has been taken over by the fan base. Opera is fading into obscurity and Mozilla was facing a similar fate, until recently. 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. It was not easy to track the bug. evrytime bug was challenging any other different problem. Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview Microsoft Business Solutions Great Plains has substantial market share and strong support by Microsoft on the US market. Currently we see the trend in the vertical markets when companies with custom-built accounting application, usually written on legacy platform are switching to standard and proven ERP solution and customize or tailor it to fit their vertical market requirements. We'll be publishing series of vertical articles: Logistics, Distribution Centers, Warehouse Management, Barcoding, Shipping/Receiving, eCommerce, EDI, Wholesale. Today we'll give you Wholesale tailoring scenario IT Department Skills to Support Microsoft Great Plains and Microsoft CRM Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System.� Being VP IT or IT Director you need to foresee the positions to have in your IT department to do internal MS Great Plains and MS CRM support. Let us give you the directions, based on our research and consulting practice. Microsoft SQL Server Specialist ? we specially do not name this position as MS SQL DBA, because both Great Plains and MS CRM are not very complex from the database administration side, they do not use indexes optimization, referential integrity, probably do not require complex transaction log backup/recovery scenarios.� On the other hand this position requires Great Plains and Microsoft CRM tables structure analysis and some primary Great Plains data fixing skills via SQL queries, described in MBS Customer source techknowledge database.� The best candidate should have some accounting background - to be able to address ongoing issues to MBS technical support. Network Administrator with good Microsoft Exchange and Active Directory skills.� Microsoft CRM uses all the newest Microsoft technologies, and Exchange is a workhorse here.� In order to install and upgrade MS CRM this guy needs to understand the under-laying Microsoft technology.� In the best case - she/he should know Exchange security structure and probably program Exchange handlers, due to the fact that CRM/Exchange connector is not a perfect tool yet. C# or VB.Net programmer with excellent SQL Skills? if you are midsize or large company - you should have this position - you will need web publishing and MS CRM customization and its support.� Currently Microsoft CRM SDK has C# examples - so C# programmer would be the best fit, it may have more VB code in the future, so the C# - VB balance maybe restored. Crystal Reports Designer/Programmer - Crystal Reports is the best tool available on the market to address both Great Plains and MS CRM reporting needs.� This position maybe merged with one of the above. These people should be probably cross-trained in both Great Plains, Microsoft CRM, Crystal Reports, SQL and C# programming, so you do not depend on the unique skills of one person.� In our opinion, which is based on our long term consulting practice - these skills will allow you to keep the cost of IT support reasonably low and avoid paying high consulting price to your Microsoft Business Solutions Partner. Happy hiring and training! But in any case you need to select Microsoft Business Solutions Partner/Var/Reseller to be your official representative.� This is how MBS has its channel working - it assures that Microsoft Business Solutions products are properly implemented.� If you want us to be your Microsoft Business Solutions Partner - give us a call 1-866-528-0577! [email protected] Can You Calculate Complex Financial Calculations? Are you a whiz at calculating financial information? Not the easy personal stuff, like figuring out your monthly mortgage based on a fixed interest rate for x number of years, or how much money you have available each month after all your bills are paid. (You can probably use your fingers to figure that one out!) Groupware and Online Collaboration: Collaboration Series #4 This article is the fourth of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. Some of these characteristics may go hand in hand with business collaborative needs. Other characteristics go beyond what some groupware providers have to offer. The purpose of these articles is to equip the groupware user or investigator with helpful knowledge about the product in order to enable more effective use or to lead the investigator to the groupware service he or she is looking for. This fourth article explores the ability of groupware to facilitate online collaboration. |
home | site map |
© 2005 |