Progress Database ConversionChange Summary
Conversion Overview
Introduction
QAD Enterprise Edition Conversions
Conversion Path Diagram
Prerequisite Skills
Pre-conversion
Introduction
Pre-conversion Overview
Install Pre-conversion Code
Conversions from eB2.1 or Later
Prepare Source Data
Table Extension Domain Utilities (eB2.1 and later only)
Archive/Delete Transaction Data (optional)
Global Tax Management Conversion (pre-eB)
Run Pre-conversion Utilities
Employee Entity Utility (uxempent.p)
End User Contact Utility (uxendupd.p)
Control Account Utility (uxctrl.p)
GL Account/Project Range Utility (uxglproj.p) if pre-eB
Orphaned Address Utility (uxaddrfix.p)
Credit Terms Utility (uxcrterms.p)
Data Preparation Report (gpdatarp.p)
Country Code Utility (uxctryup.p)
Tax ID Utility (uxtaxid.p)
Code Search and Replace Reports (eB2.1 and later only)
GL Account Type Utility (uxglacup.p)
Pre-conversion Integrity Report (gpinckrp.p)
Set Conversion Parameters
TopicConversion Parameters Utility (utfinpar.p)
Pre-conversion Completion
Converted GL Account Definitions Report (glacdfrp.p)
Process Pending Transactions
Close the Production Database to Users
Rerun Pre-conversion Integrity Report (gpinckrp.p)
Rerun GL Account Type Utility (uxglacup.p) in Update Mode
Run the Converted GL Account Definition Report (glacdfrp.p)
Standard Period Closing Reports
Rerun (Finalize) Data Preparation Report
Conversion Execution
Introduction
Conversion Execution Overview
Preserve Custom System Data
Prepare Environment
Prepare Source Databases
Back Up Progress Property Files
Install and Configure Software
Install QDT
Install QAD Enterprise Edition
Conversion Set Up
Enable Large Files
Enable Conversions
Convert QAD Enterprise Edition from Previous Release
Create Live Main Database
Character Client Code: Generate R-Code
Update UI Configuration
Convert QAD Enterprise Edition Database from Previous Version
Conversion Program Selection
Domain Conversion
OID Generator Value
Price List Conversion
Consigned PO Cost Point Conversion
EDI eCommerce Conversions
Execute Conversion
Conversion Validation
Enter License Codes
Conversion Execution Troubleshooting
Post-conversion
Introduction
Post-conversion Utilities
Fixed Assets Migration Utility (32.25.2, facvmt.p)
Table Extension Domain Conversions - Part 2
Sales Order Balance Update (36.16.23.6, utcsob.p)
Document Credit Terms Update (36.25.83, uxdoccrterms.p)
Update Contract Revenue Account (11.5.13.25.5, utsarrv.p)
Data Validation
System Consistency Check (36.16.23.1, utsyscon.p)
Financials Consistency Check (36.16.23.2, utfincon.p)
Operational Account Structure Validation (36.9.20, uxacval.p)
Post Conversion Integrity Check (36.16.23.3, acinckrp.p)
Post-conversion Reconciliation Reports
Post-conversion Reports
Process Flow and Static Data Validation
Static Data Validation
Mandatory Post-conversion Set Up
Structured Reports
Invoice Status Codes (36.1.11)
Daybooks
Security
Tax Periods
Reporting Periods
Profiles
Configure Daemons
Optional Post-conversion Set Up
Accounting Layers
Cash Groups
Report Structures
Taxes
Supplementary Analysis Fields
Customer Credit Checking
Customer/Supplier Payment Statuses
Customer/Supplier Control Accounts
Additional Profiles
Chart of Account (COA) Mask
Upgrading QAD Enterprise Edition
Overview
Upgrading Enterprise Edition
Back Up Environment
Update Custom Programs
Preserve Custom System Data
Prepare Environment
Install and Configure Software
Set Up Upgrade
Execute Upgrade
Upgrade Validation
Migrate Process Map Changes
Upgrading QAD Warehousing
Post-upgrade Configuration
GTM Conversions
GTM Conversions Summary
Pre-conversion Planning
Post-conversion Procedures
Converting VAT Taxes to GTM
Implementing GTM
Converting Master Records
Converting Transaction Records
Converting US Taxes to GTM
Implementing GTM
Converting Master Records
Converting Transaction Records
Converting to GTM From No Taxes
USA to GTM Setup
USA to GTM Masters
Converting Canadian Taxes to GTM
Implementing GTM
Converting Master Records
Converting Transaction Records
Running the Fixed Assets Migration Utility
Running the Fixed Assets Migration Utility
Options
Setting Migration Defaults
Mapping Legacy Data
Options
Conversion Methods
Converting Books
Converting Locations
Converting Classes
Migration Reporting
Converted Data
Overview
Layers
Business Relations
Shared Sets
Entities
Profiles
Accounts
Analysis Type and Analysis Limitations
COA Mask
Conversion Accounts
Project Status Codes
Project Groups
Security
Users
User Roles
Daybooks
Generalized Codes
Deleted Generalized Codes
New Generalized Codes
SAF Codes
Exchange Rates
Supplier Types
Purchase Types
Customer Types
Credit Terms
Credit Ratings
Invoice Status Codes
Payment Status Codes
Customer Payment Status Codes
Supplier Payment Status Codes
Supplier Bank Data
Payment Formats
Non-European Accounting
European Accounting
Consolidation
Voucher Detail Records
Pre-conversion
Conversion
Unconfirmed Supplier Vouchers
Configuring Access to the Progress Editor
Introduction
Setup for Progress Editor Access
Conversion Troubleshooting
Introduction
Conversions Not Enabled in QDT
Errors in Data Preparation Report
reindex.log Errors
qdtadmin.log Errors
Invalid Characters in Database Field
Number of Characters in Database Field Exceeds Limit
Role Name Contains Unsupported Characters
Pay Format Directory Not Found
Progress Errors During Conversion Execution
Default Daybook Codes Not Found
Could Not Start Financial Session
Performing a Clean QDT and Enterprise Edition Reinstallation
Removing QDT
Removing QAD Enterprise Edition
Restoring the Progress ubroker.properties File
Restoring the Progress Connection Manager Properties File
Install QDT and QAD Enterprise Edition
Log Files
Introduction
Log File Naming Conventions
Reviewing Log Files After Conversion
Snapshots
Introduction
Pause Points - convprogpauselist.ini
Back Up and Restoring a Snapshot
Creating a Snapshot
Restoring a Snapshot
Configuring QDT to Use a New Progress or Tomcat Version
Introduction
Configuring QDT
Product Information Resources
Progress Database ConversionChange Summary
Product Information Resources
ConversionOverview
EEUpgrade
PauseBeforeExecuting