SI.EXPANDBUDGETRANGE

Overview

The SI.EXPANDBUDGETRANGE function returns the Budget ID values as defined within Sage Intacct.

=SI.EXPANDBUDGETRANGE(
    ConnectionName, 
    Budget, 
    DefaultBudget, 
    IsConsolidated
)

The SI.EXPANDBUDGETRANGE 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.
`Budget`	Optional	The Budget IDs to include in the results
`DefaultBudget`	Optional	`TRUE` - returns only the default budget matching the `BudgetRange` argument `FALSE` (default) - returns all non-default budgets matching the `BudgetRange` argument
`IsConsolidated`	Optional	`TRUE` - returns only Consolidated budgets matching the `BudgetRange` argument `FALSE` (default) - returns all non-consolidated budgets matching the `BudgetRange` argument, see Filtering Techniques for Velixo Functions

Given the following configuration within Sage Intacct:

(includes a total of 14 budgets, one of which is the default, and two are consolidated budgets)

=SI.EXPANDBUDGETRANGE(
    "Sage",
    "*"
)   

OR   

=SI.EXPANDBUDGETRANGE(
    "Sage"
)

Description
Returns all budgets defined in Sage Intacct

Result

=SI.EXPANDBUDGETRANGE(
    "Sage",
    ,
    TRUE
)

Description
Returns all budgets marked in Sage Intacct as DEFAULT

Result

=SI.EXPANDBUDGETRANGE(
    "Sage",
    ,
    ,
    TRUE
)

Description
Returns all budgets marked in Sage Intacct as CONSOLIDATED

Result

=SI.EXPANDBUDGETRANGE(
    "Sage",
    "Master?"
)

Description
Returns all budgets starting with the word "Master"

Result