Budget Formula Codes - Implementation
Prerequisites
Activity codes
The following activity codes (sorted by type) may have an impact on the way the function operates :
ANA : No. of analytical dimensions
Authorizations
This function is object managed. The creation, modification, and deletion operations can be activated or deactivated for a given user. Filters by roles can also be associated with this function.
As data is linked to a site, a filter per site can be activated.
Miscellaneous prerequisites
Tables
Before proceeding with the setup of the budget calculation formulas, you need to define certain basic information such as:
- the budgets,
- the budget entry transactions,
- the company and site architecture. Although a budget code is not linked to either a site or a company, it is necessary to define whether the budget is built by site or by company.
- the accounting periods as well as the fiscal years,
- the dimension and account analytical charts (this is not mandatory but it can make it possible to improve the setup of the budget variables).
- the budget versions,
Tables used
The following tables are implemented by the function :
Table |
Table description |
---|---|
ATEXTRA [AXX] |
Texts to translate |
BALANA [BLA] |
Analytical balance |
BALANCE [BAL] |
General balance |
BUD [BUD] |
|
BUDFORCAL [BUC] |
Budget calculation formula |
BUDVARCAL [BVC] |
Budget calculation variable |
BUDVER [BUV] |
|
CACCE [CCE] |
|
CADISTMP [DTP] |
|
COMPANY [CPY] |
|
FACILITY [FCY] |
|
FISCALYEAR [FIY] |
|
PERIOD [PER] |
Periods |
TABBUDTYP [TBU] |