How to import into Business Framework data entry files for Sage 100
Description
Cause
Resolution
[BCB:1:Backup warning:ECB]
[BCB:5:Third-party support:ECB]

Note: Business Framework table names contain an underscore symbol and wording indicating the information stored. (Example: AR_InvoiceHeader, or PO_ReceiptHeader).

Caution: Prior to atempting 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


DocLink: Error: "Line Number 1 has not been distributed" displays on Visual Integrator log when importing Lot/Serial Items
DocLink: How to auto-assign Batch numbers, when importing into Data Entry files with Visual Integrator
DocLink: How to access Visual Integrator resources and Help for import and export of data
DocLink: How to use Visual Integrator to import into AP Invoice Data Entry

Steps to duplicate
Related Solutions