GL Account Journal Details
The GLGRP report is used to print the General Ledger of a legal company or of a site grouping (non-legal company).
Prerequisite
Access to the report
This report can be accessed from the report menu of the group Legal reports.
It is also called by default from the following functions :
Common data > BPs > BPs
Common data > General accounting tables > General > Accounts
Common data > General accounting tables > General > Account groups
Common data > General accounting tables > General > Account pyramids
List of criteria
| Parameter |
Parameter title |
Type |
|---|---|---|
|
societe |
Company |
|
|
referentiel |
Ledger (Local menu Legal, Analytical, IAS, Ledger 4, Ledger 5...) |
|
|
sitedeb |
Site range |
|
|
datdeb |
Date range |
D |
|
devise |
Selection currency |
|
|
optdev |
Printing currency (Local menu Ledger currency , Selection currency) |
|
|
comptedeb |
Account range |
|
|
anouveau |
Include carryforwards (Local menu No, Yes) |
|
|
cloture |
Include closing journals (Local menu No, Yes) |
|
|
detcent |
Summarize accounts detail (Local menu No, Yes) |
|
|
pyramide |
Pyramid |
|
|
nivcum |
Number of levels |
C |
|
solcum |
Balance of totals (Local menu No, Yes) |
|
|
cptpag |
One account per page (Local menu No, Yes) |
|
|
ecrilet |
Include matching items (Local menu No, Yes) |
|
|
ecripro |
Temporary entries (Local menu No, Yes) |
|
|
ecrisim |
Simulated entries (Local menu No, Yes) |
|
|
tri |
Sort order (Local menu Number, Title, Short title, Classification...) |
|
|
cumant |
Previous totals carryfwd. (Local menu No, Yes) |
|
|
detfcy |
Total by site (Local menu No, Yes) |
|
|
totper |
Monthly total (Local menu No, Yes) |
|
|
totjou |
Total by journal (Local menu No, Yes) |
|
|
detail |
Detail reference, quantity (Local menu No, Yes) |
|
|
detpcedef |
Final entry detail (Local menu No, Yes) |
|
|
detbprflo |
Partner/flow detail (Local menu No, Yes) |
|
|
efface |
Erase temporary table (Local menu No, Yes) |
|
|
impselections |
Print selections (Local menu No, Yes) |
Comments
The parameter comptedeb can take several successive values. The report is then divided in parts that are printed successively and limited by the range values entered. This improves the performance of Crystal Reports (slow pagination for particularly large reports, with several thousand pages).
The data is filtered by site according to the rights granted to the user on the function CONSCPT (Accounts).
For Final entry detail report parameter:
- For a given ledger type, if set to Yes, a sub-level of details is displayed for each final entry, including the final number and final date. For a temporary entry, these fields are not displayed.
- If set to No, the sub-level of details is not displayed, regardless of the entry status.
Report description
The report header displays the following information:
- Selected company
- Printing currency
- Date range
At the beginning of the account, the following are printed:
- Carry-forward amounts if the Include opening balances report parameter is set to Yes and the selected range includes the first month of the fiscal year.
- Carry-forward amounts of previous totals if the Previous totals report parameter is set to Yes.
The report prints the following information for a company and each account:
- For each original accounting line:
- Entry posting date
- Document type and number
- Title
- Site
- Journal
- Any letter
- Entry status (T = Temporary, S = Simulated, F = Final)
- Debit or credit
- Cumulative balance in credit or debit
- For each centralization line:
- Title
- Site
- Debit or credit
- Cumulative balance in credit or debit
Summarize account detail management:
- For a Normal account and the Summarize account detail report parameter is set to No:
- If Summary reporting is selected: One centralized line per accounting period is printed.
- If Summary reporting is not selected: The journal entry detail is printed.
- For a Normal account and the Summarize account detail report parameter is set to Yes:
- The journal entry detail is printed whether Summary reporting is selected or not.
- For a Collective account: One centralized line is printed for each accounting period.
Additional selection options allow you to print the following:
- The balances by accumulation account level
- Analytical dimensions, the quantity, and the non-financial unit of the journal entry
- Period total (monthly calendar period, not the accounting period defined for the company in Periods management )
- Consolidation partner and flow for each line if the Partner/flow detail report parameter is set to Yes
- If Yes, the flow, partner code, and journal entry description display on a sub-level for each line.
- If No, the sub-level details do not display.
The company total is printed at the end of the report.
Limits
The report parameters Include matching items, Temporary entries, and Simulated entries set to No are not relevant for control account lines.
For the control account lines, the report can be used to print a total line by period.The amounts used are the amounts of the balance, which stocks the amounts of the actual provisional / final entries in active simulation, without distinction.
For the total amounts, there is no distinction between a matched BP line and a BP line not matched for the period.