The articles in this section serve as a guide for importing Jobs, Subjobs, processed Job lines and opening Job balances into Eralis Job, while maintaining the integrity of the SAP Business One and Job database.
The SAP Business One Data Transfer Workbench cannot be used to import non-SAP Business One data. Instead, Eralis uses Microsoft Data Transformation Service (DTS) packages to import Job opening data. Microsoft DTS is provided free of charge with Microsoft SQL Server. The process of importing opening Jobs and their balances is split into 8 stages:
- Importing Jobs
- Importing Subjobs
- Importing Billing Contracts
- Importing Project Codes
- Importing Processed Job lines
- Importing open Job lines
- Resetting the next Job ID
- Reconciling work-in-progress in the GL and inventory (if required)
Article is closed for comments.