Software Information |
Tools for Customizing Great Plains
Microsoft Business Solutions - Great Plains has captured the US market with its integrated business applications for small and mid-size organizations. Its comprehensive accounting and business management capabilities provide businesses with tools to customize various modules of the Great Plains software. These tools have been proven to have contributed to business growth and tighter control over its processes. There are several ways in which customization and integration can be applied to Great Plains applications because of its open architecture characteristic. Integrity of data and performance of processes can also be validated using one of the many tools as listed in this article. So how do we answer the question of Customizing Great Plains? Dexterity Although Dexterity requires the user an extensive knowledge in software development (primarily in C/C++ or Pascal) and experience in scripting languages (VBScript, or Dexterity's own script - SanScript), this proprietary programming language that Great Plains was developed in allows access to all of Great Plains resources such as tables, reports and scripts. With this access, you can manipulate and define triggers such as opening a form or leaving a field. Moreover, it can be used to call up procedures and functions and create new applications without interfering with other customizations already in place and integrate them into Great Plains user interface easily. Dexterity can be installed using CD #2 that comes with the Great Plains 7.5 package. Modifier with VBA Modifier with VBA is one of the simplest tools to have for end-users and developers alike. It uses common graphic drawing techniques which can be used to alter the appearance of a Great Plains application. It can be used to move, alter or delete menus within a window so that you can manipulate the importance of each field. It also allows for addition of new windows or controls or simply rearranging those that exists. This customization tool is safe to use since the original information is stored separately from the modified one. Modifications can also be shared with other users. However, unlike Dexterity, it is not recommended to create new applications with Modifier VBA. Continuum for VBA/Delphi This tool uses Great Plains as an OLE Server. It captures the VB or Delphi code as queried by the user for macro recording. However, we do not recommend it since it is an old technology. Crystal Reports Great Plains comes with its own Report Writer. However, its functionality is limited. Introducing Crystal Reports to Great Plains opens up a whole new world of creating reports. With the use of the Crystal Report Designer Interface, you can easily create complex reports with formatting and grouping just the way you want it - professionally done. Grouped data can be summarized and subtotaled and with its drill-down capabilities, the user can view report data in detail. Crystal Reports also came up with a version for Visual Studio .NET. With all the features of Crystal Reports 8.0, the Visual Studio .NET version gives .NET users the flexibility to share information and reports over the internet. Through the use of Database drivers, Crystal Reports connects to the Great Plains database and accesses the specific data as queried by the user and selects the tables or views according to the user's proposition. In Great Plains, the Tables structure can be found in: Tools > Resource Description > Tables Direct Web Publishing If you're looking to publish your Great Plains information over the Internet, then using Visual Studio .NET is the right tool to use. It allows the deployment of Web-based applications and XML Web Services and can be leveraged by the use of programming languages like Visual Basic .NET, Visual C# and Visual J#. eConnect Integrating data from outside sources, such as your point-of-sale applications, customer relationship management applications and Web services, to your Great Plains application is what eConnect is all about. eConnect can filter data or add script to the business object according to the specified diagram. It enables for limiting the number of values entered in a field or setting a default value for the field. Although eConnect promises integration, it asks for advanced programming skills. It uses a number of different programs including Microsoft SQL Server, Visual Basic objects and extensible markup language (XML). Integration Manager Converting and transferring data (importing) from one database format (ODBC-compliant) to a Great Plains application can be done with the use of Integration Manager. This tool enables the end-user to map the data source to the target field without the need to search from the database tables. SQL queries can also be defined to accompany your integration and data validation. Integration Manager requires development experience with a background in database maintenance, SQL commands and VBA or VBScript to name a few. SQL Queries Microsoft SQL Server is a database engine that gives users tools for creating, configuring and maintaining databases. It is integrated directly into the Great Plains database. Its Query Engine enables you to create statements to call up certain information from the database. Although this is a powerful tool, SQL queries should only be done with experienced hands. One false statement could wipe out your database. The smooth operations of your business depend on YOU. With the right experience and education, these tools for customizing your applications and database can lead your business to a better ground. Need more information? help@albaspectrum.com For customization work and advice, please contact Andrew Karasev, Alba Spectrum Chief Technology Officer. His works include development of applications with the use of Dexterity, SQL, C# .NET, Crystal Reports and Microsoft CRM SDK. Divine Rigor is the Technical Writer for Alba Spectrum Technologies USA ( http://www.albaspectrum.com ), a Great Plains, Microsoft CRM customization company. We are based in Chicago with locations in California, Arizona, Texas, Florida, Georgia, New York and contacts in international markets.
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Adware and Spyware What is 'adware'?Adware is basically software or scripts that are hidden on your computer, that make advertising show up all over the place. It may be an extra menu in your web browser, icons appearing on your desktop, bookmarks or favourites appearing out of no where, and pop up ads that seem to come from no where!What is 'spyware'?Spyware is similar in nature to adware, however I feel its purpose is slightly more sinister. Spyware Definitions List The adware and spyware definitions list is very long. But the definitions listed below are the most common ones. Popular Fleet Maintenance Programs Some companies that are in need of fleet management may choose to utilize the services of a fleet maintenance program. These programs can generally handle all of you fleet management needs. Top Questions to Ask Before Buying a Help Desk & Asset Management Software #5 All your hardware components like Printers, PCs etc come under various maintenance contracts with different maintenance vendors. Do you know which batch of PCs are under warranty & for what number of PCs is the warranty about to expire (so that you can plan for an AMC)? Can you split up & tell how much AMC charges do you pay for each hardware component & how much for each vendor? Can you re-calculate the costs if an AMC with a vendor is to be renewed?#4 Typically your company gets hardware parts and accessories from different vendors. MSN Messenger Is A Sweet Way To Communicate MSN messenger is a pretty cool invention. I mean I'm not really into serious discussions on the email, answers to questions can often take a few days to arrive because people are so busy these days. Instant Messenger Clients If you have been using the Internet for any amount of time you have probably used an instant messenger at some time or another. They allow you to talk to your friends, family and co-workers with the click of a button. Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist There are certain pluses and minuses in both cases and you should make your decision, based on your company needs. We'll give you some hints in this subject and you should know then where to look further. Spyware Protection: A Must for Any Home Computer Now that spyware is the single most dangerous threat to home computers connected to the internet today, getting your hands on some sort of spyware and adware protection is critical. Spyware has outpaced computer viruses in its prevalence, and in the kind of damage it can do to your system. .Net Charts and Graphs Interact with Businesses and Customers Bar charts, bar graphs, and any other chart or graph used in financial statements, inventory reports, sales reports, and a slew of other types of reports have typically been paper reports or online reports depicting various levels of complex information for tracking, investing, planning, and buying. However, until the . Beware of The Pirated Software E-Mail Scams! You have gotten those E_Mails buy software at deep discounts. It is very tempting to save 85% to 95% on your favorite Software Titles. Windows x: Basic Windows "Security" Issues Language development computer:Computer-based method for aiding language development seems like an interesting idea, the trick with this would be in getting the computer to take on part of the role of the human in the checking process.In all computer aided learning applications aimed at the very young, there is a danger that the computer may be seen as a replacement for a human instructor, however computer are notorious for not volunteering information or inability to deal with erratic behaviour. 3 Reasons Why Medical Billing Software is Leading the Way Since technology changes so quickly, it is hard to begin by saying "in the old days . . Getting Technical Support Help Online Sometimes your PC will start acting strange for no apparent reason or a programwhich you use regularly will all of a sudden stop working as it should. Thiscan be a frustrating experience especially if you have no idea where to go forhelp. Business Planning Software Once a business idea is selected, it is highly recommended that we sharpen the concept by a detailed planning process. The result of this step is a comprehensive business plan, with its major components being the marketing "mix," the strategic plan, operational and logistical structures, and the financial proposal. Defining OLAP Solutions and Data Warehouse design This tutorial covers OLAP solutions used by Data warehouses and understanding Data Warehouse design. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. Corporate ERP: Standard vs. Rich functionality - Microsoft Great Plains Traditionally we were considering functionally rich systems, such as SAP, Oracle Financials, PeopleSoft, JDEdwards as the fit for large publicly traded corporation. There might be multiple opinions for the future corporate ERP/MRP systems. Free Software for Newbies and Web Developers Here is some free software tools to help you build your own websites and create web products.Learning new skills is not difficult. Groupware: Answers the 5 Questions of Document Collaboration Every organization which creates collaborative documents, whether they are budgets, presentations, reports, spreadsheets, or other documents recognizes that collaborative efforts are requirement. That collaboration always forces the 5 eternal document collaboration questions: Who? What? Where? When? How? The reason I refer to them as eternal is that every day businesses are faced with these questions and rarely find the answers when they collaborate on documents. 5 Mac Security Tips You Can't Live Without So, you've bought a new Macintosh, and now you may be wondering how to make it safer. There are several things that you can do which will protect your Mac from viruses and hackers. Guide to Software Marketing IntroThis concise article will tell you in plain English how you can promote your software easily and effectively.Submit your softwareI recommend submitting your software to upload. |
home | site map | contact us |