Auxiliary Ledger Balances

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 ledger.
Site range	Filter by a site or a range of sites. Leave blank to include all sites for the selected company.
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.
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 partners to 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