SI.EXPANDBUDGETRANGE

Overview

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

CODE

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

The SI.EXPANDBUDGETRANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`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)

CODE

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

Description
Returns all budgets defined in Sage Intacct

Result

CODE

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

Description
Returns all budgets marked in Sage Intacct as DEFAULT

Result

CODE

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

Description
Returns all budgets marked in Sage Intacct as CONSOLIDATED

Result

CODE

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

Description
Returns all budgets starting with the word "Master"

Result