The BALGRP report is used to print a general balance for:

  • A legal company or a group of sites (non legal company)
  • A group of companies

If there are any open periods within the selected date range, for a company or group of companies, the message “Provisional” displays in the report header. For example, even if only one period for a single company within a group of companies is open, the report prints with “Provisional” in the header.

Prerequisite

Report control and criteria

This section describes how the parameters in the List of criteria behave.

Details are provided in the Description of the report.

Criteria

Comments

Company

Enter a company, only legal companies allowed.

Ledger

Enter a ledge for the report.

Site range

Filter by a site or a range of sites.
Leave blank to include all sites for the selected company.

Account range

Filter by account or a range of accounts. 

Date range

Enter a date or date range.

Opening balance

Select Yes to include an opening balance.

Include carry-forward balances

Select Yes to include carry-forward balances.

Include closing journals

Select Yes to include closing journals.

Pyramid

Enter the pyramid for the report.

Number of levels

Enter the number of pyramid levels to include.

Detail by site

Select Yes to display dimensions at the site level.

Detail by account

Select Yes to display dimensions by account.
If Detail by site is also Yes, dimensions display at the site level.

Balance of totals

Select Yes to include cumulative balance totals.

Select order

Select: Number, title, short title, or classification

Selection currency

Enter a currency to filter amounts by that currency.

Printing currency

Select the report currency.

Conversion rate

Enter a conversion rate if the Selection and Printing currency are different.

Display all dimensions

Select Yes to display all dimensions for selected accounts.
If Yes, the Analytical dimension type and Dimension parameters are disabled.

Analytical dimension type

Enter the dimension type to include in the report.
This parameter is disabled if Display all dimensions is Yes.

Dimension

Enter the dimension to include in the report.
This parameter is disabled if Display all dimensions is Yes.

Print selections

Option to print criteria selections on the first page of the report.

List of criteria

Parameter

Parameter title

Type

societe

Company

CPY

referentiel

Ledger (Local menu Legal, Analytical, IAS, Gen. ledger 4...)

M2644

sitedeb

Site range

FCY

comptedeb

Account range

GAC

datdeb

Date range

D

ouverture

Opening balance (Local menu No, Yes)

M1

anouveau

Include carryforwards (Local menu No, Yes)

M1

cloture

Include closing journals (Local menu No, Yes)

M1

pyramide

Pyramid

GYM

niveau

Number of levels

C

detail_site

Detail by site (Local menu No, Yes)

M1

detail_compte

Detail by account (Local menu No, Yes)

M1

solcum

Balance of totals (Local menu No, Yes)

M1

tri

Sort order (Local menu Number, Title, Short title, Classification...)

M675

devorg

Selection currency

CUR

devimp

Printing currency

CUR

cours

Conversion rate

DCB

export

Display all dimensions (Local menu No, Yes)

M1

dimtypdeb

Analytical dimension type

DIE

dimval

Dimension

A

impselections

Print selections (Local menu No, Yes)

M1

Comments

The data is filtered by site according to the rights  granted to the user on the function CONSBAL (Account balances).

Description of the report

The report header displays the following information:

  • The company (or group of companies) selected
  • The print currency
  • The selected period

For each account for a company or group of companies the report includes:

  • The account number
  • The account title
  • The site if the detail by site has been requested
  • The previous balances, calculated from the fiscal year start period to the end of the period that precedes the print start date
  • The debit and credit transactions for the selected period
  • The balance at the end of the period.

The calculation rules are those applied for the balance inquiry.

Report display options:

You can take advantage of several report parameters to customize the layout:

  • Display dimensions by site or account.
  • Sort accounts by number, title, short description, or classification.
  • Include a rate conversion if the selection and print currencies are different.

The report includes the following totals:

  • Balance sheet
  • Management
  • Off-balance sheet
  • Debit and credit at the end of the period
  • Cumulated debit and credit
  • Debit or credit balance