INTERJECT Financials - Epicor -Update Manager

Estimated reading time: 4 minutes

Interject Financials - Epicor
Latest Version 1.3.1

Depending on which version of Interject Financials you’re running, there are different update and rollback scripts. Before updating or rolling back a version, follow the procedure below. Once you know the version you’re currently running, click on the appropriate dropdown below for the update release notes, the correct scripts for updating and rolling back versions, as well as procedures for running those scripts.

To Check for Your Current Version

After the inital instal, applying an update, or performing a rollback, you can confirm that your version is correct by:

  • Going to the Report Library
  • Opening the Configuration Manager
  • Checking the Database Version in the upper right of the report
    Database Version

Click Your Version Below for Release Notes and Update Scripts

Update for Previous Install: from1.2.3to1.3.1_Update.Interject_Reporting.SQL
Rollback to 1.2.3: from1.3.1to1.2.3_Rollback.Interject_Reporting.SQL

Current Version Notes

Interject for Financials - Current Version 1.3.1
Features Bugs Fixed
  • Added Rollup View tab and drills from Rollup in Configuration Manager
  • Fixed open month FinCube Epicor live pull for companies with more then 3 segments
  • Fixed FinCube column definition syntax for Unposted
  • Removed SPs related to client-specific custom reports
  • Fixed Exclusion issue in summary columns in Configuration Manager Validated Rollup tab
  • Fixed COA Segment Report and settings when account doesn't exist in Default company
  • Centralized segment settings in Account_Add SP
  • Fixed Configuration Manager Year tab
  • Added validation message when Rollup Name over 50 characters in Validate Rollup tab
  • COA Segment Report allow FullAccount listing in InterjectSegment tab
  • COA Segment Report allow to filter by Company in EpicorToInterject tab

Updating

Whenever an update of Interject for Financials is released, an update script must be run on your server. With each new update, the initial install script located on the Technical Install page will be updated. If you initally installed the most current version listed above, you will not need to run the Update Script. If you orginally installed a version older than the most current, take the following steps to update your implementation.

To Upgrade

In SQL Management Studio, run the script labeled Update for Previous Install at the top of this page.

Run [Interject_SetupScript1_Security], as shown below, to re-enable security.

EXEC [Custom].[Interject_SetupScript1_Security]
	@MasterEpicorDatabase = '<Epicor Controlling Database Name>'
	,@CertificatePassword =  'myPassword1234'

Rolling Back One Version

The following steps must be taken to roll back one version. Note that this will only roll to the previous version.

To Roll Back

In SQL Management Studio, run the script labeled Rollback to 1.3.1 at the top of this page.

Run [Interject_SetupScript1_Security], as shown below, to re-enable security.

EXEC [Custom].[Interject_SetupScript1_Security]
	@MasterEpicorDatabase = '<Epicor Controlling Database Name>'
	,@CertificatePassword =  'myPassword1234'