Auxiliary Ledger Balances

Prerequisite

List of criteria

Parameter	Parameter title	Type
societe	Company	CPY
referentiel	Ledger (Local menu Legal, Analytical, IAS, Ledger 4, Ledger 5...)	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 header of the BALGRPAUX report displays the following information:

• he company (or group of companies) selected,
• the print currency,
• the selected period.

The BALGRPAUX report recovers the following information for a company and for each BP:

• the BP name,
• the collective account (if the option "Detail by collective account" is set to yes)
• the BP's company name or site description:
• company name: if the option "Detail by collective account" is set to yes,
• site description if the "Detail by site" option is set to yes and the "Detail by collective account" option is set to no),
• the site (if the "detail by site" has been requested),
• the previous balances (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 movements of the selected period (debit and credit),
• the balance at the end of the period.

The calculation rules are those applied for the balance inquiry.

Various presentation options can be chosen by selecting the grouping options:

• If the grouping option "detail by site" is selected, the report will display one line per site.
• If the grouping option "detail by collective account" is selected, the report will display one line per collective account.

Finally, the report displays the following information for the company and for the period at the end of the print:

• The debit and credit totals of the transactions during the period
• The debit and credit totals of the transactions during the period
• The debit or credit balance.