BC.WRITEBACKBUDGET

Overview

The BC.WRITEBACKBUDGET function enables you to write lines to a specified GL budget in Business Central.

Writing back to General Ledger budgets is not available to users with the MS Dynamics 365 Team Members license.

Getting started with Writeback - A general article on setting up and using writeback functions.

Syntax

=BC.WRITEBACKBUDGET(
  ConnectionName, 
  Budget, 
  BudgetDescription, 
  BudgetDimensions,
  BudgetUpdateMode,
  Account, 
  Amount, 
  Date, 
  Description, 
  Dimensions, 
  EntryNumber,
  EntryNumberOutput
)

Arguments

Header data

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager. This function does not support the multiple connection functionality.
`Budget`	Required	The name of the GL budget targeted for Writeback. If a budget with the provided name is not present in Business Central, a new budget by that name will be created.
`BudgetDescription`	Optional	A textual description of the budget.
`BudgetDimensions`	Optional	Comma-separated array of budget dimensions. This parameter affects only newly created budgets. If skipped, the new budget is created without budget dimensions. Global dimensions are not affected by this parameter.
`BudgetUpdateMode`	Optional	One of four available values: `by-entry-number`, which requires specifying the internal ID for update in the `EntryNumber` line argument. If the ID is not specified, a new budget entry is created. `recreate` – erases all entries in the budget, then creates new entries. Be careful with using WRITEBACKCOMMIT. `by-natural-key` – (default value) "smart" mode where you can specify a set of columns (such as the date, account, dimension values) by which Velixo will decide whether to update an existing budget entry or to create a new one: If one entry matching the key is found, update it. If multiple entries matching the same key are found, update one of them with the new value and set the others to zero. If no entry is found, create a new one with the specified value. A manually provided set of key values, for example, `dimensions, description`. The available values are: `account`, `date`, `dimensions` (or `dimension`), `description`. The values `account` and `date` are added automatically if not provided.

Line data

Argument	Required/Optional	Description
`Account`	Required	Account code for which the budget entry is created.
`Amount`	Required	Budget entry amount.
`Date`	Required	Budget entry date.
`Description`	Optional	A description of the budget entry.
`Dimensions`	Optional	A two-column Excel range, where the first column contains the name of a predefined dimension (e.g. department, customer, project etc.), and the second column contains the value for that dimension. When writing to an existing budget, make sure the dimensions you specify in this argument are part of the budget's configured dimensions. See the Using Dimensions article for more details.
`EntryNumber`	Optional	Budget entry number.
`EntryNumberOutput`	Optional	Reference to a cell where the GL budget entry numbers will be returned.

Example

Writeback to particular dimensions

Assume the following dimension range A3:B4:

You can reference this range in your BC.WRITEBACKBUDGET formula:

=BC.WRITEBACKBUDGET(
  "BC",
  "BUDGET2025",
  "Annual Budget 2025",
  ,
  ,
  "61100",
  5000,
  "2025-01-01",
  "Q1 office budget",
  E3:F4
)

This formula writes a budget entry of 5000 to account 61100 for 1 January 2025, and assigns the dimension value codes DEPARTMENT – ADM and PROJECT – PROJ-01 in line data.