How to import into Business Framework data entry files for Sage 100

 CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. 
Note: Business Framework table names contain an underscore symbol and wording indicating the information stored. (Example: AR_InvoiceHeader, or PO_ReceiptHeader).

Caution: Prior to attempting any actual imports, make sure to fully test the import in a test copy of a live company – not in the live company itself!

1. To help determine the required fields to be used in the import job, manually enter an entry into the file that is being imported into.
2. While entering the entry, make a note of the fields that are required to manually enter. These are the fields that must be included in your import job.
3. Select Visual Integrator, Main, Import Job Maintenance and Enter Job Name
4. Select the lookup for Table Name and select the appropriate table to be imported into
5. Select the Data tab and enter the field names that were noted in Step 2
6. Other fields can be added if the default values are to be overridden
7. If “Header Separate From Line Record” is not selected on the Configuration Tab, then nothing needs to defined in the Record tab except for “Skip Record” if that is needed to skip records in the sourcefile such as Column Headers.
8. Select “Skip Source Data Truncation” on Configuration Tab if:
   1. Importing GL Account numbers that are longer than 9 characters including the “-” separators
   2. Importing descriptions over 30 characters