Use this function to define the structure for journals that must be posted for all modules. This includes posting a sales or purchase invoice entry, a depreciation charge, a payment, an automatic reversal, etc.

Each module generates entries for accounting validation in this way. This transfer is done by a standard subprogram by transferring a code for the operation. For example, the BPCIN code is called when validating a customer business partner invoice.

The application programs control the code used and the time of the call to the generation subprogram.

Setup basics and grouping lines

To set up automatic journals you need to define:

  • The header code on the journal entry screen
  • The detailed characteristics for the entry set to be transferred

You can also set up automatic journal groups to define automatic journals generated simultaneously by identifying which entries to match.

The definition of an automatic entry is made by defining

  • The entry header characteristics
  • The line characteristics by means of a series of associated line definitions


SEEINFO Defining a line can lead to the creation of a group of entry lines. Indeed, the type of the lines can be unique, repetitive, or in linked table. The latter two cases can potentially lead to the creation of a group of lines.

Conversely, the lines can be automatically grouped, provided the following criteria are identical on the lines concerned:

  • The general ledger
  • The business partner (if the general ledger is a control account)
  • The site
  • The nature
  • The label for the line
  • The tax code
  • The distribution key if a distribution key exists on the line; if it is a dimension, having different dimensions does not prevent grouping lines, an analytical distribution is created.
  • The sign if the debit/credit compensation check box is not selected

Defining journals by currencies

You can define a journal by currency by indicating the posting currency in the header fields.
At this stage, managing the currency exchange rates to determine the amounts in accounting and reporting currency is made as follows:

  • The amounts in the currency and those in other the currencies are set for all the entry lines by defining the formulas for the Company amount and Reporting amount fields.
    This supposes that the calculated amounts are actually balanced in all the currencies. If not, a "Journal not balanced in currency..." error displays.
    In all other cases, (i.e., if at least one company and reporting amount is calculated), there is an automatic transfer of the conversion variance lines if not all are balanced in the reporting or company currencies.
  • If the reporting and company currencies are not defined for certain lines, the formulas defined for the Exchange rate and Reporting exchange rate fields defined in the document header are used: The non-defined amounts are then calculated by applying the rates.
  • If the previous case is found, but without the formula for the Exchange rate and/or Reporting exchange rate fields, the exchange rate type is used to determine the exchange rate on the accounting date for the entry posting. Finally, failing this, it is possible to use the exchange rate type associated with the document type to determine the exchange rate to be applied to calculate the missing amounts.

Pure analytical entries

Defining an analytical general ledger is made in the same way as a general document, but imposes an adapted document type and only entering the natures and dimensions concerned, which then becomes mandatory.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Click Lines to open a screen where you can define the journal entry lines to generate.

Header

Entry screen

Linked table list

Define the tables linked the triggering table. You can use the fields in these tables in the calculation formula for the previous grid.
Example: Information linked to the business partner record (BPSUPPLIER) for the journal entries can be linked to the invoice.
The second column in this grid defines the field in the triggering table whose value defines the linked record to be read. There are several possibilities: For an invoice, this can be the invoicing BP or the paying BP. Click the Selection icon for a list of possible fields.

Formulas associated with the header fields

In this grid, you can define the calculation formulas used to calculate the value of the fields in the journal entry header. The calculation formulas in this grid must be of the correct type. For example, if the amounts must be numeric, the journal code must be alphanumeric.

These calculation formulas can simply be constants in the most simple case. For example, the sales journals can be constant and called SAL: In this case, a calculation formula "SAL" is sufficient to define the journal. They can also be more complicated and include fields extracted either from the triggering table or from the links tables defined by the Linked table list explained above. In certain cases, a default value is assigned to the field if no calculation formula has been defined.

The VAT date defaults from the accounting date or the document date, depending on the DCLVATDAT – Date for tax declaration parameter (CPT chapter, VAT group) setting. However, you can enter a formula to use a custom date. This date must comply the legislation rules for the declaration.

Key fields in the header:

  • Category: a local menu field for which a numeric value must be returned: 1= Actual, 2 = Active simulation, 3 = Inactive simulation, 4 = Off balance sheet, 5= Template. The default value is 1.
  • Status: 1=Temporary, 2 = Final. The default value is 1.
  • Journal entry type: Mandatory, the journal entry number, which is assigned automatically if it is not set, and the accounting journal. If it is not assigned, the journal associated by default with this journal entry type is used.
  • Site: The default site for the user if another site it not entered.
  • Different dates: The accounting date is the current date by default. The open item date is the accounting date by default.
  • Currency: The site currency is the default. The type of exchange rate, by default, is the one associated with the journal entry type, 1 if not entered.

Tab Traceability

Use these fields to link grouped accounting documents to related original transactions in the main general ledger only. This in turn enables a direct link (Tracking/Payments) to related documents from the journal entry lines.

This is only possible for automatic journal groups and where auto journals are used in the payment process.

There are two tracking options:

1. Data linked to an accounting document such as an invoice or a payment.

Upstream traceability is automatic when you select the Traceability check box. Then, you select the Triggering table and Index.

This enables the following option on the accounting document line:

Payments: Provides direct access to each original payment.

Tracking: Opens the Follow-up of an accounting line screen to view a summary of original triggering documents. This screen displays a summary line for each payment and a total for all lines based on the fields entered in the Parameters grid. You can click the Payment line action for each payment to see details.

2. Data not linked to an accounting document such as open items, stock, fixed assets, etc.

Upstream traceability is not automatic and a detailed set up is required. In addition to the steps above, you need to enter an Action and set up the Parameters to display accurate data from the triggering table.

Reports

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

  GAUTACE : Automatic journals

This can be changed using a different setup.