Financials > Current processes > Calculated journal entries 

This function is used to generate the account journals from a template journal defined during the setup of the calculated entries.

If the flow and the partner exist in the journal template, they are used to initialize the flow and the partner of the journal entry generated.

If there is no flow and no partner, these fields are initialized when the journal is generated.

SEEINFORead the documentation for Partner initialization and Flow initialization.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The generation of calculated entries is present on a single screen.

The status of postings in the launch screen must be "Definitive" when the "Actual" journal category is selected and when the company is:

  • either a French legislation company (the setup FRADGI/module TC/group CPT has "yes" for value and cannot be modified),
  • or a foreign company applying the French DGI no. 13L-1-06 compliance rules (the setup FRADGI/module TC/group CPT has "yes" for value and can be modified).

Entry screen

Presentation

The following criteria are sued to define which journals are taken into account for the calculation of the GL:

  • Company,
  • Site,
  • User,
  • Calculated entry range,
  • Date range.

Close

 

Fields

The following fields are present on this tab :

Criteria

  • All companies (field ALLCPY)

Select this check box to run the process for all companies. Otherwise, you need to select a company.

Specific case

In a multi-legislation environment, this check box is not available. The process can only be run one company at a time because the document type and journal for the posting are likely for a single legislation.

Enter the company code or use the Look up tool to search for and select the code.

 

  • All sites (field ALLFCY)

Select this check box to include all sites. To run this process for a single site, leave clear.

This code is used to identify the site concerned. It is unique for each site.

  • All users (field ALLUSR)

Select this check box to include all users. To run this process for a single user group, leave clear.

The current user will be used if the user/group code is blank.

If a user code is entered in this field, the process only includes accounting documents entered by the user. If left blank, only accounting documents for the current user are included.

  • From calculated entry (field CLPSTR)

 

  • To calculated entry (field CLPEND)

 

  • Start date (field DATSTR)

Enter the start date to filter for data within a date range.

  • End date (field DATEND)

Enter the end date to filter for data within a date range.

Generation

  • Generation type (field TYPGEN)

 

  • Entry status (field VCRSTA)

In the event of an actual generation, the status of the journal can be:

  • Temporary
  • Final

The entry status for entries must be Final when the requested generation type is Actual and the company meets one of the following criteria:

SEEINFOThe status defines your ability to modify the document. Once final, the modifications of the journal are only for information purposes or concern the analytical postings. The date, amounts, accounts, VAT code and other purely accounting information can no longer be modified.

In temporary mode, most of the information displayed on the journal can be modified. The modification options can vary based on:

  • The nature and the origin of the accounting document:
    • Temporary payment document: bank line that cannot be deleted
    • Purchase invoice document: BP line that cannot be deleted, purchase account and VAT that cannot be modified
  • The management events that have an impact on the account document are:
    • Charge account with a declared VAT amount
    • Matched VAT account or not

Document type that must be taken into account during the signature process or during a signature cancellation.

Enter the journal code (one to five alphanumerical characters) for which the entries generated by the calculation are recorded.
The journal can be initialized by default based on the type of document chosen. It corresponds to the accounting journal in which the entry will be recorded.

  • Entry date (field VCRDAT)

 

  • Reversal date (field VCRRVSDAT)

This indicator is used to specify whether the journal must be reversed or not.

  • Log file (field TRACE)

Select this check box to generate a log file at the end of the run.

Close

 

Batch task

This function can be run in batch mode. The standard task ACCCLP is provided for that purpose.

Specific Buttons

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

  • Memo code (field CODE)

You use a memo code to save the criteria applied to an entry screen. Use this field to find out if a memo code has already been saved for the current screen values.

Use the following buttons to manage memos:

Recall: Recall a previously defined and saved memo.

Memo: Save the current values of the screen in a memo file with a code to be specified.

Del. Memo: Delete a previously saved memo.

If a memo named STD (standard) is associated with the screen, it is loaded when opening the function.

Close

SEEREFERTTO Refer to the documentation help for the Memo button for further information.

SEEREFERTTO Refer to the documentation help for the Memo button for further information.

Limit

The management and generation of accounting documents using the double-entry method is not available for this function because it does not use an automatic journal process. Only functions that use an automatic journal process can use the double-entry method for a company.

The KRU - Russian legislation activity code must be active to use the double-entry method for a company.

Error messages

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

The posted documents will have the 'Final' status for the company

If the processing is launched for a given company and this company has selected Conformity DGI no. 13L-1-06 (i.e. the value of setup FRADGI/chapter TC/group CPT is 'yes'), the documents generated by the processing will have the status 'Final'.

The posted documents will have the 'Final' status for one or more companies

The processing is launched for all companies or a group of companies, and if at least one of the companies chose Conformity DGI no. 13L-1-06 (i.e. the value of setup FRADGI/chapter TC/group CPT is 'yes'), the documents generated by the processing will have the status 'Final'.

Tables used

SEEREFERTTO Refer to documentation Implementation