Calculated Journal Generation
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.
Read the documentation for Partner initialization and Flow initialization.
Prerequisites
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
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.
Criteria
All companies (field ALLCPY) |
Select this check box to run the process for all companies. Otherwise, you need to select a company. Specific caseIn 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. |
Company (field CPY) |
Enter the company code or use the Look up tool to search for and select the code. |
Legislation (field LEG) |
All sites (field ALLFCY) |
Select this check box to include all sites. To run this process for a single site, leave clear. |
Site (field FCY) |
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. |
User (field USR) |
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:
The entry status for entries must be Final when the requested generation type is Actual and the company meets one of the following criteria:
The 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:
|
Entry type (field VCRTYP) |
Document type that must be taken into account during the signature process or during a signature cancellation. |
Journal (field VCRJOU) |
Enter the journal code (one to five alphanumerical characters) for which the entries generated by the calculation are 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. |