Auxiliary General Ledger

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	CPY
referentiel	Ledger (Local menu Legal, Analytical, IAS, Ledger 4, Ledger 5...)	M2644
sitedeb	Site range	FCY
datdeb	Date range	D
devise	Selection currency	CUR
optdev	Printing currency (Local menu Ledger currency , Selection currency)	M2619
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
cptpag	One account per page (Local menu No, Yes)	M1
ecrilet	Include matching items (Local menu No, Yes)	M1
ecripro	Temporary entries (Local menu No, Yes)	M1
ecrisim	Simulated entries (Local menu No, Yes)	M1
tri	Sort order (Local menu Number, Title, Short title)	M676
cumant	Previous totals carryfwd. (Local menu No, Yes)	M1
totper	Monthly total (Local menu No, Yes)	M1
totjou	Total by journal (Local menu No, Yes)	M1
detail	Detail reference, quantity (Local menu No, Yes)	M1
detpcedef	Final entry detail (Local menu No, Yes)	M1
detbprflo	Partner/flow detail (Local menu No, Yes)	M1
cptsld	Print settled accounts (Local menu No, Yes)	M1
solcum	Balance of totals (Local menu No, Yes)	M1
efface	Erase temporary table (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 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 opening balances 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
• Matched entry (if a matching exists)
• Entry status (T = Temporary, S = Simulated, F = 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 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.