The Synoptix report "Horizons YTD Report" may appear to be missing older historical data (for example, 2012–2014) when run for the current fiscal year. This behavior is not caused by missing data in Colleague or report configuration changes, but by a known system limitation in the Colleague Financial Reporting Export (FRXE) process.

This article documents the issue, confirmed root cause, and available options.

Overview

The Synoptix report "Horizons YTD Report" may appear to be missing older historical data (for example, 2012–2014) when run for the current fiscal year. This behavior is not caused by missing data in Colleague or report configuration changes, but by a known system limitation in the Colleague Financial Reporting Export (FRXE) process.

This article documents the issue, confirmed root cause, and available options.

 

Symptoms

• The Horizons YTD Report in Synoptix only returns data for the most recent 10 fiscal years.
• When run as of the current year (e.g., FY 2026), the report only shows data back to FY 2016.
• Earlier years (e.g., 2012–2014) do not appear, even though they existed in prior Synoptix exports.
• Running the same report with an earlier end date may surface older data, but the output always spans a rolling 10‑year window.

 

What Was Verified

The following were confirmed during investigation:

• ✅ Financial transactions for the missing years still exist in Colleague.
• ✅ No Synoptix report formulas, parameters, or filters were changed.
• ✅ Account status (active/frozen), company selection, and report variables were not restricting data.
• ✅ Prior‑year Synoptix Excel exports included the missing historical years.
• ✅ The Synoptix data mart was successfully updating (validated via FRXL).

This ruled out report configuration, user error, and internal data loss.

 

Root Cause

Ellucian confirmed that the FRXE (Financial Reporting Export) process in Colleague is limited to exporting only 10 fiscal years of data, including all open fiscal years.

Key points:

• FRXE controls what financial data is exported from Colleague into the Synoptix data mart.
• Only the most recent 10 fiscal years are included in each export.
• Synoptix reporting is therefore limited to the data made available by FRXE, even if older data remains in Colleague.

This is current product behavior, not a configuration issue.

 

Vendor Confirmation

Ellucian Product Support confirmed:

• FRXE cannot be run for more than 10 fiscal years.
• This limit applies universally and cannot be adjusted by institutions.
• An enhancement request already exists to expand this capability.

Related Enhancement Request:

• Ellucian Enhancement ID: 18282.44
• Customer Center record: https://elluciansupport.service-now.com/customer_center?id=standard_ticket_customer_center&table=ellucian_product_enhancement&sys_id=00e8b5b797f345105154d004a253af53

 

Impact

• Board‑level and long‑term financial reporting may show incomplete cumulative balances.
• Historical trend analysis (e.g., program growth since inception) may be affected.
• Users may need to manually supplement older historical data outside of Synoptix.

 

Current Options / Workarounds

• Manual supplementation: Export older historical data from prior Synoptix extracts or Colleague and manually incorporate it into external reporting (e.g., Excel).
• Documentation for stakeholders: Clearly note the 10‑year limitation when presenting Synoptix‑based reports.
• Monitor enhancement: Track the Ellucian enhancement request for future product updates.

There is no technical workaround within Colleague or Synoptix at this time to extend the reporting window beyond 10 fiscal years.

 

Resolution Status

• Issue confirmed as product limitation.
• No further action possible until Ellucian delivers an enhancement.
• Internal ticket resolved and closed.