2022
...
These export jobs dump can be downloaded from the following link Sage_ExportJobs.EXP.
Follow
Follow the below steps to create the required jobs in to Sage 100 set up the Export Jobs that are required to export data from Sage 100 to staging db.
Login to Sage 100 with valid credentials
Navigate to visual integrator -> Job Import
Select the Job import file from the file location (Which should be copied to your server)
The job import wizard shows up all the Available jobs, Select all the jobs which are necessary for your integration.
Click on Accept button which will create all the jobs in your visual integrator of sage 100.
...
Job Name | Description |
---|---|
DB_AP_VENDOR | Exports all the vendors records from AP_Vendor table of Sage 100 to DBSync staging |
DB_AR_SALESPRSN | Exports all of sales reps records from the table AR_Salesperson from sage 100 to DBsync Staging |
DB_AR_CUSTOMER | Exports all of Customer records from AR_Customer recods from sage 100 to DBSync Staging |
DB_CI_EXTDESC | Exports all of records from the table CI_ExtendedDescription |
DB_CI_UOM | Exports all of records from the table CI_UnitofMeasure |
DB_SO_SHIPTOADD | Export all of records from SO_ShipToAddress to DBSync staging db |
DB_IM_WAREHSE | Exports all of records from table IM_Warehouse to DBSync staging db |
DB_CI_ITEM | Exports all of item records from table CI_Items to DBSync staging db |
DB_AR_INVHISHDR | Exports all of invoice history from table AR_InvoiceHistoryHeader to DBSync staging db. |
DB_AR_INVHISDTL | Export all of invoice line item history from table AR_InvoiceHistoryDetail to DBSync staging db. |
DB_IM_ITMWAREHSE | Exports all of records from IM_Itemwarehouse to DBSync staging db. |
DB_AR_OPNINV | Exports all of records from table AR_OpenInvoices to DBSync staging db. |
Follow the below steps to set up the Import Job that is required to import data from staging to Sage 100. You can download the Import job from the link IMPJOBS.EXP
Login to Sage 100 with valid credentials
Navigate to visual integrator -> Job Import
Select the Job import file from the file location (Which should be copied to your server)
The job import wizard shows up all the Available jobs, Select all the jobs which are necessary for your integration.
Click on Accept button which will create all the jobs in your visual integrator of sage 100.
Below is the table containing the description of Export jobs
Job Name | Description |
---|---|
DB_SO_IM | Imports all of Salesorder header and its related line items in to Sage 100. |
The below are the steps to run the job but precondition is to have ODBC setup on which the sage 100 is hosted, this is done by DBSync implementation as a part of setup.
...