Budget positions
This function makes it possible to inquire the budgeted and actual amounts of operating budgets for a company, a site, a project, an envelope, a fiscal year and a budget line.
It can be accessed:
- Via the menu: Operating budgets\Budget positions,
- From the record "Project" via the menu bar: Inquiries\Budget positions,
- From the record "Envelope" via the menu bar: Inquiries\Budget positions,
- Via the budget table of the "Envelope" record via right-click on a line of the table: Budget positions,
- Via the "Budget line" record via right-click on a line of the table: Budget positions,
Prerequisite
Refer to documentation Implementation
Screen management
This screen is composed of two parts: The first part provides access to a set of selection criteria, the second part is used to display in a grid all the objects selected with respect to the entered criteria.
The maximum number of lines authorized by selection is set to 500. In case of overrun, a message "Full grid" indicates that the selection exceeds the 500 authorized lines. When clicking on "OK", the first 500 lines are displayed. In order to decrease the selection, the following selection criteria should be used: Project, envelope, responsible entity, entity approval.
The inquiry has 5 displayed levels. From the most global level (level 1) to the most detailed level (level 5) via the use of the "Level -" and "Level +" buttons at the bottom of the screen.
Header
The screen header information is used to specify the main selection criteria for the inquiry being used: Code of the company completed or not with the site, the period in which the object to inquire is situated.
Additional criteria can be associated in order to decrease the population of the objects to be inquired: Project, responsible entity ranges, approval entity ranges, envelope ranges.
If the criteria entered do not end on any selection, a message "No record for these selections" is displayed and informs the user who has to modify the selection criteria.
Selection
Company (field CPY) |
Code of the company or site where the information is searched. If the information entered corresponds to a company, the selection displays all the objects defined for the company, including those defined for the sites of this company. If the information entered corresponds to a site, the selection only displays the budget objects defined for this site. |
Site (field FCY) |
Optional field used to enter a "Site" code so as to limit the inquiry of this site's budget objects. Only the budget envelopes defined for this site are displayed. If the site is not entered, the inquiry will display all the budget objects of the company. |
Period start (field DATDEB) |
The ranges of the entered dates is used to filter the budgetary objects with a starting date is within this time interval (start date greater than or equal to the start date of the period or less than or equal to the end date of the period). The annual envelopes situated in the period are those which start date is situated in the entry period. The pluriannual envelopes situated in the period are those which one of the budgets contains a start date included in the entry period. By default, the starting date is initialized by the starting date of the last fiscal year budget opened. |
Period end (field DATFIN) |
By default, the end date is initialized by the end date of the last fiscal year budget opened. |
Fiscal year (field DFIY) |
Code of the fiscal year start of the entered period. |
field FIYCOM |
Fiscal year code of the start of the entered period. |
field FFIY |
Fiscal year code of the end of the entered period. |
Display level (field NIVAFF) |
The inquiry has 5 display levels:
|
field NIVCOM |
Field displaying the inquiry level selected. |
field NIVMAX |
field displaying the maximum level of inquiry, the level 5 is the most detailed level. |
Criteria
Project (field CRIPRJ) |
Selection criteria that makes it possible to display only the envelopes of the entered project, their budgets and budget lines. Only the projects, containing at least one attached envelope, linked to the entered company (directly, by their location, the company groups or their location groups) are displayed in selection. |
Responsible entity from (field ENTMSTR) |
Responsible entity to (field ENTMEND) |
Approval entity from (field ENTASTR) |
Approval entity to (field ENTAEND) |
Envelope from (field ENVSTR) |
Envelope to (field ENVEND) |
Block number 3
field LIBEL |
Field loaded according to the inquiry levels:
|
Other criteria
Detail of all envelopes (field DETALLENV) |
Sort by project (field TRIPRJ) |
Tab Status
For each inquiry level, the column displays the amounts of budgetary forecasts and actual expenses for the totaling level. The amounts are displayed in the envelope managing currency, coming from the budget code.
The result of this search displays:
- On the level 1: on the line 1 the total of envelopes not assigned to a project, on the following lines, the different projects of the selection, with the total of envelopes assigned to them.
- On the level 2: The list of envelopes assigned to each line of the level 1.
- On the level 3: The list of budgets assigned to each envelope of the level 2, including the budgets not comprised in the selected period.
Grid Details
Reference (field INTIT) | |||
According to the inquiry level, this column "Referece" displays the following information:
|
|||
Currency (field CUR) | |||
Code of the currency for envelope management, coming from the budget code. |
|||
Recipient entity (field ENTDEN) | |||
Amounts approved (field AMTAPP) | |||
Total approved amounts of the selection:
|
|||
Year-end outcome (field AMTATT) | |||
It is possible to enter on each budget line, an estimate of the expected annual actual expense. The year-end outcome amounts correspond to the sum of the forecasts according to the inquiry level.
|
|||
Amounts budgeted for (field AMTBUD) | |||
Total of the budgeted amounts of the selection, including for the approved objects, the revisions history.
|
|||
Reserve (field AMTRES) | |||
According to the inquiry level, the "Reserve" amount corresponds to:
|
|||
Available (field DISPO) | |||
The available amount corresponds to the budgeted amount - the reserve: For objects of the selection:
|
|||
Budgeted allocated (field IMPBUD) | |||
The amount "Posted budgeted" corresponds to the total of the amounts distributed in fiscal year budgets for the envelopes, and in budget lines for the fiscal year budgets, on the objets of the selection. According to the inquiry level, this amounts corresponds to:
|
|||
Budgeted remaining for alloc. (field RAV) | |||
"Budget left to be allocated" corresponds to "Available" - "Budgeted posted":
|
|||
Pre-committed (field AMTCMMPRP) | |||
Total of the amounts of purchase invoices posted on the budget lines of the selection. Carried out calculation corresponding to:
|
|||
Committed (field AMTCMM) | |||
Total of the amounts of orders posted on the budget lines of the selection. Carried out calculation corresponding to:
|
|||
Carried out (field REALISE) | |||
Total of the amounts of purchase invoices posted on the budget lines of the selection. Calculation corresponding to the sum of budget line invoices.
|
|||
Consumed (field CONSOM) | |||
The Consumed amount corresponds to:
According to the inquiry level, the Consumed amount corresponds to:
|
|||
Actual balance sheet (field SOLDE) | |||
The "Actual balance" is calculated as follows:
According to the inquiry level, this balance corresponds to:
|
|||
Accrued expenses amount (field AMTCAP) | |||
Total of the amounts of charges to pay posted on the budget lines of the selection:
|
|||
Purchase accruals amount (field AMTCCA) | |||
Total of the amounts of charges previously existing posted on the budget lines of the selection:
|
|||
Capitalized amount (field AMTFAS) | |||
Total of the amounts of invoices posted to fixed assets on the budget lines of the selection:
|
Envelope |
Budget fiscal year |
Line |
Purchase detail |
Reports
By default, the following reports are associated with this function :
BUOSIT : Budget positions
This can be changed using a different setup.
Specific Buttons
Level - |
This button makes it possible to browse the inquiry so as to move up from the finest inquiry (for example, budget line) to the most global (envelopes of the selection). |