Budget Writeback

Created by Damien Zwillinger, Modified on Mon, 19 Aug at 6:12 PM by Harry Lewis

Velixo ships with a WRITEBACKBUDGET function that can be used to reference existing cells of a spreadsheet for the purpose of then pushing this Budget data to your ERP.

While the most advanced users may prefer to design their Budget worksheet, Velixo offers a quick way to "get there" by generating a Budget table with variables in a Budget sheet.

Using the Budget Sheet

Start by creating a blank budget worksheet. Select Budget from the New Sheet button pulldown:

In the side panel, you will be asked to select the connection and the financial year for which you want to create a budget worksheet:

This information is needed to determine the number of financial periods (and columns) required for your budget. You will then see a worksheet that looks similar to the familiar Budget entry screen in your ERP:

Note: While the default layout for the Budget Writeback sheet is created for a single ledger / branch / year, the WRITEBACKBUDGET function supports multiple ledgers, branches, or years at once from a single worksheet.

Filling in the form

Fill in the blanks and enter your budget. Here’s a description of all the different settings:

Connection: the name of the connection, as configured in the Connection Manager. This is the instance/tenant where your budget will be imported, and the same name you use in your functions.
Branch: the branch whose budget you are creating. If you don’t use branches, leave this blank.
Ledger: the ledger of the Budget or Statistical type that stores the budget
Financial Year: the financial year of the budget.
Automatically Release: whether or not the budget should be released automatically after import.
Note: in order for budget values to be released for any financial year, all financial periods for that year must be unlocked within the ERP (even if no budget changes are being made to the locked periods)
Account: the account of the budget article.
Subaccount: the subaccount of the budget article. If you don’t use subaccounts, leave this blank.
Distributed Amount: the amount distributed over the periods. For the budget article to be released, the distributed amount should be equal to the value in the Amount column.
Period 01 through Period N: columns reserved for distributing the article amount over the periods of the year. Each column contains the budget article’s amount for the respective period in the budget year.

Performing Writeback

When you are ready to send your budget data to your ERP, click on Perform Writeback on the Velixo NX ribbon:

Then select one of the two options, based on your specific worksheet:

Current Sheet: run all Writeback functions on the current worksheet,
Selected Cells: only run those Writeback functions located in the selected cells

An Excel workbook can contain multiple budget worksheets. If you have multiple tenants, business units, or budgets versions, you’ll likely want to have separate worksheets with different names.

Note: Using Budget Writeback with your ERP's multi-factor authentication requires that the ERP's single sign-on ("OAuth2") feature also be enabled.