Both Navision and Great Plains should be considered as mature products, have more than 10 years of successful presence on the ERP market. Axapta is relatively new ERP and its was released in the beginning of XXI century. If you would like to pick something from Microsoft, or its ERP subdivision - Microsoft Business Solutions, and in case of large public company, you should consider these three. We would say that this integration is usually programmed on SQL level and XML inbound/outbound streams. This is very typical question for large business.
Typical accounting/ERP systems do not have (or have very limited) workflow design. Special skills are required in order to work with complex ERP system. Why does the company need document workflow system if it has an Accounting/ERP. Lotus Domino/Notes - Microsoft Great Plains tandem as ERP with Documents Workflow - overview for IT Specialist. Also, ERP based reports should be delivered on regular basis.
It is the customizations that transform packaged ERP software into ERP software that meets organizations' individual business processes and operations. ERP projects usually modify the company's business
processes which create extra workload for employees who use them initially. The users of ERP systems are employees of the organizations at all levels. Packaged ERP software modules have built-in functionality that work in a standard and simplified enterprise environment. Most ERP projects involve significant amount of customizations.
Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market.
Create SQL Query to probe the data - we always recommend tuning your query and see that you are getting adequate results - in any case - Crystal Report is just a nice tool to show the results of your query. Net, Crystal Reports and Microsoft CRM SDK developer. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.
Consider SQL Views - if you don't want complex links in Crystal Report itself or if you need unionization from several companies - SQL view is the answer.
Usually each midsize business has unique procedures which should be mapped into their CRM and ERP. Great Plains is good ERP solution for majority midsize business and fits to variety of business niches. If you have something else, besides Microsoft CRM and Great Plains, then you might need the integration. Assuming that your major systems are on the Microsoft platform - integrations should be done via heterogeneous queries from the side of Microsoft SQL server - through linked servers. In the case of Microsoft Great Plains he technology is not that open and you might need somebody with Great Plains Dexterity, VBA/Modifier, Integration Manager, eConnect, SQL coding - this combination of skills is usually available from one of the Microsoft Business Solutions Customization Partners.
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise was originally written in IDE and programming language - Great Plains Dexterity. This is excellent tool and is very popular among web developers - it was originally created for eCommerce programmers who wanted to deploy Great Plains as back office/ERP/Accounting. We understand that this is difficult to foresee when you ask questions to your Microsoft Business Solutions VAR, and also that each ERP has specifics you need to know. Currently Microsoft is on the way of transforming its ERP applications. So - you can not use Dexterity in your web application, you have to stick to stored procedures or eConnect.
Today - accounting department team is comfortable with generic ERP interface and needs minimal training. Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM are coming up to satisfy ERP needs for large corporation, including multinationals. Well - if you remember old-good-days SAP, PeopleSoft, JDEdwards, Oracle ERP systems implementation - you would agree that they required a lot of programmers and developers participation. Multinational corporation has to deal with the following issues. The only requirement is fast internet connection from your and technician side - which is catching up very quickly.
Bill of Materials, ERP Capacity Planning, Cost Center. Good luck and you can always seek our help in customization, implementation, integration and support. Reporting is rather static, but in its prints outs it allows you to avoid expensive license fee (if you decide on SAP or Oracle Financials - this will triple your software expenses. In our opinion the best way to save software money is to replace highly priced module with similar reporting. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( http.
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business Solutions ERP applications, serving to the whole spectrum of vertical and horizontal markets. Don't pay for upgrade as is - you will lock yourself with the problems. Usually you have to find small nation-wide VAR, who serves you via remote support. Ask for customization analysis - most of the old customization pieces should be migrated to new technologies, like Dexterity to SQL and Crystal Reports, web publishing, eConnect, etc. Migrate on your own - or send your data to migration specialist - your partner may provide these services - normal price is 8 hours of consulting fee.
Let's consider the steps required to upgrade your ERP system. This piece is probably the one for outside Great Plains Dexterity consultant or programmer. Great Plains Dexterity is programming language and IDE and the complexity of the upgrade may vary, depending on the quality of customization design and coding and the level of integration with the main application (usually DYNAMICS. Crystal Reports usually do not need upgrade. If you are on Pervasive SQL 2000 or Ctree Great Plains Dynamics or Great Plains Accounting 9.
Good balance would be relatively inexpensive Microsoft Business Solutions ERP application. If we look back to the history of Microsoft Great Plains - Great Plains Dynamics/eEnterprise - it had native programming language / IDE Great Plains Dexterity. Microsoft CRM - this is the temptation and we do recommend it - it could be integrated with Java applications. If you plan to deploy them from Windows side. Great Plains (USA, Canada, Latin America, Middle East, Australia, New Zealand, UK), Navision (France, Germany, Italy, Spain, Brazil, Japan, Russia and the rest of continental Europe), Axapta - if you need rich ERP functionality - then your business specific application.
As all MBS ERPs it has MS SQL Server 2000/2005 database platform and allows you to deploy customizable and altered solution, serving large corporation HR department. Currently we are confident in MS Great Plains ability to automate the following industries. Aerospace & Defense, Chemicals, Oil & Gas, Advertising & Publishing, Distribution & Logistics, Beverages, Supply Chain Management (SCM), Pharmaceutical, Nonprofit, Healthcare/Hospitals, Wholesale/Retail, Manufacturing/Assembling, International Business/Multinational Corporation, Government. We have to tell you here that proposed solution is for large corporate clients only. We certainly understand that placement & recruiting midsize and small market is underserved.
Former versions - Great Plains Dynamics/eEnterprise was also popular in Europe. In Russia we saw dramatic situation, when multiple Great Plains Dynamics/eEnterprise resellers went out of business. Microsoft Business Solutions Great Plains is very popular ERP platform in the USA, Canada (including French speaking Quebec/Montreal), U. In the conditions of Russia you should consider these things and be sure that each ERP vendor is trying to certify their application with the government. Microsoft did it for Microsoft Navision and Axapta (for corporate market.
ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6. Scheduled DTS Package - you should probably create DTS package to do all the steps. Good idea is to write communication application in your favorite programming language. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Colorado, Arizona, New York, Texas, Florida, Georgia and having locations in multiple states and internationally (www. You may have to assign the file directory, exposed to the UNIX system or use old DOS command to move the file, or you can have automatic email.
Now Microsoft Business Solutions offers the following ERP applications. Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta. Using a familiar Microsoft Outlook®-style interface, Business Analytics presents this information to your desk top where easy to use analytical tools allow you to carry out targeted analysis that is tailored by you, for you. XBRL is an XML-based specification that uses accepted financial reporting standards and practices to export financial reports across all software and technologies, including the Internet. I would recommend using this tool for occasional reporting requests only.
|
|