SI.EXPANDBUDGETRANGE
Created by Harry Lewis, Modified on Wed, 6 Dec, 2023 at 2:19 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
The SI.EXPANDBUDGETRANGE function returns the Budget ID values as defined within Sage Intacct.
TABLE OF CONTENTS
Syntax
=SI.EXPANDBUDGETRANGE(ConnectionName, BudgetRange, 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 |
| BudgetRange | Optional | The Budget IDs to include in the results |
| DefaultBudget | Optional | True - returns only the default budget matching the BudgetRange parameter False (default) - returns all non-default budgets matching the BudgetRange parameter |
| IsConsolidated | Optional | True - 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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article