Aux. GL 2 Currencies

Prerequisite

Access to the report

This report can be accessed from the report menu of the group General accounting.

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	Currency	CUR
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
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).

Description of the report

The header of the GLDEVAUX report displays the following information:

• The selected company
• The print currency
• The chosen period

At the beginning of the account, the following is printed:

• The carry forward amounts,
• if the criterion "Taking into account of the carry forward amounts" is parameterized,
• totalled or detailed depending on the choice made for the selection criterion "Detail of the carry forward amounts" and for a selection including the first month of the fiscal year.
• The total former carry forward amounts, if the Criteria "Former totals" is set to yes.

The GLDEVAUX report displays for a given company:

• For each original accounting line:
• The posting date of the entry
• The document type/number
• The title
• The site
• The journal
• Any letter
• The entry status (T = Temporary, S = Simulated, F = Final)
• The debit or credit in print currency if the print type is set to "1" or "2", in company currency if it is set to "3".
• The debit or credit in reporting currency if the print type is set to "2" or "3", in company currency if it is set to "1".

• For each account:
• The progressive debtor or creditor balance at the period end date.

Depending on the chosen selection options, it is possible to dispaly:

• The analytical nature and the quantity (if "nature detail, quantity" is set to "yes").
• The total by accounting period (if "period total" is set to "yes")

Finally, the report displays at the end of the printing:

• The debit and credit company total if the option "totals balance" is set to "no", or the debit or credit company total if the option "totals balance" is set to "yes"