The BALGRP report is used to print a general balance for:
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.
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. |
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. |
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. |
Analytical dimension type | Enter the dimension type to include in the report. |
Dimension | Enter the dimension to include in the report. |
Print selections | Option to print criteria selections on the first page of the report. |
Parameter | Parameter title | Type |
---|---|---|
societe | Company | |
referentiel | Ledger (Local menu Legal, Analytical, IAS, Gen. ledger 4...) | |
sitedeb | Site range | |
comptedeb | Account range | |
datdeb | Date range | D |
ouverture | Opening balance (Local menu No, Yes) | |
anouveau | Include carryforwards (Local menu No, Yes) | |
cloture | Include closing journals (Local menu No, Yes) | |
pyramide | Pyramid | |
niveau | Number of levels | C |
detail_site | Detail by site (Local menu No, Yes) | |
detail_compte | Detail by account (Local menu No, Yes) | |
solcum | Balance of totals (Local menu No, Yes) | |
tri | Sort order (Local menu Number, Title, Short title, Classification...) | |
devorg | Selection currency | |
devimp | Printing currency | |
cours | Conversion rate | DCB |
export | Display all dimensions (Local menu No, Yes) | |
dimtypdeb | Analytical dimension type | |
dimval | Dimension | A |
impselections | Print selections (Local menu No, Yes) |
The data is filtered by site according to the rights granted to the user on the function CONSBAL (Account balances).
The report header displays the following information:
For each account for a company or group of companies the report includes:
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:
The report includes the following totals: