Import Conversion Data

Home | FAQs & Troubleshooting

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

The Visual Integrator module is an excellent tool for converting old data during System Startup. The source for such data is usually your old accounting system.

Expand/Collapse item  Before You Begin

Follow the instructions in the Installation Guide and Getting Started Guide for installing and registering the software, as well as creating and selecting a company. To set up each module and create data files, refer to the overview of module startup appendix in the Getting Started Guide.

 

To import conversion data

  1. Print the Data Dictionary Listing for each module that you want to import to determine which data needs to be imported.

NOTE The Data Dictionary Listing only contains information for the Material Requirements Planning and Work Order modules. To view and print information for all modules, click the File Layout and Program Information link on the Desktop's Resources page.

  1. Establish an ODBC Data Source Name (DSN) for the data. You can import data directly from the ODBC data source.

Note If your previous system does not support ODBC access, you must first export data that you want to import to one of the compatible file formats (ASCII, Delimited, etc.). Refer to documentation provided with the previous system on how its data is structured and how to export the data.

  1. Create import jobs for the main files for your module (for example, the Customer file or the Vendor file). You should import major files that contain hundreds of records. For smaller files, such as the Terms Code and Sales Codes files, it may be more efficient to manually input the data.

  2. Print listings of the imported files (Customer Listing, Vendor Listing, etc.) to verify the imported data. Make any additions or corrections as necessary using the maintenance programs.

  3. Create import jobs for transaction files, such as invoices.

  4. Print audit reports, such as the Trial Balance and aging reports, to verify that the transaction data imported properly. Pay special attention to control information, such as the total receivable balance. Import history files, such as Invoice History, as needed; importing historical information is optional. Historical data does not affect the proper functioning of the accounting modules.

The data is converted.