Analytical balances

Enter the company code for the inquiry.

You can enter the code for:

• A legal company
• A group of companies
• A group of sites

If the inquiry concerns a group, several conditions must be met:

• The ledger-keeping currencies of the various companies must be identical.
• The viewed charts of accounts must be identical.
• The companies must not have different divisions by period.
• The number of companies in the company group must not exceed the value entered in BLAMAXCPY – Dimension balance inquiry max parameter (CPT chapter, ANA group).

Select the ledger type on which the balance will be based. The inquiry will only deal with those ledgers involved in an analytical tracking.

It is possible to analyze the accounting data for a site or a group of sites.

• Start: first site concerned by the balance inquiry.
• End: last site concerned by the balance inquiry.

If only one site is the subject of an inquiry, the same code must be entered in the Start and End fields.

Select the budget assigned when generating the analytical balance. The program submits the codes of those budgets whose chart codes are located on the ledger type, but it does not submit those having the option Operating budget checked.
It is possible to work with a maximum of three dimension types (defined in the budget setup).

 The inquiry of the balance can only concern one and only one budget.
The budget setup (chart of accounts and dimension types) must be consistent with the setup of the consulted sites, companies or groups. 
Group of companies and budget are not compatible as a budget is defined at the company or site level.

Select the version of the budget that will be concerned by the analytical balance. Only one version of a same budget must be checked as 'Default'.

 The inquiry of the balance can only concern one and only one version.

This date is used to define the inquiry start period.
The system enables three different periods to be managed. The periods correspond to those that are defined in the company for the selected ledger type.

This date is used to define the inquiry end period.

The system can manage a maximum of ten extracted amounts, each being linked to its extraction period.
 Six columns are managed on print mode.
For charges and revenues, the positioning is defined at account level.

This field is used to specify the period (in the 'Periods' block) for which the inquiry of the amount will take place (maximum of three).

The 'BP' type is not submitted if a budget is requested.
When the analytical account has the collective type, the budget entry is carried out on a collective account only, and not on a collective account associated with a BP.

This field contains the code of the concerned dimension view.

Non-mandatory field used to request an inquiry following an account or dimension pyramid. The submitted list of available pyramids is linked to the selected chart of accounts or dimension type.
For the 'Account' or 'Dimension' type, if the budget is defined at the level of an account or dimension pyramid, the code of the pyramid is automatically submitted.
If the inquiry is based on a pyramid, the definition level, as well as the print start and end ranges must be entered.

Definition level of a group of accounts or a group of dimensions.
This level must be strictly less than 99, the level 99 being the finest level rewerved by convention to the accounts.
If the group is included in another group of the pyramid, the level must be strictly higher than the level of the group into which it is included.
If the group contains sub-groups, the level must be strictly lower than the level of the sub-groups.

If no start or end account or dimension is specified, the totaling will concern:

• all the dimensions attached to the selected dimension type,
• or all the accounts attached to the selected chart of accounts,

based on the 'Account" or 'Dimension' choice.

Printing order of the groups of a same level.
On inquiry of the analytical balance, specify the start and end print ranges.

The extraxcted amounts are stored in the transaction currency and the ledger-keeping currency. Entering the currency of origin is used to filter and only consider the amounts for the transaction currency specified here.
If the currency of origin is not specified, the amounts will be extracted for all the currencies.

The print currency makes it possible to display the amounts in this currency. When this currency is the local currency, the amounts are extracted and displayed directly from the balance. Otherwise, amounts are converted to the exchange rate type specified in the CNSCURTYP parameter and at the inquiry date.

When the currency is not stored in the table and the print currency is different from the currency of origin, the exchange rate is requested.

This field specifies the conversion sense selected to display the exchange rate.

The budget is stored in a single currency. In the event of a budget being assigned via the generation of the analyical balance, if the print currency is different from the currency entered at budget level, you need to specify the budget exchange rate.

This field specifies the conversion sense selected to display the exchange rate.

If this box is checked, the program adds a column, in the balance print, that will be loaded with the code of the site to which the various totalling levels belong.

Only those recordings for which all the requested dimension types are entered will be retrieved.

It is possible to request the print of the carry-forward entries by checking the Carry-forward box.

If the inquiry screen specified in the following field plans the display of titles, it is possible to choose the display of short titles by checking the Short title box.

This field displays the recordings corresponding to the request, even if no dimension type has been entered.

Check the box Close if you wish to print the closing entries.

Ton print the analytical balance, it is possible to check:

• Print, for a paper print, or in .pdf format or in file, by selecting a report.
• Inquiry, for an inquiry, by selecting a screen.

This field is used to enter the code of the report than can be used for the balance printing. There are various print types: preview (PREVISU) submitting an overview of the balance before printing, the editing in a pdf (PDF) file, the inserting of the report in a message and the printing directly on your printer.
 If the field is not entered, the PREVISU screen code is used by default.

This compulsary field is used to enter the screen code that can be used for the inquiry of the balance.

This field is used to choose the printing sense.
For example:
If the selected presentation sense is 'Debit', a revenue commitment will appear as negative.

The presentation sense impacts the commitment and pre-commitment columns.
This change in the sense is taken into account at formula level.

Specify a unit for the divisor.

For example, to build a budget in Euro, enter 1. All amounts will be divided by 1 (Amount = €10,000 Amount obtained = 10,000). 

To build a budget in Kilo Euro, enter 1,000. All amounts will be divided by 1,000 (Amount = €10,000 Amount obtained in Kilo Euro = 10).