SI.EXPANDPERIODRANGE

Overview

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

=SI.EXPANDPERIODRANGE(
    ConnectionName, 
    Period, 
    OnlyBudgetable, 
    IncludeInactive
)

The SI. EXPANDPERIODRANGE function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`Period`	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 whether or not to include entries with a Status field set to Inactive in e results. (available in version 2023.8 and higher)

=SI.EXPANDPERIODRANGE(
    "Sage"
)

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

Result

Given this configuration within Sage Intacct:

=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