...
Step-by-Step Guide
- On the SQL Server, create a new, blank database named CMC_Migrate.
- Access the CMC ExtractClassic Migration program.
- Click G/L ConversionMigrate CMC Records to SQL.
- Specify a Year.
Select a Beginning and Ending Period # from the drop-down listings.
Specify a Division.
Click Load Data.
Click Scrub Data.
Click Insert Data.
Access ERP and perform the Recalculate GL Balances functiona value in the ODBC Connection option.
Note: This should match the name of the ODBC Connection configured during the ODBC setup.
- Specify the Data Source, Initial Catalog and User ID under the SQL Connection option.
- Click Execute.
- The system will take its time (sometimes over an hour) to complete the migration.