Excel Add-in: explanation BUDGET_BAL function
Introductie
Introduction
With the
BUDGET_BAL(str9BudVers;acc_nr;cu;cc;co;FY;Period;value;calc) function you
can include the budget balance for a budget scenario,
by general ledger account, cost unit and
cost center in a particular
financial year and period 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_BAL'.
Budget scenario
Enter an active budget scenario.
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 general ledger accounts as follows: 0050:3000. In
this case the balance of 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.
Cost center
Select the
cost center for which you want the balance to be displayed. Select multiple cost
centers as follows: a:bzzzz. In this case the balance for all the cost centers
that begin with an 'A' or a 'B' will be displayed. If you leave the field
empty, the balance for all cost centers will be included.
.
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 entered
in (or up to and including) this period 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
- Balance
(3): the balance of the debit total and the credit total
- Positive
(4): same as the balance, but only positive values are displayed
- Negative
(5): same as the balance, but only negative values are displayed (as positive
values)
- Quantity
(6): The quantity (as entered) is included
Example
BUDGET_BAL("BUDGET1";"
8010","CENTER","CC1",-1,2004,"1",1)
The debit budget amount for the 'CENTER' cost unit and
'CC1' cost center on general ledger account 8010, in financial year
2004 in period 1 will be displayed, according to budget scenario BUDGET1 in the
default administration.
| 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.136.265 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |