GL in Two Currencies
Use this report to print the general ledger in two currencies for a legal company or a group of sites (non-legal company).
The first currency displayed is the ledger currency. The second currency depends on the Currency parameter selection. For example, if you enter USD for the Currency parameter and the ledger currency is EUR, the report filters for entries in those 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 | |
referentiel | Ledger (Local menu Legal, Analytical, IAS, Gen. ledger 4...) | |
sitedeb | Site range | |
datdeb | Date range | D |
devise | 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) | |
efface | Erase temporary table (Local menu No, Yes) | |
impselections | Print selections (Local menu No, Yes) | |
imporigindetail | Entry origin detail (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).
Description of the report
The report header displays the following information:
- Selected company
- Ledger currency and selected currency
- Chosen period
At the beginning of the account, the following displays:
- Carry-forward amounts if the Include carry forward 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.
For each company the following displays:
- For each original accounting line:
- Entry posting date
- Document type/number
- Label
- Site
- Journal
- Letter
- Entry status: P = Provisional (temporary), D = Definitive (final)
- Debit or credit in the ledger currency
- Debit or credit in the selected currency
- For each account:
- Progressive debt or credit balance on the period end date
- For each accumulation account level:
- Debit and credit total of the accumulation account
- For each summary line:
- Title
- Site
- Debit or credit
- Cumulative debt or credit balance
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 set to No, the source and source document information are not displayed.
A summary line is printed by accounting period for:
- All accounts associated with a control account
- Accounts whose summary option for the account record is selected and if Summarize accounts detail is set to No.
Depending on report parameter selections, you can include:
- Balances by accumulation at the account level if Balance of totalsis set to Yes.
- Analytical nature and the quantity if Nature detail, quantity is set to Yes.
- Total by accounting period if Monthly total is set to Yes.
Finally, the end of the report displays the debit and credit company totals in the ledger currency and the currency selected in the Currency parameter.