Auxiliary General Ledger
Use this report to print the auxiliary general ledger for a legal company or a group of sites (a non-legal company). You can print detailed information for control accounts for one or a range of business partners.
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 :
Financials > Inquiries > Accounts
Common data > BPs > BPs
List of criteria
Parameter | Parameter title | Type |
|---|---|---|
societe | Company | |
referentiel | Ledger (Local menu Legal, Analytical, IAS, Gen. ledger 4...) | |
sitedeb | Site range | |
datdeb | Date range | D |
devise | Selection currency | |
optdev | Printing currency (Local menu Ledger currency , Selection currency) | |
coldeb | Range of control accounts | SAC |
grpcol | Control group | |
comptedeb | Range of business partners | |
anouveau | Include carryforwards (Local menu No, Yes) | |
cloture | Include closing journals (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) | |
cumant | Previous totals carryfwd. (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) | |
imporigindetail | Entry origin detail (Local menu No, Yes) | |
detbprflo | Partner/flow detail (Local menu No, Yes) | |
cptsld | Print settled accounts (Local menu No, Yes) | |
solcum | Balance of totals (Local menu No, Yes) | |
efface | Erase temporary table (Local menu No, Yes) | |
impselections | Print selections (Local menu No, Yes) |
Comments
The data is filtered by site according to the rights granted to the user on the function CONSCPT (Accounts).
Report description
The report header displays the following information:
- Selected company
- Print currency
- Date range
The following is printed for each business partner account:
- Carry-forward amounts if the parameter Include carry forward is set to Yes and the date 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 following is printed for each company or business partner account:
- Transaction posting date
- Document type and number
- Document description
- Control account
- Site
- Journal
- Letter for match level, if a matching exists
- Entry status: P = Provisional (temporary) or D = Definitive (final)
- Debit or credit amount
- Cumulative balance
Additional print options include:
- Period total
- Analytical dimension, the quantity, and the non-financial unit of the journal entry
- 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 sublevel for each line.
- If No, the sublevel details do not display.
For the Final entry detail report parameter for a given ledger type:
- If set to Yes, a sublevel 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 sublevel of details is not displayed, regardless of the entry status.
For the Entry origin detail report parameter:
- If set to Yes, the source and source document information are displayed for each entry regardless of the entry status.
- The Source indicates how the journal entry was created: Direct entry, Automatic generation, or Import via import template.
- The Source transaction code displays the origin code for the transaction such as an automatic journal code, function code, import template code, or a hardcoded value.
- If Final entry detail is also set to Yes, although these parameters are independently managed, the entry origin detail information displays on the same line.
- If set to No, the source and source document information are not displayed.
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.