Reports > Module Financials > Report GLDEVAUX (Aux. GL 2 currencies) 

The GLDEVAUX report is used to print the auxiliary General Ledger in two currencies for a legal company or a site grouping (non-legal company).

The possible choices for these two currencies are submitted by the print type:

  • transaction currency and company currency
  • transaction currency and reporting currency
  • company currency and reporting currency

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, Gen. ledger 4...)

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"