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