Analytical balances

• Company (field CPY)

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

• Ledger type (field LEDTYP)

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

• From site (field FCYDEB)

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.

• To site (field FCYFIN)

• Budget (field BUD)

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.

• Version (field VER)

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.

• Start date (field DATDEB)

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.

• End date (field DATFIN)

This date is used to define the inquiry end period.

• Amount (field TYPCOL)

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.

• Period (field PERCOL)

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

• Type (field TYP)

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.

• Dimension type (field AXE)

This field contains the code of the concerned dimension view.

• Pyramid (field PYRSEC)

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.

• Lev. (field NIVSEC)

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.

• Start (field SECDEB)

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.

• End (field SECFIN)

• Print row start (field RNGSECDEB)

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

• Print row end (field RNGSECFIN)

• Source currency (field DEVORG)

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.

• Print currency (field DEVIMP)

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.

• Rate (field COURANA)

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.

• field LIBCUR

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

• Budget rate (field COURBUD)

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.

• field LIBBUD

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

• Site detail (field DETSIT)

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.

• All dimensions entered (field TAXE)

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

• Carryforwards (field ANOUVO)

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

• Short description (field INTCOURT)

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.

• No dimension type entered (field AAXE)

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

• Closing (field CLOTURE)

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

• field DESTIN

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.

• Destination (field IMPRIME)

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.

• Screen (field ECRAN)

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

• Presentation sign (field SENS)

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.

• Divisor (field DIVISE)

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