2022

Page tree
Skip to end of metadata
Go to start of metadata

The data from Sage 100 is fetched through a mechanism within Sage 100 - referred to as a Visual Integrator.  We have created export jobs to fetch data from various tables of Sage 100. Instead of creating the relevant export and import jobs, we have created the jobs dump file. You can restore the file in your Sage 100 instance.

These export jobs dump can be downloaded from the following link Sage_ExportJobs.EXP


 Export Job Setup: 

Follow the steps to set up the Export Jobs that are required to export data from Sage 100  to staging database.

  1. Login to Sage 100 with valid credentials.

  2. Navigate to visual integrator -> Job Import.

  3. Select the Job import file from the file location (Which should be copied to your server).

  4. The job import wizard shows all the Available jobs. Select all the jobs that are necessary for your integration.

  5. Click Accept to create all the jobs in your visual integrator of Sage 100.

Below is the table containing the description of Export jobs

Job NameDescription
DB_AP_VENDORExports all the Vendors records from AP_Vendor table of Sage 100 to DBSync staging.
DB_AR_SALESPRSNExports all of Sales Reps records from the table AR_Salesperson from sage 100 to DBsync Staging.
DB_AR_CUSTOMERExports all of Customer records from AR_Customer recods from sage 100 to DBSync Staging
DB_CI_EXTDESCExports all records from the table CI_ExtendedDescription.
DB_CI_UOMExports all records from the table CI_UnitofMeasure.
DB_SO_SHIPTOADDExport all records from SO_ShipToAddress to DBSync staging database.
DB_IM_WAREHSEExports all records from table IM_Warehouse to DBSync staging database.
DB_CI_ITEMExports all item records from table CI_Items to DBSync staging database.
DB_AR_INVHISHDRExports all invoice history from table AR_InvoiceHistoryHeader to DBSync staging database.
DB_AR_INVHISDTLExport all invoice line item history from table AR_InvoiceHistoryDetail to DBSync staging database.
DB_IM_ITMWAREHSEExports all records from IM_Itemwarehouse to DBSync staging database.
DB_AR_OPNINVExports all of records from table AR_OpenInvoices to DBSync staging db.

Import Job Setup: 

Follow the steps to set up the Import Job required to import data from staging to Sage 100. You can download the Import job from the link IMPJOBS.EXP.

  1. Login to Sage 100 with valid credentials.

  2. Navigate to visual integrator -> Job Import.

  3. Select the Job import file from the file location (Which should be copied to your server).

  4. The job import wizard shows all the Available jobs. Select all the jobs that are necessary for your integration.

  5. Click Accept. This will create all the jobs in your visual integrator of sage 100.

Following table contains description of Export jobs:

Job NameDescription
DB_SO_IMImports all Sales Order header and its related line items in Sage 100.

RUNNING JOBS FROM VISUAL INTEGRATOR OF SAGE 100

Follow steps to run the job. However, the precondition for this is to have ODBC setup, before hand, on which the Sage 100 is hosted. This is done by DBSync implementation as a part of setup.

  1. Login to Sage 100 with valid credentials. 

  2. On the left navigation, select visual integrator -> Main -> Job Select option.

  3. Select the import/export job from the existing list.

  4. A job popup will open. Select Accept to run the job.

  5. An alert pops up stating, 'Do you want to continue?' as shown in below screen.


  • No labels