BC.EXPANDBUDGETRANGE

Overview

The BC.EXPANDBUDGETRANGE function lets you retrieve a list of General Ledger budgets in your Business Central instance.

=BC.EXPANDBUDGETRANGE(
    ConnectionName, 
    Budget,
    IncludeBlocked
)

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.
`Budget`	Optional	Budget name filter expression. You can specify the filter using Velixo filtering techniques.
`IncludeBlocked`	Optional	Include blocked budgets – `TRUE` or `FALSE`. Default value: `TRUE`

=BC.EXPANDBUDGETRANGE(
    "BC",
    "like glb%"
)

Description:

Returns all budgets whose names begin with glb for the connection BC.