Dynamics GP Partner News: Getting Second Opinion in Great Plains Implementation Computers Articles | September 21 Lukasz Piszczek Trikot , 2009 We saw multiple scenarios, where Corporate ERP implementation goes into limbo phase and you think that this system might be not the one you need. ?In our opinion - over 90% of these Corporate ERP implementation failing cases had rather subjective reasons and could be efficiently recovered if customer would stop at some point and asked for Second Opinion from one of local Chicagoland and Northern Illinois based Dynamics GP Resellers
or even from nationwide firm with strong Great Plains implementation, data conversion, reporting and customization expertise in your industry.? Think this way - Dynamics GP is a tool and Corporate ERP platform, but it allows you to design and organize Accounting, Sales Order Processing, Manufacturing Shinji Kagawa Trikot , Shipping and Receiving, Procurement, Inventory and Warehouse management procedures.? Plus it open through Dexterity, eConnect, Integration Manager, ReportWriter, SQL Server Reporting Services Christian Pulisic Trikot , Crystal Reports and other tools to data conversions, customizations, integrations and reporting.? To implement your new Corporate ERP you would have to probably assign internal Project Manager, plus probably allocate some members of IT team if data migration and customization is needed, and of course you should select the right Dynamics GP Partner, who could help you implement Great Plains as real team of GP gurus.? We are trying to make this article readable for both IT managers and Company Executives, so please take it to consideration and skip the paragraph that is too technical or too philosophical.? Let's come through the most typical Corporate ERP failures scenarios:
?
1.?????? Unrealistic Data Conversion.? We were discussing which topic should go on the first position Maximilian Philipp Trikot , and looks like the "winner" is data migration, massage and conversion.? And this might be also related to lack of management involvement (when somebody from executives orders Dynamics GP VAR to convert "everything" and period) as well as to some learning curve from your Dynamics GP Reseller sales engineering team, where they say Yes to all customer requests in their desire to push Software Licenses Sale through (better approach would be to set the right expectation and explain recommended and possible levels of Data Conversions, their cost and potential risks).? We described Dynamics GP data migration in previous publications, however here we would like to give you summary.? You should first consider to convert only master records (customers, vendors, GL accounts Mahmoud Dahoud Trikot , employees, addresses) and GL balances and leave your old Accounting system (QuickBooks, Peach Tree, etc.) for data inquiry only to secure possible strategies for future audit and IRS compliance.? If you must have some GL history - consider only current year and only monthly balances - this exercise is possible via Dynamics GP Integration Manager via ODBC connections to your legacy Corporate ERP data base or to exports in text files from legacy accounting, the most typical case is when you are migrating from QuickBooks.? Migrating "everything" to Great Plains is very costly and very risky, as GP business logic and tables structure are complex
?
2.?????? Unnecessary Deep Modification.? Great Plains already has pretty rich mid-market Corporate ERP and MRP applications business logic and first you should try to cast your business processes in Dynamics GP setups and procedures.? We recommend you to be certain and not accept shortcuts approach, when if process is not apparent Sebastian Rode Trikot , realize it via Dexterity, Modifier or eConnect customizations.? However if customization is required, please check with your Dynamics GP Partner that they have reasonable experience to accomplish it for you, versus try it first time and come through learning curve with facing most of the potential Great Plains Dexterity programming pitfalls
?
3.?????? Integration with Legacy System limbo.? Often you may have something from non Microsoft World: Oracle Based Sales Order Processing system, EDI, PHP MySQL and Linux based eCommerce web application.? Typically to integrate the two you would need consultants who are either cross trained or consulting team with expertise in both platforms
?
4.?????? Crystal Reports limbo.? Industrial reporting tools, such as Crystal Reports Sergio Gomez Trikot , SSRS also require reports developer to have reasonable experience and exposure.? If developer is novice and tries all sorts of Wizards - results might be disappointing.? Professional reporting for Corporate ERP applications requires data query abstraction from the tool itself.? In the term of Crystal Report for Dynamics GP it means that report should be based on SQL Stored Procedure or at least on SQL View, and these techniques are crossing the boundaries of apparent reports wizards
?
5.?????? Process Manufacturing.? If you were pushed in GP sales phase with the promise to implement Process Manufacturing, you probably should slow down, as Microsoft Business Solutions really features Axapta Dynamics AX as process manufacturing Corporate ERP option: food, meat and poultry processing, farmers associations, mining Manuel Akanji Trikot , drilling, energy, oil and gas, etc.? Dynamics GP Manufacturing Suite is for so-called Discrete Manufacturing
?
6.?????? Great Plains Upgrade Limbo.? If you are migrating from really old version, such as Great Plains on Pervasive SQL or Ctree: 7.5, 7.0, 6.0 Jeremy Toljan Trikot , 5.5, 5.0, 4.0 or even from Great Plains Accounting for DOS and Windows, you should be aware on the possible problems.? For example Intellisol Purchase Order Processing was recommended in time (2002) to be migrated to Great Plains Purchase Order m