Common data > General accounting tables > General > Journal codes 

The journal features a document in which the accounting entries are recorded by chronological order. In practical terms, several journals are created in order to regroup entries based on their nature (sales journals, purchase journals, cash journals etc.).

The setup function of journal codes is used to define the characteristics of the various journals that will be used to record entries, whether the latter are entered, generated by automatic processes or by interfaces to other applications.

Each journal is identified by a code and a journal type.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Fields

The following fields are present on this tab :

Header

Here, indicate the journal code comprised of one to five alphanumeric characters.
Upon creation, the journal is automatically open for all the specified periods.
The journal selected here must be of the same type as the journal linked to the journal type kept in the previous selection criteria.

SEEWARNINGIt is mandatory to enter this field if the box 'All journals' is not checked.

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.

  • Description (field DESTRA)

 

  • Short description (field SHOTRA)

 

  • Company/Site/Group (field FCY)

 

  • field FCYDES

 

Close

 

Entry screen

Presentation

The setup of accounting journal is executed in a general tab that is used to specify the elements required to identify the journal as well as the principles for using it.

Upon creation, the journal is automatically open on all the periods defined in the folder.

Management

Upon journal entering, if a journal is not balanced, the balance is done on a contra account when the journal is validated via the button [Create]. The cash account is used as an automatic contra account.

SEEWARNING Theledgermust be checked to 'Balance'.

Close

 

Fields

The following fields are present on this tab :

Identification

  • Type (field TYP)

Select the journal type to group journals based on common characteristics mainly linked to the nature of operations recorded in it. Once you post entries to a journal, you cannot change the type.

Journal type options:

  • Sales
  • Purchases
  • Treasury
  • Miscellaneous 1 – reserved for general accounting*
  • Miscellaneous 2 – reserved for general accounting*
  • Miscellaneous 3 – reserved for general accounting*
  • Carry forward
  • Miscellaneous 4 – reserved for analytical accounting*
  • Miscellaneous 5 – reserved for analytical accounting*
  • Miscellaneous 6 – reserved for analytical accounting*

*Note:You can rename a Miscellaneous journal type with a custom category by modifying Local menu 613 if you have the proper user permissions to do so.

There are processes and controls linked to certain journal types.

Treasury journal types: A cash account must be attached to each “cash” journal type so that the entries posted in this journal have an automatic counterpart. For details on setting up cash or “treasury” journals, refer to the documentation for Definition of the journals, journal types and accounts on payments.

A cash type journal is used in:

A/P-A/R accounting module on payment posting [due to automatic journal setup]

Manual journal entries: Treasury journal types can only be used if the cash account is a normal account, not a control account.

Carry forward journal types: This type of journal only records carry-forward entries.

Analytical accounting journal types: This type of journal only records entries assigned to an analytical dimension.

Select or enter the flow code for this journal.

Flow initialization: The initialization rule only applies to accounts with Optional or Mandatory flow management selected and only for the first ledger defined in the journal entry transaction whose consolidation management is selected.

When creating or posting a journal entry, the journal entry line flow code defaults as follows:

If a flow code is parameterized on the journal, it defaults to that value.

If there is no flow code on the journal, the flow code defaults to the value defined on the account.

The flow depends of the direction on the journal entry line.

If the direction is Credit, the flow defaults to Flow if Credit

If the direction is Debit, the flow defaults to Flow if debit.

If the amount is 0 for both debit and credit, the flow defaults to Flow if debit

If there is no flow code on the account, the flow code defaults to the flow defined in the CSLFLODEF - Default flow parameter.

If this parameter is not defined, there is no default flow code value.

Note: When the journal entry transaction has several ledgers with consolidation management selected, the flow initialized on the first ledger is propagated to the other consolidated ledgers. If for any reason no flow has been initialized on the first ledger but is mandatory on another ledger, you receive a blocking error message that flow management is mandatory for the current account.

Accessibility

  • Active (field ENAFLG)

When it has been entered, the access code makes it possible to limit the operational rights on the journals based on the user profiles.
These rights are defined for each of the following operations:

  • journal inquiry,
  • posting of entries on the journal,
  • modification of the database record (i.e. : of the journal parameterization).

The use of the journal can also be limited to the site assigned to the ad hoc field.

Grid Management

This field calls the chart of accounts on which the frequent and prohibited accounts -regarding the current journal- will be specified.

Specify the treasury account (bank, cash, etc.) linked to the current journal. When posting an entry to this journal, an automatic counterpart is generated on this account to balance the journal, if needed.

When the journal is set to Treasury, the entered treasury account must be defined at the Accounts setup level as Not subjected to tax.

Close

 

Reports

By default, the following reports are associated with this function :

 JOUGRP : Journal codes

 LISJOU : List of journals

This can be changed using a different setup.

Specific buttons

This button is used to open a display window of the journal status for each period and each company. When the journal is inactive, it cannot receive any recording.

The companies are filtered according to the legislation of the journal record.
The buttons [First], [Previous], [Next], [Last] are used to browse companies in the alphabetical order.

The following fields are included on the window opened through this button :

Block number 1

This field calls the chart of accounts on which the frequent and prohibited accounts -regarding the current journal- will be specified.

Here, indicate the journal code comprised of one to five alphanumeric characters.
Upon creation, the journal is automatically open for all the specified periods.
The journal selected here must be of the same type as the journal linked to the journal type kept in the previous selection criteria.

SEEWARNINGIt is mandatory to enter this field if the box 'All journals' is not checked.

 

Specify the treasury account (bank, cash, etc.) linked to the current journal. When posting an entry to this journal, an automatic counterpart is generated on this account to balance the journal, if needed.

When the journal is set to Treasury, the entered treasury account must be defined at the Accounts setup level as Not subjected to tax.

Grid Frequent account list

  • No. (field NUMLIG2)

 

It is possible to specify the most frequently used accounts on a journal, by means of the * and ? wildcards.
A mnemonic on a character (letter or number) in entry mode can be associated with it. The concerned accounts will be an exception to the forbidden accounts.

  • the mnemonic of the general account is comprised of 2 to 4 characters.
  • it is solely associated with the account and not with the entry on a particular journal.

This code must not be mistaken with the mnemonic set up in the record of the general account.

  • Short codes (field FRQCOD)

This field lists the mnemonics associated with the usual accounts of this journal. The mnemonic can be a letter or a number.
In journal entry mode on this journal, it is then possible to access these accounts simply by calling this mnemonic instead of the account number.

Grid Prohibited account list

  • No. (field NUMLIG1)

 

  • Restricted accounts (field FBDACC)

It is possible to prohibit the use of a particular account or a group of accounts on the journal, defined by means of the * and ? wildcards.

Close

The button [Plan] is used to define on each chart of accounts, the list of frequent accounts and of prohibited accounts.
By default, the window opens on the first available chart of accounts, even if a chart of accounts has already been selected in the Journal window.
The suggested chart codes are the ones of the legislation recorded for the chart.
GESJOU_01 The buttons [First], [Previous], [Next], [Last] are used to browse companies in the alphabetical order.

Local menus

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

Mandatory field

An account must necessarily be attached to the journal for the automatic entry counterpart. This message is only displayed for the "cash" type journals, in the cash account field.

You do not have access to this code.

The entered access code does not exist in the table or the user creating the journal does not have access to this code. The selection function should be used to find out an existing or authorized code.

Incompatible sites

The journal site and the cash account journal associated with the journal are not the same. Consequently, this account cannot be associated with this journal except if the access controls to the account or journal sites are changed.

Incorrect Date

This message can be displayed for instance if the validity end date entered is earlier than the validity start date.

Tables used

SEEREFERTTO Refer to documentation Implementation