Reports > Module Financials > Report BALGRPAUX (Auxiliary balance) 

The BALGRPAUX report is used to print the auxiliary 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, onlylegal companies allowed.

Ledger

Enter a ledger.

Site range

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

Selection currency

Enter a currency tofilter amounts by thatcurrency.

Printing currency

Select the report currency.

Conversion rate

Enter a conversion rateif the Selection and Printing currency are different.

Period date range

Enter a date range.

Opening balance

Select Yes to include opening balance.

Range of control accounts

Enter a range of control accounts.
Leave blank to include all control accounts.

Control group

Enter a control group.

Range of business partners

Enter a range of business partnersto include in the report.

Include carry-foward balances

Select Yes to include carry-foward balances.

Include closing journals

Select Yes to include closing journals.

Detail by site

Select Yes to group accounts by site.

Detail by control account

Select Yes to group by control account.

Sort order

Select:Code, Company name, Short title, or Site registration number

Group BP

Select Yes or No.

BP non-group

Select Yes or No.

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

devorg

Selection currency

CUR

devimp

Printing currency

CUR

cours

Conversion rate

DCB

datdeb

Period date range

D

ouverture

Opening balance (Local menu No, Yes)

M1

coldeb

Range of control accounts

SAC

grpcol

Control group

GSC

comptedeb

Range of business partners

BPR

anouveau

Include carryforwards (Local menu No, Yes)

M1

cloture

Include closing journals (Local menu No, Yes)

M1

detail_site

Detail by site (Local menu No, Yes)

M1

detail_collec

Detail by control account (Local menu No, Yes)

M1

tri

Sort order (Local menu Code, Company name, Short title, Site registration number...)

M697

tiersgroupe

Group BP (Local menu No, Yes)

M1

tiersnongroupe

BP non-group (Local menu No, Yes)

M1

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

Note: If there are any open periods for a company or a company within a group of companies, “Provisional” displays in the header.

For a company and for each BP the report displays:

  • The BP name
  • The control account if Detail by control account is set to Yes
  • The BP's company name or site description:
    • Company name if  Detail by control account is set to Yes
    • Site description if Detail by site is set to Yes and Detail by control account is set to No
  • The site if Detail by control account is set to Yes
  • The previous balances calculated on the period from the start of the fiscal year to the end of the period that precedes the execution start date
  • The debit and credit movements 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:

  • If you select Detail by site, the report displays one line per site.
  • If you select Detail by control account, the report displays one line per control account.

Finally, the report displays the following information for the company and for the period on the last page:

  • All debit and credit transactions during the period
  • Debit and credit transaction totals for the period
  • Debit or credit balance