SI.EXPANDPERIODRANGE (Financial functions)

Overview

The SI.EXPANDPERIODRANGE function returns a list of Reporting Period Names defined in Sage Intacct.

CODE

=SI.EXPANDPERIODRANGE(Connection, PeriodRange, OnlyBudgetable, IncludeInactive)

The SI. EXPANDPERIODRANGE function uses the following arguments:

Argument	Required/Optional	Description
`Connection`	Required	The name of the connection as configured in the Connection Manager
`PeriodRange`	Optional	The range of period names to include in the results. See our article on including multiple argument values
`OnlyBudgetable`	Optional	`TRUE` or `FALSE` (Default). Determines whether or not the function returns only budgetable reporting periods (which are the only periods that can be used for Budget Writeback).
`IncludeInactive`	Optional	`TRUE` (default) or `FALSE` Determines whet her or not to include entries with a Status field set to Inactive in the results. (available in version 2023.8 and higher)

CODE

=SI.EXPANDPERIODRANGE("Sage")

Description
Returns the name of all reporting periods defined in Sage Intacct:

Result

Given this configuration within Sage Intacct:

CODE

=SI.EXPANDPERIODRANGE("Sage",,,FALSE)

Description
Returns the name of all active reporting periods defined in Sage Intacct:

Result

Inactive period "First Quarter 2015" is not included