Data Migration

Data Migration

Three segments of data must be considered – master data, transactional data and historical data.

Most of the master data will come from your existing application; however, the new ERP application most likely has additional master tables and fields that will need to be populated to create a fully functional company.

Master data includes the following:
• Items/Parts
• Customers
• Vendors
• BOMs
• Routings
• Warehouses

Referential data, such as:
• Area (used by Sales side)
• Number series
• Statistical groups


This group of data includes the following:
• Open Accounts Receivable
• Open Accounts Payable
• Open Purchase Orders
• Open Work/Production Orders
• Inventory, Lots

There are several approaches on managing the open orders. Depending on the volume of data and other internal factors, you may choose to handle these transactions in one of the following ways.

Accounts Receivable
1. Migrate open receivables to the new ERP application, or
2. Receive payments in existing system and post adjusting entries in the new ERP application

Accounts Payable
1. Migrate open payables to the new ERP application, or
2. Process open payables in existing system. Hold checks until normal mailing time. Do not enter new vendor invoices in existing system if they will not be paid from that system.

Sales / Production / Purchase Orders

1. Migrate open orders to the new ERP application, or
2. Run a report of open orders. Manually enter the orders into the new ERP application.


Historical data can be dealt with in several different ways.
1. Migrate part of the historical data based on transaction date
2. Keep all of the historical data in your existing application
3. Create a data mart; export all historical data to the data mart and turn off the old application

The benefits to the last approach greatly outweigh the other options. You do not need to keep your existing application up and running to access historical data. This eliminates the requirement to maintain the system and be concerned about user access to the data.


1. Use the training and testing phases of the project to determine the gaps between the old and new applications; identify and validate proposed solutions
2. Implementation of a new ERP application is often the time organizations choose to make changes that have been under consideration for a while or changes where everyone has been waiting for the ‘right time’. Now is the time to evaluate your options.
3. The best way to get a head start on configuring your new production company, which results in a more efficient go-live conversion, is to set up a master company in parallel with the test environment(s).

Some of the ways you can use this master company are:
• As decisions are made on how you want ‘new’ data set-up, populate the master company
• Export the configuration from this master company into pilot test companies
• Validate and test assumptions on the way this master company is configured
• Import the configuration of the master company into your new production company after you have completed the validation and as part of your go-live data migration

Infor 10 ERP

Unleashing INFOR 10 ERP.

“Specialized for Industry, Engineered by Speed”

 A brief overview of the product company

 INFOR Company


1)      $2.5 Billion Total Operation Revenue

2)      3rd Largest Enterprise Application Company

3)      1,500 Partner World Wide

4)      75,000 Customers in 164 Countries Globally

5)      2,300  New Customers in Fiscal Year 2011

6)      3 Consecutive quarters of Double Digit Growth

 Infor10 ERP

Key features

 A)    A user experience to change the way work is done

 Infor10 Workspace

Infor10 Workspace delivers a unified user experience that supports single sign-on, common navigation, and a common look and feel across various Infor products. The user interface combines deep industry processes, analytics, and collaboration to create a more satisfying, easier to use software experience that helps you make better and faster decisions.


Infor10 built mobile technology into the core of Infor10 architecture so that you can combine the benefits of the most widely used mobile platforms alongside web-based methods. You shouldn’t need to compromise when you expand your business software to support mobile applications. Infor10 Mobile Application Server ensures that you always have full industry specific power whenever and wherever you want it.

B)    Best in Class Applications

Infor10 also includes best-in-class applications with market-leading functionality that bring value to any organization, across any industry. These visionary, innovative solutions integrate seamlessly with your core systems to address a broad range of daily business challenges, including:

Enterprise Asset Management—Manage your equipment, facilities, and plant assets throughout their lifecycles, while cutting costs and boosting profits.

 Customer Relationship Management—React quickly, intelligently, and personally to every customer interaction to drive growth and increase    revenue.

 Human Capital Management—Maximize the talent of your workforce to increase your operational efficiency, effectiveness, and insight into your   organization.

  Corporate Performance Management—Analyze data when you need it most and deliver key information to your decision makers.

 Financial Management—Reduce costs, business risk and deliver timely, actionable financial information for improved business insight.

 Supply Chain Management—Be responsive to customer demand shifts and alert to supply side disruption, while keeping your manufacturing and warehousing operations as productive as possible with event management and alerting that help you make those decisions more quickly and accurately.

C)        Reimagining Enterprise Software

 What if integration and business intelligence were implemented automatically with your software? What if your life cycle management was automatic and seamless? What if you had incredible deployment options, leveraging cloud technology-reserving the right to change your mind any time you like? What if upgrades didn’t scare you? What if you didn’t spend all of your time managing your enterprise applications—but instead, could spend your time innovating? What a difference you could make. Infor10 can make it happen.

 Infor10 ION Suite

ION Suite is a new generation of business middleware that is lighter weight, less technically demanding to implement, and built on open standards. It is designed to meet the needs of the business and the needs of the CIO to contain IT costs.  

But there’s more to ION Suite than just easy to use connectivity. With ION Suite, businesses get common reporting and analysis, workflow, and business monitoring with one, consistent architecture. In addition, ION Suite uses event-driven architecture (EDA), so it can pro-actively push data, work activities, and exception notifications to users.

Infor10 Cloud Suite

With Infor10, you get extreme deployment flexibility. If you want simple “IT on demand,” you can run your entire solution on Infor10 CloudSuite. If you’d rather keep your core enterprise systems on-premises, while running your business intelligence as a service, application integration as a service, or a platform for building application extensions as a service, you can do that. Or maybe, you just want a disaster recovery system in the cloud, automatically, without ever having to think about it. Infor10 CloudSuite does that, too.

Infor10 CloudSuite offers the best solution for organizations that want the help of enterprise software without the headache. Flexibility, speed, and simplicity. That’s Infor10 CloudSuite.

For further information visit

Implementing Baan IV from QUE

A Brief transcript/description of the book…

Que’s Implementing BAAN IV is an all-inclusive resource and the only handbook companies need to assess their need for BAAN IV technology and its implementation. It covers everything BAAN administrators, consultants, and corporations moving to a BAAN environment need to know including the system architecture, modules, and business strategies that must be considered prior to implementation.This book will enable system administrators and IT professionals to balance business decisions and implementation strategies to increase efficiency and profitability across their company. Understand how to assess business needs in relation to the BAAN IV solution and identify which modules are right for your company. Once those modules are identified, this reference provides all the training, customization, and migration information needed to achieve a successful and rapid implementation. Implement a successful BAAN IV system with Implementing BAAN IV from Que!

This book can be procured online from Amazon. Visit the following link.

Full ERP Baan IV Document

Surfing over the internet for some rich Baan Documentation, we came across this site which promises to provide you Full baan IV ERP Documentation. The Author G. John Sagmiller who is certified in Baan and has over 15 years of rich experience has compiled this over 10,000 pages of contents, comprising of over 4.5 million rich words. This ebook should be able to provide you all that you need to get you up and running with Baan IV ERP.

Some of the topics that is covered in Part 1 of the Book is

ERP Baan IV – BAAN Common
ERP Baan IV – MCS – Tables
ERP Baan IV – COM – Common Data
ERP Baan IV – COV – Conversion to BAAN IV
ERP Baan IV – EDI – Electronic Data Interchange
ERP Baan IV – GLO – Global Localization
ERP Baan IV – QMS – Quality Management System
ERP Baan IV – Constraint Planning
ERP Baan IV – RPD – Resource Planning Data
ERP Baan IV – RPU – Resource Plan Units
ERP Baan IV – RMP – Resource Master Planning
ERP Baan IV – CLP – Cyclic Planning
ERP Baan IV – Distribution
ERP Baan IV – CMS – Commission/Rebate Control System
ERP Baan IV – GLO – Global Locatization
ERP Baan IV – ILC – Location Control
ERP Baan IV – INV – Inventory Control
ERP Baan IV – LTC – Lot Control
ERP Baan IV – PUR – Purchase Control
ERP Baan IV – RPL – Replenishment Order Control
ERP Baan IV – SLS – Sales Control
ERP Baan IV – SMI – Sales and Marketing Information
ERP Baan IV – Finance
ERP Baan IV – GLD – General Ledger
ERP Baan IV – ACR – Accounts Receivable
ERP Baan IV – ACP – Accounts Payable
ERP Baan IV – CMG – Cash Management
ERP Baan IV – CAL – Cost Allocation
ERP Baan IV – FBS – Financial Budget System
ERP Baan IV – FST – Financial Statements
ERP Baan IV – FAS – Fixed Assets
ERP Baan IV – PAR – BAAN Finance Parameters
ERP Baan IV – GLO – Global Localization
ERP Baan IV – Manufacturing

and the ones which are covered in the 2nd part of the book is

ERP Baan IV – EDM – Engineering Data Management
ERP Baan IV – ITM – Item Control
ERP Baan IV – BOM – BOM Control
ERP Baan IV – ROU – Routing
ERP Baan IV – CPR – Cost Accounting
ERP Baan IV – MPS – Master Production Scheduling
ERP Baan IV – MRP – Material Requirements Planning
ERP Baan IV – CRP – Capacity Requirements Planning
ERP Baan IV – RPT – Repetitive Manufacturing
ERP Baan IV – SFC – Shop Floor Control
ERP Baan IV – HRA – Hours Accounting
ERP Baan IV – PCS – Project Control
ERP Baan IV – PCF – Product Configuration
ERP Baan IV – GRT – Product Classification
ERP Baan IV – PAR – BAAN Manufacturing Parameters
ERP Baan IV – BRG – Enterprise Modeler
ERP Baan IV – EIS – Enterprise Performance Manager
ERP Baan IV – BAAN Process
ERP Baan IV – FRM – Formula Management
ERP Baan IV – ROU – Routing
ERP Baan IV – PMG – Production ManagementKeywords
ERP Baan IV – BAAN Project
ERP Baan IV – BOP – Project Estimating
ERP Baan IV – PIN – Project Invoicing
ERP Baan IV – PTC – Project Budget
ERP Baan IV – PSS-1 – Project Planning
ERP Baan IV – AQS – Activity Query Structures
ERP Baan IV – PSS-2 – Project Requirements
ERP Baan IV – HRS – Hours Accounting
ERP Baan IV – PPC-1 – Project Progress
ERP Baan IV – PPC-2 – Project Monitoring
ERP Baan IV – PDM-2 – Tables
ERP Baan IV – PDM-1 – Common Data
ERP Baan IV – PDM-3 – Project Definition
ERP Baan IV – PTC – Project Budget
ERP Baan IV – BAAN Service
ERP Baan IV – SMA – Service and Mantainance
ERP Baan IV – SPF – Service Analysis
ERP Baan IV – BAAN Transportation
ERP Baan IV – ECS – Employee Control
ERP Baan IV – ACS – Address Control
ERP Baan IV – TFM – Transport Fleet Management
ERP Baan IV – TFC – Transport Fuel Control
ERP Baan IV – HAZ – Hazardous Materials
ERP Baan IV – HEC – Hours and Expense Control
ERP Baan IV – CDE – Central Data Entry
ERP Baan IV – TRC – Transport Rate Control
ERP Baan IV – TOC – Transport Order Control
ERP Baan IV – TOP – Transport Order Planning
ERP Baan IV – TOD – Transport Order Documents
ERP Baan IV – TOH – Transport Order History
ERP Baan IV – TCO – Transport Costing
ERP Baan IV – ICS – Invoicing Control
ERP Baan IV – PAC – Packing Control
ERP Baan IV – TPI – Third-Party Items
ERP Baan IV – WRC – Warehousing Rate Control
ERP Baan IV – WOC – Warehouse Order Control
ERP Baan IV – WIC – Introduction to Warehouse Inventory Control
ERP Baan IV – WOH – Warehouse Order History
ERP Baan IV – DRP – Distribution Requirements Planning
ERP Baan IV – TCD – Transport Common Data
ERP Baan IV – DDC – Distributed Data Collection
ERP Baan IV – XCH – Exchange

You can get hands on to this ebooks by visiting the website


Disclaimer: Fullonbaan is no way linked to G. John Sagmiller and is not responsible for non-quality contents of the ebooks or non-delivery of the ebooks after making the payment or non satisfaction on receiving the material. Fullonbaan has no direct or indirect connection with G. John Sagmiller.