|
|
| www.1001TopWords.com |
|
|
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
|
|
|
|
RELATED ARTICLES
A Simple Computer Software Definition What is Software? Begun, The Browser Wars Have As Mozilla Firefox nears 10% market share, with well over 25 million downloads direct from the makers website, and goodness knows how many through other sources, Microsoft announces that it will be releasing IE 7 ahead of schedule. Originally scheduled for release with Microsoft's new Longhorn operating system in 2006, it seems that Microsoft are reacting to the run away success that Firefox has had over the last few months. But is Microsoft's announcement just a response to Firefox's success, or is it truly a commitment by the software giant to improve the browsing experience of the masses? Lotus Domino Implementation and Development: Infrastructure ? Present and Future Domino server is a buffer between the operation system and the application. On the other hand Domino server ? consists of the services which support development processing and executing of dynamic, secure applications for Internet, Intranet, or Extranet. Domino server role is to provide functionality both: within and between Domino-applications. Domino services interpret codes and elements of application and execute them over actual operation system. Each service is specially optimized for its specific role when Domino is activated for effective functioning of the whole application. How the Firefox: How to... Manual Helped Me A few months back I really got sick of my computer always being slow and having system errors. So I started doing a bit of research and heard of a new browser called "Firefox". eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains eStore Advantage allows front-office applications to communicate with back-office business environments. It has a built-in support for electronic payment processing, and serves as a core integration platform for Nodus Technologies front-to-back office connectivity suites including RMS and CRM Advantage. Free Program Removes Spyware not Detected by Premium Security Scan What is Spyware? Antivirus Software ? Get The Bugs Before They Get You! You turn on your computer, and it doesn't look quite right. Maybe your icons have changed, or the background picture is wrong. Some options are disabled. Even worse, you may not be able to boot your computer up at all. Guess what ? it's probably got a virus. 10 Ways to Learn a Software Following tips help you to learn a software in lesser time and in an efficient manner: What is Fleet Maintenance Software? Simply put, fleet maintenance allows companies to monitor and maintain their fleets of commercial vehicles more efficiently. 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. Spyware, Adware, etc. -- Terms and Common Sense When reading an article where some term is used often, it is useful to make sure the author of the article and you mean the same. Not surprisingly for those who still remember English lessons at school, every noun ending with "ware" is a mixture of objects having something in common--usually used for similar purposes. So it tends to be when "ware" is short for "software"; sometimes it's pretty tricky to define exactly what kind of software it includes and what these programs do. 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). 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. 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. Tracking vehicles, keeping up with maintenance, handling fuel budgeting and logging work are among a few examples of what fleet maintenance programs can offer your company. Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. You should probably expect some issues when you have software development company to be bought by big player - in this case Great Plains Software was bought by Microsoft (Bill Gates was a friend to Doug Burgum - owner and leader of Great Plains Software - Great Plains Dynamics/eEnterprise). We certainly have some influence level in Microsoft Business Solutions, but what happened is out of our decision level and this is really sad story. Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware Spyware and malware are large problems for Internet users today and can be both annoying and a real threat to you and your computer. There exist a number of different spy and malware of which some are relatively friendly and only spies on your surfing habits, while others like the Trojans can be used to corrupt your hard drive or steal your usernames and passwords. A Trojan can even be used to steal your identity by extracting all necessary information from your computer. How To Make Good Use of Spreadsheets Most computer users use spreadsheets software such as Microsoft Excel in their daily home and office. However very few are aware of the potential of spreadsheets in helping them in financial accounting and statistical analysis. Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview In the case when you represent mid-size or mid-size-to-large business, it is not a surprise that you have to do ERP selection and switch to new technologies, doing your own research. If you a trying to stay with Microsoft technologies and try Microsoft Business Solutions products: Microsoft Great Plains, Microsoft Navision, Solomon, Axapta with integration to Microsoft CRM, you should know the history of Great Plains Software and Navision partners over the last 10 years. Microsoft CRM Integration & Customization: SharePoint Document Gateway MS CRM is very close to document workflow automation, including Microsoft Office documents: Words, Excel, etc. The document workflow was perfectly automated about 10 years ago in Lotus Notes Domino. In this small article we describe the solution based on MS CRM integration with MS SharePoint. Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity Requirements Planning, Job Costing, Master Production Scheduling, Materials Requirements Planning, etc. However Microsoft Great Manufacturing serves so-called discrete manufacturing market niche. At the same time Great Plains fits to mid-size companies, where manufacturing processes might be categorized as light assembly. One of our clients, mid-size crane trucks manufacturing facility recently outsourced all the parts assembly to overseas partners and concentrated on sales, distribution, leasing and only light final assembly. This small article describes you how you could deploy Microsoft Great Plains Bill or Materials in process manufacturing. We will describe combination of Sales Order Processing (SOP) module to get customer orders, Bill of Materials (BOM) to assembly for the order, Inventory Control (IV) to allocate materials and Purchase Order Processing (POP) to replenish inventory
|
| © Athifea Distribution LLC - 2013 |
