Current Release : July 26, 2022

Please select the link below to download the latest Solutions for SYSPRO release for SYSPRO 7


Updates for current release.

Correction to EDIUpdate.sql script


Correction to creation of DispatchNote field in EDILabelDetail table. Use this script instead of the script in the update. If the script in the update was run, remove the DispatchNote column from EDILabelDetail and then run the corrected script

2022-07-31 : Update to input sorts


Update to correct issue of input sort dropping file information.

2022-08-04 : Correction to EDI scripting in support library

Corrected error in July 2022 EDI scripting library which would create all orders at status 8. Use 2022-08-04 or newer support library. Issue only occurs if import script is in use.

Major database change in July 26, 2022 release

A number of major changes have been made to the shipment tables to clean up inconsistencies in the original definitions of the tables and to support multiple dispatch notes from the same sales order being shipped on the same shipment. The main aspect of the conversion is the use of a numeric document number instead of the sales order number in the EDIShipmentOrder and EDIShipmentAdd tables.  The necessary conversion can take longer than usual if the shipment tables are large and if multiple orders per shipment are normal. In addition, any "ShipmentNumber" column has been renamed to "Shipment" and other columns have also been renamed for consistency. In order to minimize the impact of any renamed columns, computed columns have been added for all renamed columns to allow reports etc. to continue to function

Testing of Updates

It is HIGHLY recommended that all updates be tested on a test or development server separate from the main SYSPRO application server before installing in a live environment. 

SYSPRO 6.1 SP1 support has ended

Support for all versions of SYSPRO below SYSPRO 7.0 Update 1 ended December 31st, 2017. All customers using SYSPRO 6.1 must update to SYSPRO 7.0 Update 1 or SYSPRO 8 to continue receiving enhancements.

SYSPRO 7.0 C-ISAM support has ended

In order to take advantage of the SQL platform, support for SYSPRO 7.0 using C-ISAM data files has ended.

SQL Table Updates

There is a SQL script in the base\scripts folder called EDIUpdate.sql. This script must be run against each SQL Company. To Run, load it into SQL Management Studio select the SYSPRO database and execute.  For details, go to Tutorials--> Installation/Upgrades--> SQL Scripts and SYSPRO 7 Installation/Update, or click here.

Note for creating new companies

There is a SQL script in the base\scripts folder called EDITables.sql which must be used to create the required tables for a new company. 

Installation tutorial

For detailed installation steps, go to Tutorials--> Installation/Upgrades--> Install Cadacus Solutions, or click here .