Use this report to print an auxiliary general ledger for a legal company or a group of sites (non-legal company). This ledger is based on the control accounts for business partners.

You can include data for control accounts, a control group, and a business partner or a range of business partners.

Prerequisites

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 :

  Common data > BPs > BPs

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

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

solde

Balance (Local menu No, Yes)

M1

detail

Detail reference, quantity (Local menu No, Yes)

M1

detpcedef

Final entry detail (Local menu No, Yes)

M1

imporigindetail

Entry origin detail (Local menu No, Yes)

M1

cptsld

Print settled accounts (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 report header displays the following information:

  • Selected company
  • Ledger currency and selected currency
  • Date range

The following is printed for each business partner account:

  • Carry-forward amounts if the parameter Include carry forward is set to Yes and the date range includes the first month of the fiscal year.
  • Carry-forward amounts of previous totals if th Previous totals report parameter is set to Yes.

For each account, the report displays:

  • Transaction posting date
  • Document type and number
  • Document description
  • Control account
  • Site
  • Journal
  • Letter for match level, if a matching exists
  • Entry status: P = Provisional (temporary) or D = Definitive (final)
  • Debit or credit amounts in the ledger currency and the selected currency
  • Cumulative balance

For the Final entry detail report parameter for a given ledger type:

  • If set to Yes, a sublevel of details is displayed for each final entry, including the final number and final date. For a temporary entry, these fields are not displayed.
  • If set to No, the sublevel of details is not displayed, regardless of the entry status.

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 Final entry detail is also set to Yes, although these parameters are independently managed, the entry origin detail information displays on the same line.
  • If set to No, the source and source document information are not displayed.

The company total is printed at the end of the report.

Limits

The report parameters Include matching items, Temporary entries, and Simulated entries set to No are not relevant for control account lines.

For the control account lines, the report can be used to print a total line by period. The amounts used are the amounts of the balance, which stocks the amounts of the actual provisional / final entries in active simulation, without distinction.

For the total amounts, there is no distinction between a matched BP line and a BP line not matched for the period.