SI.WRITEBACKBUDGET

Overview

The SI.WRITEBACKBUDGET function defines a Sage Intacct Budget Item (consisting of one or more GL budget values) to be uploaded to the ERP.

Syntax

=SI.WRITEBACKBUDGET(
    ConnectionName,
    BudgetID,
    Description,
    ShouldUseAsDefaultCompanyBudget,
    ConsoldationSettings,
    Account,
    LocationID,
    Dimensions,
    UserDefinedDimensions,
    ReportingPeriod,
    Amount,
    Note
)

Arguments

The SI.WRITEBACKBUDGET function uses the following Header and Item arguments:

Header Info

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager. This function does not support the multiple connection functionality.
`BudgetID`	Required	The `BudgetID` to be used in Sage Intaact
`Description`	Optional	A textual description of the budget
`ShouldUseAsDefaultCompanyBudget`	Optional	`TRUE` or `FALSE` (Default) Determines if these budget values should be used as the default company budget values
`ConsolidationSettings`	Optional	An optional array of the following settings: IsConsolidated (`TRUE` - if this is a consolidated budget, otherwise use `FALSE`) Currency (consolidation currency code. Required if IsConsolidated is set to `TRUE`)

Item Info

`Account`	Optional	The GL account number for which a budget is being established/modified
`LocationID`	Optional (Required if muti-entity is enabled)	ID code for the Sage Intacct location to be used for the budget
`Dimensions`	Optional	A two-column (or two-row) Excel range, where the first column/row contains the name of a predefined analytical dimension (e.g. department, customer, project etc.), and the second column/row contains the semicolon-separated list of values or that dimension. For user-defined dimensions, use the `UserDefinedDimensions` argument
`UserDefinedDimensions`	Optional	A two-column (or two-row) Excel range, where the first column/row contains the name of a user-defined analytical dimension, and the second column contains the respective value (or a semicolon-separated list of values) for that dimension. For predefined analytical dimensions like customer, project etc., use the `Dimensions` argument
`ReportingPeriod`	Optional (Required if AccountCode is defined)	One or more Sage Intacct reporting periods to which budget values are to be applied
`Amount`	Optional (Required if AccountCode is defined)	The budget amounts to be applied to the specified reporting periods
`Note`	Required	Note(s) to add to the budget lines. Can be: blank text - `""` quoted text - `"test"` an array of quoted text - `{"text1","text2,"text3"}` a single cell reference - `$C$5` a range of cells - `C5:N5`

Examples

Example 1

Given this configuration on the budget writeback worksheet:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/yxgEyz2H7W4ESP7B8tWS0cUwJgw8OycA3g.png

This function...

=SI.WRITEBACKBUDGET(
    "Sage",
    "Master Budget - 2020 REV8",
    "Master Budget",
    FALSE,
    $I$11:$J$12,
    $B26,
    M11,
    B12:C12,
    ,
    $J$25:$U$25,
    $J26:$U26
)

...creates a budget with the following properties:

has a budget ID of Master Budget - 2020 REV8
has the description of Master Budget
will not be used as the default budget for the company
will use the consolidation settings defined in cell I11 through J12 (in this example, none)
will be created for GL account #40100
will be created in location 100
will be created for department 200 (specified in the Dimensions argument using cells B11 and C11)
will be created for the reporting periods specified in cells J25 through U25
will have the amount of specified in cells J26 through U26

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/F1o1VEDYSjnd1vvGtqZAuY6txChmoJKr1g.png

And the budget values now appear within Sage Intacct:

Example 2 - Consolidation Settings

When specifying the ConsolidationSettings argument, be sure to use an Excel array or a range of cells (not an individual value or cell reference).

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/CwaTCOE1nmpeflEO696yNOcJgDhxVixNhg.png

Example 3 - Disabled Dimensions

If your organization has disabled one or more of Sage Intacct's pre-defined dimensions, you may see a #VALUE! message in the Writeback Status column of the worksheet. If you select that cell and hover over the yellow triangle that is displayed, a message such as the following will be displayed:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/j9mjBE7SrWLz-YXjeDIW78TpmcGzswDr3A.png

Example message

Predefined dimensions 'projectid', 'vendorid', 'warehouseid' do not exist or are disabled in your company

Workaround

You can either:

make sure all disabled dimensions in the Velixo function are referring to empty cells
or ensure that the disabled dimensions are removed from the function

Example 4 - Budget lines with all the same Note

A single piece of text can be specified to be placed as the note for each line in the budget.

This function...

=SI.WRITEBACKBUDGET(
    "Sage",
    "BUDGET-SKYLINE",
    "test budget",
    FALSE,
    ,
    A15,
    C15,
    ,
    ,
    $D$2:$O$2,
    D15:O15,
    "test"
)

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/RwYr56oVEotg2V2azgQxI7ff53phxOFcEg.png

uses the word "test" as the note for each budget line created.

Result:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/uHC5NSjNlzHjwhF7J_ozVTKgvvK1r71wOw.png

Example 5 - Budget lines with different Notes

A range of cells can be specified for sending a separate note to each line of the budget.

This function...

=SI.WRITEBACKBUDGET(
    "Sage",
    "BUDGET-SKYLINE",
    "test budget",
    FALSE,
    ,
    A15,
    C15,
    ,
    ,
    $D$2:$O$2,
    D15:O15,
    $D$2:$O$2
)

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/SfTL-PU-FjUTJJkkCS0OQaYr9ZVufaVBLQ.png

uses the contents of cell D2 through O2 as the notes for the corresponding budget lines.

Result:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/mAE9KfPbGMhnHybTzNU2E_E4VjWcSr2FQw.png