Skip to main content
Skip table of contents

SI.EXPANDBUDGETRANGE

Applies to:

  • Velixo NX
  • Sage Intacct

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



Syntax

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

Parameters


The SI.EXPANDBUDGETRANGE function uses the following parameters:

Parameter

Required/ Optional

Description

ConnectionName

Required

The name of the connection as configured in the Connection Manager

BudgetOptionalThe Budget IDs to include in the results
DefaultBudgetOptionalTrue - returns only the default budget matching the BudgetRange parameter
False (default) - returns all non-default budgets matching the BudgetRange parameter
IsConsolidatedOptionalTrue - returns only Consolidated budgets matching the BudgetRange parameter
False (default) - returns all non-consolidated budgets matching the BudgetRange parameter


see Filtering Techniques for Velixo Functions




Examples

Given the following configuration within Sage Intacct:



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

Example 1 - all budgets

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

Description

Returns all budgets defined in Sage Intacct

Result



Example 2 - default budgets

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

Description

Returns all budgets marked in Sage Intacct as DEFAULT

Result



Example 3 - consolidated budgets

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

Description

Returns all budgets marked in Sage Intacct as CONSOLIDATED

Result



Example 4 - budgets starting with certain characters

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

Description

Returns all budgets starting with the word "Master"

Result


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.