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]	Budget table
BUDFORCAL [BUC]	Budget calculation formula
BUDVARCAL [BVC]	Budget calculation variable
BUDVER [BUV]	Budget versions
CACCE [CCE]	Dimensions
CADISTMP [DTP]	Budget weighting codes
COMPANY [CPY]	Company
FACILITY [FCY]	Sites
FISCALYEAR [FIY]	Fiscal years
PERIOD [PER]	Periods
TABBUDTYP [TBU]	Budget transactions