Budget transactions

Code on five characters identifying the budget entry transaction.

Common title of the current record.

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

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.

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.

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

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).

Flag used to activate the budget entry transaction.

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.

Current line of the grid.

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.

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).

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.

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

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.