Setup >  Organizational structure >  Ledgers  

Display all Hide all

A ledger features setup data associated with a chart of accounts.


MULTILEDGER.jpg

The ledger mainly qualifies the general and/or analytical accounting type and contains the management rules connected with the matching and the end-of-year rules.
In the event of a general ledger, the chart of accounts that is going to be used must be associated and if it is a (purely or not) analytical general ledger, the dimension types must also be specified. A same dimension type code can be used in various ledgers belonging or not to the same model.

A same chart of accounts can be associated with various ledgers. For instance, within the same folder, a same chart of accounts can be associated with the social ledger for an American company and with the US GAAP reporting ledger type for a French company.

SEEINFO A general and analytical chart of accounts can be used in a ledger that is purely general, purely analytical or both.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Fields

The following fields are present on this tab :

Block number 1

Code of the current ledger.

  • field DESTRA

Standard title of the current record.

Identification

  • Short description (field SHOTRA)

The short description replaces the standard description when display or print constraints require it.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for the folder.

Non-compulsory field containing the legislation code (miscellaneous table 909).

The entered value is used upon creation and validation of the folder and upon addition of data during legislation copy.

The data concerning the requested legislations and the common data (legislation code empty) on folder creation.

Only the records concerning the folder legislations are retrieved on folder validation.

The Legislation field is also used as a filter and checked upon movement selection and entry (entry of invoices, payments, journals etc.).

If the field is empty, the current record can be used whatever the legislation of the company concerned by the movement.

Type of accounting

  • General (field GEN)

The account core model must necessarily have a general ledger. If the ledger being created is a general ledger, the accounting types Budget, Operating budgets and Commitments cannot be accessed.

  • Analytical (field ANA)

The main analytical ledger must be checked 'Analytical'. A general ledger can also have the 'Analytical' box checked.
If the box Analytical is not checked, options Budget, Operating Budgets and Commitments cannot be accessed.

  • Budget (field BUD)

A ledger can only manage budgets if it is an analytical ledger.
Budgets are not necessarily associated with the main analytical ledger.

  • Operating budgets (field GDD)

A ledger can only manage operating budgets if it is an analytical ledger.
A ledger flagged "Operating budgets" MUST contain a dimension type flagged "Entity" and a dimension type flagged "Envelope".

  • Commitment (field CMM)

A ledger can manage an account management of type 'Commitments' only if the ledger is analytical.
In the case of a company having several ledgers managing commitments, the latter are generated on all the ledger checked 'Commitments".

SEEINFO Upon generation of commitments/precommitments, when a manual ledger is associated with an automatic ledger, only the manual ledger is updated.

  • Project management (field PJMFLG)

Click this check box to define this ledger as a Project management ledger.

 This check box is only available if this ledger is an analytical ledger.

 To track Project management costs analytically at the account core model level, the following conditions must be met:

  • Project management must be tracked for a single ledger;
  • The ledger must be set to 'Analytical' (field Analytical (ANA));
  • The ledger can only contain one dimension type which is set to track Project management costs.
  • Consolidation (field CSL)

Select this check box to allow consolidation management. An accounting core model can have several ledgers with this type of accounting.

  • Ledger type (field LEDTYPE)

 

CoA and dimension types

Specify in this field the chart of accounts associated with the ledger.
SEEINFO The accounting type(s) of the chart of accounts must be consistent with those of the ledger.

  • No. of dim. types (field DIENBR)

Specify the number of dimension views of the current ledger.

Enter the code of the dimension types of the current ledger.
A dimension type can be common to several ledgers, irrespective of whether the latter belong to the same account core model or not.
SEEWARNING The order in which the codes of the dimension types are entered has an impact on the setup of the previous dimension types of the default dimensions.

Management

  • Balance (field BAL)

In a journal, the balance represents equal debits and credits in the transaction currency, irrespective of the site.
The main general ledger must absolutely be balanced.

  • Balance by site (field FCYBAL)

If the chosen balance is to be considered by site, the journal must be balanced site by site. This balance is obtained by using the link accounts defined in the chart of accounts if the need arises.
The main general ledger must necessarily be balanced by site.

  • Matching (field MTCFLG)

All general and/or analytical accounts can use matching.
SEEWARNING This option is only applied if the ledger is matchable.

  • One dimension required (field DIEDACOBY)

When this box is checked, it will be mandatory, for instance when entering an entry, to assign at least one dimension view for this ledger.

  • Store lines without dimensions (field DIEIPT)

This option can only be accessed if the option Mandatory dimension view entry is not checked.
Concerning an entry line for an analytical ledger with storage of blank allocations, if no dimension view is entered, the analytical balance is still loaded for the amount and the account concerned.

Fiscal year end

  • Generation type (field GENTYP)

This option is used within the framework of the fiscal year-end process and it can take the following values:

  • Site: the processing generates a carry-forward journal by currency/site combination GAUFIYEN setup).
  • Company: the processing generates a carry-forward journal by currency/company combination (GAUFIYEN setup).

The fiscal year-end processing function generates at least this Carry Forward Entry journal (GAUFIYEN setup).

  • Balanced carryforward (field EQLRANANA)

If the box balanced CFE  is checked, in addition to the carry-forward entry journal, the processing will generate a result establishment entry (GAUFIYRE parameter).
If the box Balanced CFE is not checked, the fiscal year end processing will only generate the carry-forward entry by site or company.

For a General Accounting ledger, the balanced CFE is requested.
For an Analytical Accounting ledger, the result does not necessarily need to be calculated. In that case, the balanced CFE box does not need to be checked.

  • Closing document (field ENDVCR)

When the Closing journal checkbox is checked, a closure document for all accounts is created on the last day of the fiscal year. If the ledger is a general and analytical ledger, the journal closes all accounts and their analytical balances.
This journal can therefore complete the carry-forward journals (GAUFIYEN parameter) and the result calculation journals (GAUFIYRE parameter).

SEEINFO The automatic journal used to generate the closing entry is determined by means of the GAUFIYCL parameter.

  • One entry per account (field ACCVCR)

When a closing journal will be generated, the fiscal year end processing is likely to create:

  • a closing journal (GAUFIYCL setup) recorded on the last day of the fiscal year to be closed for balance closing,
  • a carry-forward journal (GAUFIYEN setup) recorded on the first day of the next fiscal year to re-create the opening balances,
  • a result establishment journal (GAUFIYRE setup).

When this box is checked, the program will create a closing journal by account.

Close

 

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

At least one dimension type must be entered
Chart of accounts incompatible
Impossible to change the chart of accounts or the dimension types

This message appears whenever a movement is saved for the ledger under modification.

Tables used

SEEREFERTTO Refer to documentation Implementation