Skip to main content

Set the Fiscal Year Global Variable

The @@FISCALYEAR_START_END global variable sets which year labels your fiscal year. SEI uses that year in fiscal period calculations, reports, cubes, and date filters. It applies when your fiscal year starts in one calendar year and ends in the next. Enter 1 to identify the fiscal year by its start year, or 2 by its end year.

important

If you enter 1, match the period variables @@CURPERIOD and @@LASTDAYPERIOD to the same value.

Configure the fiscal year variable​

  1. In the navigation panel, click the gear icon to open the Administration section.
  2. Select Global Variables in the sidebar.
  3. Click the pen icon next to @@FISCALYEAR_START_END.
  4. In Script, enter 1 for the start year or 2 for the end year.
  5. Click Update.
Global Variables page with the pen icon of the @@FISCALYEAR_START_END variable and its Script field
ExampleLabel a fiscal year from May to April#
Scenario

Your fiscal year runs from May 2025 to April 2026, so it starts in one calendar year and ends in the next. The year that SEI uses to label this fiscal year in reports, cubes, and date filters depends on the value of @@FISCALYEAR_START_END.

Details
Value in ScriptYear that identifies the fiscal yearFiscal year shown
1Start year, 2025Fiscal year 2025
2End year, 2026Fiscal year 2026

Match the period variables to the fiscal year setting​

If you chose the start year, set StartOrEnd to 1 in the Script of @@CURPERIOD and @@LASTDAYPERIOD.

  1. In Global Variables, find @@CURPERIOD and click the pen icon.
  2. In Script, set StartOrEnd to 1.
  3. Click Update.
  4. Repeat for @@LASTDAYPERIOD.
var StartOrEnd = 1;
var FirstFiscalPeriod  = fSQLCSVArray("SELECT FirstFiscalMonth FROM @LIB_FinancialSetup");
FirstFiscalPeriod   = parseInt(FirstFiscalPeriod);
// The rest of the script stays unchanged
Script field of the @@CURPERIOD global variable with the StartOrEnd value set to 1