This tool covers a lot of Great Plains objects creation and retrieving functionality, however it does have restrictions, because it was not intended as replacement to Great Plains Dexterity shell. But these legacy Great Plains Dexterity names do not help eCommerce developer - only probably as the reference on which table works with specific screen. Great plains was designed to first serve mid-size businesses and then with the availability of third party modules - the intention was to compete on corporate ERP market with Oracle, PeopleSoft, SAP and others big players. So as you see - logic is present and structured, but it is not friendly to the developer, who never seen and worked with Great Plains Dynamics. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http.
He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C. In the described case we suggest to use SQL stored procedures for calculating checks and Dexterity process server to post checks (creating SQL stored procs for posting would be virtual rewriting 40% of Great Plains Dexterity based payroll module. Currently we are confident in MS Great Plains ability to automate the following industries. Each office should be capable to issue paycheck immediately and the problem is to process and post it in Great Plains. Microsoft Business Solutions Great Plains is very good candidate.
You can purchase simple catch weight module from existing Microsoft Great Plains partner and tune it, using Great Plains Dexterity, Modifier with VBA and SQL Server scripts. This means that Great Plains should give you catch weight routine. Microsoft Great Plains has Inventory Control (IV), Bill of Materials (BM), Manufacturing modules, coming from Microsoft Business Solutions directly, plus it has third party solutions, such as Horizon Light Manufacturing. In Microsoft Great Plains you could deploy eOrder to sell on existing account. Microsoft Great Plains might be considered as ERP platform to build your own custom solution upon or as the assembly place for the existing modules.
Mid-Size partners in Major Business Metros - these companies were classical Great Plains VARS/Resellers with balanced application consulting and technical expertise. Microsoft Great Plains and Microsoft CRM become more and more popular, partly because of Microsoft muscles behind them. Now Great Plains is targeted to the whole spectrum of horizontal and vertical market clientele. It is actually more easy than you may think - you just send the new proposed partner the letter in free format saying that you would like to switch to you as my Microsoft Business Solutions partner - and this is it. Also couple of hints about how do you switch the partner.
Great Plains Integration Manager - if the sales volume is very low, say 100 transactions per day - then you can do data export from RMS and import it into Great Plains via Integration Manager. This integration is currently available for Great Plains version 7. You need to know Retail Management System Headquarters and Great Plains tables structure and data flow. This product allows you to map multiple RMS stores to one or multiple Great Plains companies. Launch Great Plains and go to Tools->Resource Description->Tables.
Dexterity can be installed using CD #2 that comes with the Great Plains 7. 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. It uses common graphic drawing techniques which can be used to alter the appearance of a Great Plains application. Microsoft Business Solutions - Great Plains has captured the US market with its integrated business applications for small and mid-size organizations. 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.
This is Great Plains Dexterity customization or web-development (if you need your agents lookup features from remote locations. We recommend you to deploy Great Plains Integration manager to import Vendor and Customers plus open documents. Great Plains requires consultant help to be implemented and integrated, because it has sophisticated tables structure and documents flow mechanism. You can issue Quote and Sales Order directly in CRM if needed or could have them issues in Microsoft Great Plains with propagation to Microsoft CRM (deploying MS CRM-Great Plains integration tool - BizTalk based connector. Microsoft Great Plains could play this role, being integrated with Microsoft CRM and with industry-specific business system.
Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. Now - you have sudden hurricane - over Florida - somebody who is in charge in Microsoft - but really without clear understanding on what is in stake - this person needs to retune the cheap Great Plains version. Old-days Great Plains Dynamics on Ctree or Pervasive SQL/Btrieve was excellent and inexpensive solution. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, and Miami and having locations in multiple states and internationally (www. Net, Crystal Reports and Microsoft CRM SDK developer.
Beginning Balances - this is recommended approach - you place aside the old accounting application for querying the historical data and enter beginning balances in Great Plains GL, AR, AP, SOP, POP, Payroll. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Washington, Minnesota, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www. Net, Crystal Reports and Microsoft CRM SDK developer. Invoice form, Crystal Reports, pulling info from multiple databases, including Great Plains database, Great Plains forms modification with Modifier/VBA, Great Plains Dexterity forms and logic customization, integration with CRM, RMS and other business systems, web publishing from Great Plains tables, EDI with your suppliers, SQL Data Transformation packages
Do I need consultant? We strongly recommend you to use consultant in the following cases.
System Setup - you should refer to GP documentation.
Have Great Plains partner to trigger you Microsoft promotions on Migrations/Upgrade/Placing you back to enhancement program. Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems. You have a lot or ReportWriter Modified Great Plains Reports. Below we give you your options to support Great Plains with minimized support cost. In the case of mid-size business we usually see strong IT team with SQL querying skills plus accounting department is already trained to use Great Plains and needs minimal help in figuring out on how to use new Great Plains version and features.
Great Plains Accounting is btrieve based application and typical installation has GPDATA (with all the database files in) and GPCODE (with executable code - this code is copied over the network and is executed on each workstation. Great Plains Accounting typical system sits on Windows NT 4. Great Plains Accounting, accounting package for mid-size and small companies was in its peak of popularity back in earlier 1990th. In the case of Great Plains or Great Plains Dynamics/eEnterprise - customer can do self-support. Support for Great Plains Accounting was discontinued several years ago.
But it is seen now - not in 1990th
These two above principles resulted in creation of Great Plains Software development environment and language - Great Plains Dexterity. Pervasive SQL 2000 and Ctree (we are not talking here about Great Plains Accounting - this ERP was phased out in 2001. Andrew is a Great Plains specialist in Alba Spectrum Technologies ( http. All of us know that Microsoft bought former Great Plains Software and formed Microsoft (Great Plains) Business Solutions in the earlier 21st century. It was total success for GPS, we guess, but for Great Plains Dynamics / eEnterprise / Dynamics C/S+ clients it was the time of change.
Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. Great Plains Software marketing campaign was getting very strong resistance from local market commitment to Microsiga and other local ERP application. Great Plains Dynamics was designed for US tax code with US Social security, later on it was adjusted to comply VAT (Value Added Tax) rules to promote it in UK and other countries. Currently MBS officially promotes Navision on the Brazilian market, however localized version of Microsoft Great Plains is available as well. Don't worry, MBS does support it in Brazil via local partner.
This is opposite philosophy - remember old-good-days Great Plains Dexterity - you could not get this EDI free and you needed to purchase training class to get skills in this proprietary programming language. Navision, Axapta, Solomon (Solomon Software was bought by Great Plains Software in the late 1990th. When Microsoft purchased Great Plains Software and formed Microsoft Great Plains Business Solutions (soon renamed into Microsoft Business Solutions) and acquired new ERP/MRP/accounting applications. Microsoft Windows, UNIX, Linux, IBM DB2/AS400/RS6000, Oracle. Corporate clients, including manufacturing, logistics, consignment, international business, distribution - will leverage multiplatform strategy to decrease the risk and increase longevity of the ERP/MRP.
If you launch Great Plains workstation and follow this way. You need to know the anatomy of Great Plains tables structure. Great Plains SOP module is working in concert with Inventory control, making allocation of inventoried items in IV. The first question is - are we allowed to create stored proc in Great Plains DYNAMICS and companies databases. Andrew is Great Plains specialist in Alba Spectrum Technologies (http.
|
|