How to use Budget Writeback

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.

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.
Amount: the budget article amount.
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.

When you are ready to send your budget data to your ERP, click on Perform Writeback...

either on the Velixo NX ribbon:

or in the side panel:

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.