GL in Two 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
comptedeb	Account range	GAC
anouveau	Include carryforwards (Local menu No, Yes)	M1
cloture	Include closing journals (Local menu No, Yes)	M1
detcent	Summarize accounts detail (Local menu No, Yes)	M1
pyramide	Pyramid	GYM
nivcum	Number of levels	C
solcum	Balance of totals (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, Classification...)	M675
cumant	Previous totals carryfwd. (Local menu No, Yes)	M1
detfcy	Total by site (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
efface	Erase temporary table (Local menu No, Yes)	M1
impselections	Print selections (Local menu No, Yes)	M1

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

Description of the report

The header of the GLDEV 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 according to the selection criterion "Detail of the carry forward amounts" and for a selection that comprises the first month of the fiscal year.
• The total former carry forward amounts, if the Criteria "Former totals" is set to yes.

The GLDEV report displays for a given company:

• For each original accounting line:
• The posting date of the entry
• The document type/number
• The label
• 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.

• For each accumulation account level:
• The debit and credit total of the accumulation account

• For each centralization line:
• The title
• The site
• The debit or credit
• The progressive debtor or creditor balance

A centralization line is printed by accounting period for:

• all accounts associated with a collective account
• those accounts whose "centralizable" option of the account record is checked and if the selection criterion "Detail of the centralized accounts" is set to "no".

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

• The balances by accumulation account level (if the "Totals balance" is set to "yes").
• 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"