June 4, 2019


ERP Conversion Best Practices

ERP conversions can be an incredibly stressful, complex project for even the best organized busienss.

XTuple provides a useful checklist when considering a conversion project:

Planning Phase

  • Release Notes — review the release notes for the releases up to the release to which you are migrating
  • Timeline — create a time line for training, piloting, and cutover
  • Resources — identify the key resources that required during each phase and ensure they are available and scheduled
  • Enhancements Catalogs — create a catalog that includes:
  • Reports — list all report definitions that have been enhanced (grade > 0)
  • Custom Reports — list all report custom report definitions
  • Scripts — list all custom stand  alone customized scripts and if applicable associated screens
  • Packages — list all custom and customized packages and the screens they impact
  • Business Process Flows — create or update all Business Process Flows ensuring that these encompass all business processes and all enhancements in the Enhancements Catalog
  • New Functionality — review new functionality in the destination release and update the Business Process Flows to incorporate these changes
  • Updater — acquire the latest version of the Updater application

Pilot phase

  • Backup — create a backup of the production database
  • Pilot Database — restore the backup to a migration pilot database
  • Migrate Pilot — migrate the pilot database to the desired release
  • Correct Data — correct any data issues discovered during the migration process and document these in a Data Correction List so that you are ready to apply them during the production migration process (this link can help correct problems found during migration
  • Execute Process Flows — execute the updated Business Process Flows
  • Validate the screen based outcomes for each process flow
  • Validate document based outcomes (e.g. Purchase Order, Packing List, Invoice) for each process flow
  • Remediation List — create a list of problems with enhancements and reports that were found during the pilot phase
  • Privileges List — create a list of users / groups that will need new privileges after migration to the new release
  • Remediate Enhancements and Reports – fixed problems listed on the Remediation list
  • Final Pilot — execute the Business Process Flows with the remediated Enhancements and Report
  • Training — train end users on the new release

Cutover Phase

  • Logoff — logoff all users and deny access
  • Backup — create a backup of the production database
  • Correct Data — apply the data corrections discovered in the pilot phase and documented in the Data Correction List
  • Update — migrate the production database to the new release using the Updater
  • Remediate — remediate enhancements and report definitions based on the Remediation List created in the Pilot phase
  • Deploy ERP Client — deploy the client to end users
  • Update Privileges — update privileges for Users and Groups
  • Logon — grant end user access
  • Monitor — monitor production processes in accordance with the Business Process Flow document

The amount of time it takes to migrate from one release to the next depends on several factors and can vary from a couple of days to a few weeks. The number of enhancements — such as extension packages, standalone scripts, and changes to reports — will have an impact although these may work perfectly in the next release. The piloting phase will determine this. Also, maintaining up-to-date Enhancement Catalogs and Business Process Flows between releases accelerates the process. All this, along with the use of a good checklist will ensure the migration goes smoothly, is safe, and stays on schedule, just like a good flight.

Related post