Budget transactions

• Transaction (field BUDTYP)

Code on five characters identifying the budget entry transaction.

• field DESTRA

Common title of the current record.

• Max no. of dim. types (field MAXDIENBR)

Enter the maximum number of dimension types that you can enter in this budget transaction. The maximum value authorized is 9 dimension types.

• Short description (field SHOTRA)

The short description replaces the standard description when display or print constraints require it.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

• Click Translation from the Actions icon in the corresponding field.
• In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

The connection language must be defined as a default language for thefolder.

• Legislation (field LEG)

Non-compulsory field containing the legislation code (miscellaneous table 909).

The entered value is used upon creation and validation of the folder and upon addition of data during legislation copy.

The data concerning the requested legislations and the common data (legislation code empty) on folder creation.

Only the records concerning the folder legislations are retrieved on folder validation.

The Legislation field is also used as a filter and checked upon movement selection and entry (entry of invoices, payments, journals etc.).

If the field is empty, the current record can be used whatever the legislation of the company concerned by the movement.

• Group (field GFY)

This field is used to allow access to the transaction to a limited group of companies.

• Budget category (field BUDCAT)

Transaction category. The budgetary entry can be carried out by period, by account or by dimension.

• Period: The budgeted amounts and quantities are calculated for the given account (account group) and dimensions (dimension groups) and they are displayed by period.
• Account: The budgeted amounts and quantities are calculated for the given period and account (account group) and they are displayed for each dimension (dimension group) of the last dimension type of the budget dimension type code.
• Dimension: The budgeted amounts and quantities are calculated for the given period and dimensions (dimension groups) and they are displayed by account (account group).

• Active (field ENAFLG)

Flag used to activate the budget entry transaction.

• Preloading (field LODFLG)

The pre-loading box is only of any use if the transaction is by account or by dimension.

• If the pre-loading box is not checked, the budgetary entry will be performed on an empty screen.
• If the pre-loading box is checked:
• In a transaction by account, the values for the budgets are displayed for each dimension corresponding to the selection criteria.
• In a transaction by dimension, the values of the budgets are displayed for each account that matches the selection criteria.

• No. (field COLNUM)

Current line of the grid.

• Column title (field COLDESTRA)

• Content (field COLTYP)

Information type contained in the column:

• Quantity: Budget quantity.
• Amount: Budget amount.
• Actual quantity: Carried out quantity, which comes from the analytical balance.
• Actual amount: Carried out amount, which comes from the analytical balance.
• Committed quantity: Committed quantity, which comes from the analytical balance.
• Committed amount: Committed amount, which comes from the analytical balance.
• Pre-committed quantity: Pre-committed quantity, which comes from the analytical balance.
• Pre-committed amount: Pre-committed amount, which comes from the analytical balance.
• Formula: Expression in which the contents of a column can be selected (for instance: C2 to pick up column 2) and to apply it to all sorts of calculations (Example: C2+C1).
• Text: In the budget by period entry transaction, it is possible to have a text column, in which comments are entered. For transactions by account or by dimension, there is a global comment line in the screen header.

• Formula (field COLEXP)

This field is accessible if the column is of the formula type. It contains the calculation formula. The result of the formula evaluation will be displayed in the column. To pick up in a formula the result of a column, it is necessary to enter C followed by the column number.

For instance: 

• Column 1: Budgeted amounts.
• Column 2: Actual amounts.
• Column 3: Actual - Budgeted difference (Formula = C2-C1)
• Column 4: Actual - Budgeted % difference (Formula = C3/C1 * 100).

• Line (field LINSELCRI)

The budgetary entry being multi-budget, it is possible to have several numbers, with each number identifying a budget. All the columns that have the same number are linked to the same budget. This number makes a link with the entry of the various budget codes in the budgetary entry.

For instance: to enter/view two budgets at once with the the following information:

• Column 1: Budgeted amounts for a first budget.
• Column 2: Actual amounts for a first budget.
• Column 3: Actual - Budgeted difference (Formula = C2-C1) for a first budget.
• Column 4: Budgeted amounts for a second budget.
• Column 5: Actual amounts for a second budget.
• Column 6: Actual - Budgeted difference (Formula = C2-C1) for a second budget.

The first three columns are related to the first budget, the following three columns are related to the second budget. In the transaction setup, a line number set to "1" will be entered to characterize the first budget, and a line number set to "2" will be entered to characterize the second budget.

• Total (field TOT)

It indicates whether the column must be added up at the bottom of the screen.

• Displayed (field COLSAIAFF)

The column can be visible or hidden on the screen. It is hidden if the information it contains is only used to calculate intermediary data used in other formulas.