Excel Add-in: explanation of the BUDGET_CU function
Introductie
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:
- Debit
(1): the total of the amounts debited
- Credit
(2): the total of the amounts credited
- Quantity
(6): The quantity (as entered) is included
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 :
- Period
figures (1): Only figures from the selected period will be displayed, in the
default currency.
- Cumulative (2): The cumulative
amount, so all the transactions up to and including the selected period in the
default currency.
Date
Entries up to
and including the date entered here will be displayed in the result.
Range
If you
select the 'Date' setting, entries with
an entry date falling in this range will be included in the
result. If you select the 'Reporting date' setting, entries for
which the reporting date falls within the date range will
be included in the result.
Example
BUDGET_CU("GR2001";17;2002;"12";;;"0050";"ABON";"EUR";3;2;"5/31/2005";1)
The cumulative debit budget amount for the 'ABON' cost
unit in general ledger account 0050, through financial year 2002 and period 5
with entries with entry dates through 31 May 2005 in euro, according to
budget scenario GR2001 in company 17 will be included.
| Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
13.130.866 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |