Gps Hood

Recovering Dynamics GP: Looking for Second Opinion

Corporate ERP implementation has some percentage of failures or stalled projects, where you need to think about changing original consulting firm.  It is often difficult to say who is the cause of failure – ERP reseller typically tries hard to keep good reputation, however there might be learning curve exposure.  Also if VAR doesn’t know your industry it may suppose that consultant will learn the specifics as project progresses.  Through the long years of consulting career, implementing such applications as Great Plains, SAP Business One, Solomon, Microsoft CRM, we found out that there are typical scenarios, where implementation failure risks increase dramatically.  Let’s review these scenarios and try to recommend practical steps in getting second opinion to get project recovered and finally implemented:

1. Scenarios, potentially leading to the failure or limbo.  The “champion” here is likely unrealistic data conversion.  If you are migrating away from small business accounting package, such as QuickBooks, Peach Tree, MYOB, SAP B1 to Great Plains and you are willing to “migrate everything” – the consulting firm might be optimistic (to get budget approved for data export, massage and migration).  But the project scope, its technical challenges might be underestimated.  Data conversion tool of choice is Integration Manager.  If you would like to “migrate everything”, then you would need to export all your historical documents, create all the fiscal and calendar years in GP, matching your old accounting years, import documents and then post them to open and historical tables.  Then you need to close the years, now considered as historical in GL and in modules.  If you have several GB of historical accounting data files, the process might be not realistic.  When you are considering data conversion, we recommend you first think about minimum of what is really required.  For example, consider just Chart of Accounts and master records (Employees, Vendors, Customers, Addresses) and then just GL beginning balances

2. Unrealistic Customization Requirements.  Second problem is unrealistically complex customization requirement.  Generally it is good idea to pick your new Corporate MRP, Accounting or ERP system using criteria to provide maximum in standard business logic and only tiny fraction in ISV add-ons or custom programming.  If your modification estimation alter ten percent or more of the existing logic (or create new logic) – you should rethink your decision making – maybe you need to align your processes along standard logic or consider another ERP package.  We also heard from customers that they are successful business and they can “afford” programming budget.  Unfortunately we were also participating in recovering from such situations, where initial consulting firm spent hundreds of hours in coding, debugging, deploying Dexterity or eConnect custom modules and the project went into limbo

3. Integrations or Data Migrations with direct SQL Insert statements.  This one is very popular, especially when you have SQL enthusiasts in your IT department.  Well, Great Plains is open for ad hoc SQL queries, however its business logic is complex and vulnerable, if you are doing it on the SQL queries level.  Think about the following – you just graduated from college, have dozens of thousands as college debt and bought your first used car.  You were able to drive it couple of thousand miles and got it broken.  If you just open the hood and try to add extra oil stop leak solution (as you may think that three bottles of the fixing solution should work better comparing to just one dose) – the chances are high that you will simply kill one of the cylinders.  This is the same, when you are not really sure how your Corporate ERP application data is distributed across SQL Server tables and you are trying to fix the data directly in SSMS

4. Looking for second opinion.  This is OK.  When your original implementation consultant gives up and let you go – you are still own the software licenses and would like to preserve the investment.  You also probably invested into SQL Server licensing and Server hardware.  All you need to do is to seek second opinion, select new consulting firm and finish the project

5. Orientation Session for the customers, who are trying to find the ways to upgrade old Great Plains version to Dynamics GP 2010/11.0.  Technically every version of Great Plains ever released has upgrade path, including Great Plains Select on MSDE 2000, Pervasive SQL 2000, Ctree as well as even Great Plains DOS, Windows or Mac versions of early, mid and late 1990th.  If you are on the version earlier than 9.0, please be ready to have two or more version update steps.  The best way to understand your migration path is to visit Microsoft Customer Source and search knowledge base.  If you do not have active annual contract with Microsoft Business Solutions, you Customer Source account is suspended.  In this situation, please call your Great Plains consultant, or if you are now sure who is it – feel free to contact our office.  If you are on the version on Pervasive SQL/Btrieve or Ctree database – there is migration tool, which should move you to Microsoft SQL Server (and you resume upgrade from there)

6. Special Attention to Great Plains Accounting on DOS, Windows or Mac: 9.5, 9.2, 9.1, 8.0 and earlier.  This archaic Corporate ERP application could be redeployed on Windows 2003 or Windows 2008 Small Business Server 32 bit edition (it is important that you understand that it is not compatible with Windows Server or Workstation of 64 bit edition, such as Windows 7 64 or Vista 64).  In earlier 2000th MBS recommended redeploy GPA on Pervasive SQL 2000 DB platform.  And this is understandable, as originally Great Plains Accounting for DOS, Windows or Mac was based in Btrieve (Pervasive SQL is Btrieve successor)

7. Well, now you may expect after reading this publication – we are happy to provide second opinion and help you with failed initial implementation, customization, data conversion, reports design or upgrade.  Feel free to visit our website if link is available below, or call our office.   Internet articles are often syndicated, where About Author section is omitted, if you got us through such syndication, please visit EFaru website

Hood River, Oregon & South Central Washington Trail Map Known worldwide for its windsurfing conditions, the Hood River area has long been a mountain biking destination as well. With its incredibly varied and spectacular natural terrain, as well as a challenging local freeride area, mountain bikers of all abilities will find appealing trails on this map to match their skills. In addition, many hiking trails in adjoining wilderness areas are shown as wel…

Turismo Carretera Stock Cars Argentina for PC $11.97 Powered by the award winning rFactor racing engine and officially licensed by the ACTC racing league of Argentina, Turismo Carretera brings exciting stock car racing action of South America to life on your PC. Turismo Carretera features authentic cars, drivers, paint-schemes and sponsors from the 2006 and 2008 racing seasons. Turismo Carretera includes proper flag rules and accurately modeled race…

National Geographic TOPO! Weekend Explorer 3D (Salt Lake City Area, Wasatch Range, Uinta Mountains) $8.99 Enjoy the ultimate topographic map experience for your weekend outdoor adventures with the GPS-ready TOPO! Weekend Explorer 3D from National Geographic. This interactive software lets you print photo quality USGS topographic maps of the Salt Lake City area, as well as the Wasatch Range and Uinta Mountains so you won’t miss a thing on your excursion. Seamlessly scroll across topo maps covering key …

National Geographic TOPO! Weekend Explorer 3D Seattle Area/Central Cascades Map CD-ROM (Windows) $0.01 Enjoy the ultimate topographic map experience for your weekend outdoor adventures with the GPS-ready TOPO! Weekend Explorer 3D from National Geographic. This interactive software lets you print photo quality USGS topographic maps of the Seattle area and the Central Cascades so you won’t miss a thing on your excursion. Seamlessly scroll across topo maps covering key sites and enjoy five levels of m…

Frigidaire 36 Convertible Range Hood – White $125.49 Frigidaire 36″ Range Hood – WhiteWhen it comes to keepingyour kitchen free of cooking odors, frigidaire provides ventilation systems that are as stylish as they are efficient and as powerful as they are flexible. The f30wc19e 30 overhead ventilation systemis packed with practical and attractive features:overhead installation saves space and lets you get all the benefits of ventilation in smaller s…

12-Volt Super Bright 60 LED Work light – 20′ Power Cord $35.01 Take shop-quality lighting with you on the road or over the water. With power supplied from the cigarette lighter in your vehicle, boat or even a jump starter, you can find the source of your trouble or opportunity anywhere. Use it to find a broken part, a leak, or a hook in fishes’ mouth. Has 18 square inches of LEDs (3″x6″), measures 4″x15″x3″ overall and weighs just 1 pound. Top and bottom h…

Lilliput 7-inch LCD monitor with HDMI, YPbPr interface, dedicated high-definition video camera by Koolertron $189.00 Features: -HDMI & YPbPr inputs; -With HDMI input, connecting directly to PC, as a Personal Computer; -With YPbPr & AV inputs, connecting directly to DVD player, as a car entertainment system; LCD 16:9 Aspect Ratio with Max. 1920 x 1080 pixels, good for application for full HD Video Camera in CCTV Monitoring and Making Movies. Specification: -Panel Size :7″ 16:9 TFT LCD -Resolution :800 × 480, up …

Sun Shade Anti Glare Shield Visor for Garmin Nuvi 200W 205W 250W 255W 260W 265WT 285W 680 670 660 610 600 785T 780 775T 770 765T 760 755T 750 880 860 850 GPS $9.89 The Anti Glare Sun Shade blocks unwanted sunlight from the top and sides of the screen. It reduces glare and reflections for better contrast and visibility. The screen visor is lightweight and can be attached to nearly all personal navigation devices having 4.3 inch screens….

ARKON GN111 Garmin Nuvi Auto Sun Visor Mount with 17mm Ball Head $19.95 MOUNTS GARMIN NUVI OR STREETPILOT TO CAR’S SUN VISOREASY TO INSTALL NO TOOLS REQUIREDCOMPATIBLE WITH ALL GARMIN NUVI GPS DEVICES THAT FEATURE THE 17MM SWIVEL BALL SOCKET PATTERNUPC : 047407501112Shipping Dimensions : 10.00in X 6.00in X 2.00inEstimated Shipping Weight : 0.7229…

Zeikos ZE-HLH62 62mm Hard Rubber Lens Hood $2.15 Lens hoods protect against uncontrolled, stray light and unwanted reflections which result in reduced contrast and ghost Images.  In general, the use of a lens hood is recommended because better contrast improves the appearance of the photograph. The lens hood will also shield the front lens element against rain and mechanical damage. Additional Features: Rotates so that you get the e…