MANMAN DATA MIGRATION

1
MANMAN DATA MIGRATION
MK BaaN Oracle Many other ERP applications
Strategic Systems Group www.ssgnet.com info_at_ssgnet
.com
2
MANMAN DATA MIGRATIONOverview

• Benefits of Automated Data Conversion
• General Approach Considerations
• Data Manipulation
• Go-Live Data Conversion
• Alternative Approaches
• Conclusions

3
AUTOMATED DATA CONVERSIONBenefits

• Data consistency
• Referential integrity between tables
• Fewer errors
• Faster than manual methods for large numbers of
  records
• Accurate field translations
• Effective for multiple sites

4
GENERAL APPROACH
New ERP application
Classic Manman
Data Manipulation
SSGBusIntell ASCII file extracts
ASCII formatted import files
ASCII extract files
File Transfer from Manman system
File Transfer to new ERP application
Access
ASCII file format
5
GENERAL APPROACH

• Identify files and fields to be converted
• Perform data mapping
• Define conversion from old to new values
• Extract data from Manman
• Add new application defaults
• Convert data to new format
• Testing and validation
• Upload data into new ERP application

6
GENERAL APPROACH

• Static data should be converted through the
  automated data conversion process
• Files with a smaller number of records should be
  entered manually
• Transactional data should be entered manually
• Determine timing as it will affect month-end and
  any other signification reporting dates, for
  example, inventory and G/L overlays

7
GENERAL APPROACHStatic Data

• Identify files and fields to be converted
• Static data should be transferred using automatic
  data conversion
• Item Master Vendors
• Product Master Customers
• Inventory by Location Ship-to addresses
• Bills of material Pricing table
• Routings General Ledger
• Employees G/L History

8
GENERAL APPROACHTransactional Records

• Transactional records entered manually
• Open Accounts Payable
• Open Accounts Receivable
• Open Purchase Orders
• Open Sales Orders
• Open Work Orders

9
GENERAL APPROACHHistorical Data

• The following historical data can be extracted
  from Manman and preserved for inquiry and
  reporting using SSGBusIntell
• Accounts Payable Distribution
• Accounts Receivable History
• Closed Production Orders
• Purchase Order History
• Purchase Receipt History
• Historical stock balances

10
GENERAL APPROACHHistorical Data

• Removing the historical data from Manman can meet
  the following organizational needs
• The end-user will have Manman data available for
  reporting and inquiry
• I/T can take the Manman system off-line to
  eliminate maintenance requirements

11
GENERAL APPROACHOptional Data

• The following data can be converted manually or
  automatically, or some of it may not apply to
  your environment
• Bills of Material
• Routings
• Operations
• Lot Master and Variable Features
• Approved Supplier List

12
GENERAL APPROACHData Mapping

• Data mapping related considerations
• Define matching files
• Define matching fields
• Define field translations cross-references
• Identify table dependencies

13
GENERAL APPROACHData Mapping to MK

• Manman Files MK Tables
  
• Item Master tiitm001 Item Data
• Product Master tiitm001 Item Data
• Inventory by Location tdinv001 Item Data by Whse
• Bills of Material tibom010 Bill of Material
• Routings tirou020 Routing
• Vendors tccom020 Suppliers
• Bill-to Customers tccom010 Customers
• Ship-to Customers tccom013 Delivery Address
• Pricing file tdsls032 Prices by Price List
• G/L History tfgld011 G/L Balances
• tfgld012 G/L History

14
GENERAL APPROACH

• Automated Data Conversion
• Output format
• ASCII file
• Variable field lengths
• Delimited with
• No trailing delimiter
• No quotes around strings
• Numeric values for enum fields

15
GENERAL APPROACH

• Automated Data Conversion
• Special handling may be required for
• Date fields
• Field alignment
• Decimal point
• Right justification
• Combined fields
• Special characters
• Output example (pricing by price list)
• SPL100015999999010119940000000045.2101

16
DATA MANIPULATION

• Export data from Manman
• Load data into Access
• Perform translations and conversions from Manman
  values to value in new ERP application
• Add new defaults and required fields
• Extract data from Access
• Upload data into new ERP application

17
Automated Data Conversion Solution

• SSGBusIntell provides an off-the-shelf solution
  that meets approximately 80 of the data
  conversion requirements
• SSGBusIntell consists of a series of data
  extracts that take data from Manman to an Access
  or SQL database

18
Automated Data Conversion Solution

• SSGBusIntell static data extracts from Manman
• Customer Master
• Vendor Master
• Item Master
• Employees
• Inventory

19
Automated Data Conversion Solution

• SSGBusIntell data extracts from Manman
• Accounts Payable Distribution
• Accounts Receivable History
• Closed Work Orders
• Purchase Order History
• Purchase Receipt History
• General Ledger Detail and Summary
• Open Sales Orders
• Open Accounts Receivable
• Open Purchase Orders
• Open Production Orders

20
GO-LIVE DATA CONVERSION

• Sample Conversion Sequence
• General Ledger accounts
• Item master
• Vendor master
• Customer master
• Employee master
• Delivery addresses
• Bills of material
• Routings
• Prices by price list
• Item data by warehouse
• Manual data entry of A/R, A/P, S/O, P/O, W/O
• Go live
• G/L history

21
ALTERNATIVE APPROACHES

• Modify standard SSGBusIntell extracts to
• Build translation and cross-references into the
  data extracts
• Create new default values using Manman values
• Use Quiz extracts to enhance SSGBusIntell data
  extracts

22
Advantages

• SSGBusIntell contains 80 of the data needed for
  most data conversions
• SSGBusIntell extracts can easily be modified to
  add
• Cross references
• New values based on Manman values
• Software development time is limited or not
  required, depending on conversion requirements
• Results can be achieved more quickly
• SSG has good knowledge of Manman data structures
  and tools

23
CONCLUSIONS

• Compare benefits of SSGBusIntell data conversion
  tool to cost of software development to create
  conversion scripts from scratch
• Suggestions for success
• Go slow and plan conversion carefully
• Focus on the static data
• Assemble a team with varied application and
  technical skills
• Save some energy for post-conversion difficulties