SI.EXPANDPERIODRANGE
Applies to:
- Velixo NX only
- Sage Intacct
The SI.EXPANDPERIODRANGE function returns a list of Reporting Period Names defined in Sage Intacct.
Syntax
SI.EXPANDPERIODRANGE(ConnectionName, Period, OnlyBudgetable, IncludeInactive)
The SI. EXPANDPERIODRANGE function uses the following parameters:
Parameter | Required/Optional | Description |
ConnectionName | Required | The name of the connection as configured in the Connection Manager |
Period | Optional | The range of period names to include in the results. See our article on including multiple parameter 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) |
Examples
Example #1
=SI.EXPANDPERIODRANGE("Sage")
Description
Returns the name of all reporting periods defined in Sage Intacct:
Result
Example #2
Given this configuration within Sage Intacct:
=SI.EXPANDPERIODRANGE("Sage",,,FALSE)
Description
Returns the name of all active reporting periods defined in Sage Intacct:
Result
(note that inactive period "First Quarter 2015" is not included)