INTERJECT Financials - Epicor -Update Manager

Estimated reading time: 9 minutes

Interject Financials - Epicor
Latest Version 1.2.3

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.2to1.2.3_Update.Interject_Reporting.SQL
Rollback to 1.2.2: from1.2.3to1.2.2_Rollback.Interject_Reporting.SQL

Current Version Notes

Interject for Financials - Current Version 1.2.3
Features Bugs Fixed
  • Added Parallel/Serial filter in Distribution - Parallel create #1 build and serial creates builds for each row. Defaults to Parallel.
  • Added ability to reference columns to create dynamic file names and folder path using [] syntax
  • Added Global Variable Definitions and seeded with YYMM and MMYY
  • Re-named Seed Open Fiscal Period to Fiscal Period
  • Removed Open Period option in Fiscal Period dropdown
  • Updated Fiscal Period column to reference the Fiscal Period filter
  • Updated Expand/Collapse column to reference the Expand/Collapse filter
  • Removed Data Pull on Distribution Run filter
  • Re-named Tab Enabled label to Data Pull?
  • Re-named Settings Enabled lable to Publish?
  • Re-named Refresh Rollup Data to Refresh Data and modified formatting
  • Moved Run Distiribution button
  • Fix Run buttons when creating multiple Distribution tabs.
  • Add Trim to FullAccounts in Rollup Definition

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.2.3 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'

Update for Previous Install: from1.2.1to1.2.3_Update.Interject_Reporting.SQL
Rollback to 1.2.1: from1.2.3to1.2.1_Rollback.Interject_Reporting.SQL

Current Version Notes

Interject for Financials - Current Version 1.2.3
Features Bugs Fixed
  • Added Parallel/Serial filter in Distribution - Parallel create #1 build and serial creates builds for each row. Defaults to Parallel.
  • Added ability to reference columns to create dynamic file names and folder path using [] syntax
  • Added Global Variable Definitions and seeded with YYMM and MMYY
  • Re-named Seed Open Fiscal Period to Fiscal Period
  • Removed Open Period option in Fiscal Period dropdown
  • Updated Fiscal Period column to reference the Fiscal Period filter
  • Updated Expand/Collapse column to reference the Expand/Collapse filter
  • Removed Data Pull on Distribution Run filter
  • Re-named Tab Enabled label to Data Pull?
  • Re-named Settings Enabled lable to Publish?
  • Re-named Refresh Rollup Data to Refresh Data and modified formatting
  • Moved Run Distiribution button
  • Fix Run buttons when creating multiple Distribution tabs.
  • Add Trim to FullAccounts in Rollup Definition
  • Fix Validation Definition for FullAccount (not allow invalid text)

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.2.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'