Excel Add-in: explanation of the BUDGET_CU function

Introduction

With the BUDGET_CU (strBudVers; Co; shtFY; shtPer; strClassCode; strSubClassCode; strAccNr; strCostUnit; strCurrCode; shtValue; shtCalc;reportdate) function you can include the budget balance for a cost unit per general ledger account, sub-classification or classification in the worksheet.

Explanation of the fields

Company
Select the administration from which you want to retrieve the Exact data. If you select 'Default', the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.

The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.

Function
Select the function you want to use. In this case 'BUDGET_CU'.

Budget scenario
Enter an active budget scenario.

Financial year
Enter the financial year for which you want the amounts to be displayed.

Period
Enter the period for which you want the amounts to be displayed. Only amounts in (or up to and including) this period will be included.

Classifications
Select the classification (Category 1), for which you want the budget balance to be displayed. Select multiple classifications as follows : 001:022. In this case the balance of classifications 001 through 022 will be displayed. If you leave the field empty, all the classifications will be included.

Sub-classifications
Select the sub-classification (category 2) for which you want to retrieve the budget balance. Select multiple sub-classifications as follows: 001:005. In this case the budget balance for sub-classifications 001 through 005 will be displayed. If you leave the field empty, all the sub-classifications will be displayed.

G/L account
Select the general ledger account for which you want the balance to be displayed. You can also enter the account number. Select multiple accounts as follows: 0050:3000. In this case the balance for accounts 0050 through 3000 will be displayed. If you leave the field empty, all the general ledger accounts will be included.

Cost unit
Select the cost unit for which you want the balance to be displayed. Select multiple cost units as follows: a:bzzzz. In this case the balance for all the cost units that begin with an 'A' or a 'B' will be displayed. If you leave the field empty, the balance for all cost units will be included.

Value
Select which value you want to have displayed in the worksheet. You have the following options:

Currency code
Select the currency in which you want the amount to be displayed (all budgets, regardless of the currency code, will be included).

Calculation method
Indicate which calculation method should be used. You have the following options :