|
Code on 5 characters identifying the budget entry transaction. An entry transaction determines the parameterization of a budgetary entry screen. | |
| |
| |
| |
| |
| |
Transaction category. The budgetary entry can be carried out by period, by nature or by dimension. - Period: The budgeted amounts and quantities are calculated for the given nature (nature group) and dimensions (dimension groups) and are displayed by period.
- Nature: The budgeted amounts and quantities are calculated for the given period and nature (nature group) and are displayed for each dimension (dimension group) of the last dimension view of the budget dimension view code.
- Dimension: The budgeted amounts and quantities are calculated for the given period and dimensions (dimension groups) and they are displayed by nature (nature group).
| |
| |
The pre-loading box is only of any use if the transaction is by nature 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 nature, the values for the budgets are displayed for each dimension corresponding to the selection criteria.
- In a transaction by dimension, the values for the budgets are displayed for each nature corresponding to the selection criteria.
|
|
表格当前行 | |
  | |
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 nature 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 3 columns are related to the first budget, the following 3 columns are rlelated to the second budget. In the transaction parameterization, 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. |