DriveWorks Pro 22

SYSPRO PowerPack

SYSPRO PowerPack

The SYSPRO PowerPack allows DriveWorks to integrate with SYSPRO ERP Business Software for Manufacturing.

The PowerPack works with SYSPRO v7 and v8.

The SYSPRO PowerPack allows data to be read directly from the SYSPRO database. Data can also be written back to the SYSPRO database.

When it comes to passing data back to the system there are two methods:

• The business objects that SYSPRO provides can be used to push the data directly into the SYSPRO system.
• DriveWorks can create XML file outputs so that SYSPRO data switch can process these as a separate entity.

These methods can be used individually or combined to suit the needs of the integration.

Installation

Double click the DriveWorks-SYSPROPowerPack-[version number].msi file to begin the installation process.

Once installed the plug-in is automatically loaded in DriveWorks.

Uninstall

The plug-in is uninstalled from Windows Programs and Features, and will be listed as DriveWorks SYSPRO PowerPack [version number].

Using the SYSPRO PowerPack

Once installed the DriveWorks SYSPRO PowerPack will be listed in the Plugin Settings.

To enable connection to SYSPRO, settings must be applied.

1. Select the DriveWorks SYSPRO PowerPack from the Application Plugins section of the Plugin Settings dialog.
2. Click the Settings button at the bottom of the Plugin Settings dialog.

Settings

Connection String

The connection string to the SYSPRO web services.

Username

The username of the user logging in.

Password

The password for the username logging into SYSPRO.

Company Name

Holds the company number.

Company Password

Holds the company password.

XML Location

The location at which DriveWorks will output XML files to be used by SYSPRO data switch if this is the desired method.

Connection Method

Functions

The following functions are added with the PowerPack and are available from the Rule Builder:

• SysproCurrentlyLoggedIn
• SysproGetAccountDetail
• SysproGetAllAccountDetail
• SysproGetAllItemDetail
• SysproGetTableData
• SysproGetTableDataAsXML

Specification Tasks

The following tasks are added with the PowerPack and are available from Specification Macros or Specification Flow:

• Create Table From Variables
• Export BOM
• Export BOM Item
• Export Non Stock Item
• Generic Add Data
• Generic Delete Data
• Generic Query Data
• Generic Update Data
• Insert Item
• Insert Job
• Insert Sales Order
• Transaction Build
• Transaction Post