Generation of fee events @ L.V. Expertise X3

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Header
Tab Setup definition
Tab Extended selection

Screen management

Processing setup

First, it is necessary to set up the processing or to recall, using the button button, an existing setup previously saved under a Memo code.

The setup of the processing consists in:

Specifying the processing options.
Selecting the company or the potential financial sites where the processing will be carried out.
Entering the processing parameters.

Note: when the setup of a processing is completed, it is possible to save it under an identification code using the button . It can then be recalled for a future submission of entry generation processing.

The user can complete this setup via the Extended selection tab that is used to select the contracts to process.

Header

Presentation

The header contains the processing options and is used to select the company as well as the site(s) in which the contracts to be processed are referenced.

Fields

The following fields are present on this tab :

Options

Simulation (field FLGSIM)

This check box is selected by default and runs the closing in simulation mode. In this case, controls and the process are carried out but there are no updates recorded in the database.

Clear this check box to run in actual mode. In this case, you cannot reverse the closing and updates are recorded in the database. If you are using intermediate commits, it is recommended that the NIVTRACE – Log file level parameter (AAS chapter, MIS group) value is 0.

Report (field FLGETA)

This indicator can be accessed only when one or several reports are linked to the massive process. In this case, the activation of this indicator enables the user to print these reports.

Detailed log file (field FLGDET)

A log file is automatically displayed on process completion, showing the processing parameters. A Statistics section gives the number of selected assets, the number of assets updated as well as the number of assets not processed due to an error. Assets with errors are listed with their error reason.

When this box is ticked, the log file is displayed in the form of a detailed report presenting, in addition to the information listed above, the list of assets successfully processed.

The viewing and printing of log files are possible at any time via the report code ATRACE - Print log file print request, obtained from the Supervisor function in the Print/Group print menu.

Grid Company selection

field FLGCPY

Help common to all the mass processings.
The grid displays the list of the managed companies for which the user is authorized.
Check a box to select the company which must be processed.
After selecting a company, all the financial sites that are linked to it are selected by default. You can selectively de-select those that are not concerned by the processing.
You can also select directly the site(s) to be processed. In that case, the company to which they are attached is automatically selected.

SEEINFO When the company setupACCPERCTL - Control of accounting periods (chapter AAS, group CPT) has the value 'Yes', the company is not displayed in the list if at least one of its contexts is not synchronized with the accounting period/fiscal breakdown.The desynchronization status of a context is visible in the screenDetailed status of contexts that can be accessed from the Actions icon.In that screen, on the Calculation tab, the field Modification type has the value 'CNX' and the field Modified parameter has the value 'DESYNC'.In this case, it is necessary to launch the processing ofContexts synchronization.

Company (field CPY)

This field displays the company code.

Grid Site selection

field FLGFCY

The grid displays the list of the sites attached to the companies and for which the user has authorizations.
Check this box for the site to be taken into account in the processing.
After selecting a company, all the financial sites that are linked to it are selected by default. You can selectively de-select those that are not concerned by the processing.

Company (field FCYCPY)

Identification Code for the company which the site is linked to.

Site (field FCY)

Identification code of the site.

Options

Simulation:
This check box, selected by default, is used to carry out a simulation on the selected contracts. The modification of the contracts is not recorded in the database.
The list of the events generated in simulation mode can be viewed in the log file displayed at the end of the processing.
Detailed log file:
A processing log file is systematically displayed at the end of the processing, detailing the processing options used, the selection criteria, the parameter values and, for the company involved in the processing: the list of processed contracts (having the In progress status, with the number of selected and processed months for each contract)

When this box is ticked, the log file is displayed in the form of a detailed summary report presenting in addition to the information specified above, the list of the selected contracts (with the status In process and for which there are due dates covered by the processed period) displaying for each of them the monthly fee amount, the financial depreciation amount and the financial costs amount.
The errors that may have occurred during the processing execution are mentioned at the end of the log file.

Note: the viewing and printing of the log files is possible at any time via the Print log file print request of the ATRACE report code, obtained from the Supervisor function in the Print/Group print menu.

Company selection – Site selection

These tables display both the list of managed companies for which the user is authorized and the list of sites corresponding to these companies where the user is authorized.

They are used to select the company and the sites in which the contracts to process are registered. After the selection of the company, all the sites linked to the company are selected by default. The user can de-select those that are not concerned by the processing.
It is also possible to directly select the site(s) on which the processing will be carried out; in this case, the company to which they belong, is automatically selected.

After selecting the company or the site(s), the user can refine the selection by entering other selection criteria in the Extended selection tab.

Tab Setup definition

Presentation

This tab is used to enter the parameters required for the process: the start and end date of the period to process. This period can be a different period for the generation of events used for the creation of entries of individual accounts, than the period for the creation of events of consolidated accounts.

Fields

The following fields are present on this tab :

Individual accounts

From open item (field STRPAYDAT)

This field enables the user to enter the period start date to process for the generation of the events necessary to the production of account postings destined to the CoA individual accounts.

To open item (field ENDPAYDAT)

This field enables the user to enter the period end date to process for the generation of the events necessary to the production of account postings destined to the CoA individual accounts.

Consolidated accounts

From open item (field STRPAYDATI)

This field enables the user to enter the period start date to process for the generation of the events necessary to the production of account postings destined to the IFRS consolidated accounts.

To open item (field ENDPAYDATI)

This field enables the user to enter the period end date to process for the generation of the events necessary to the production of account postings destined to the IFRS consolidated accounts.

Tab Extended selection

Presentation

This tab is used to enter the contract selection criteria.

It contains five lines, each of them used to enter a criterion, with each criterion being linked to the next by one of the following logical operators: And, Or.

The process for selection criteria entry is as follows:

1/ Enter, or select from the list obtained by a right click, the field in contracts table LEASE, which contains the information to which the selection is applied.

2/ Then select the operator: Any, Equal, Different, Greater than or equal, Less than, Lessthan or equal, Like.
The Like operator is valid only for numeric fields. It makes it possible to use wild card characters.

3/ Enter a value. The list of possible values for the chosen field can be obtained with a right click when these values are contained in a local menu or in a table (miscellaneous table, common table, accounting table, etc.).

The user can also:

- enter the criteria as an Adonix expression; the formulas of this type can be entered by right-clicking the fields in contracts table LEASE,

- enter a selection formula using the formula editor.

$..\FCT\SEEINFO$ The selection options are the same as those used in the standard Advanced selection function.For more information, see the documentation on ADONIX object ergonomics.

Fields

The following fields are present on this tab :

Block number 1

Grid

Fields (field FLD)

Use the look-up icon to select a field from the Fixed assets table.

Memo (field PAR)

Select this checkbox to save this search option.

Block number 2

Expression (field EXP1)

Use this field to enter an expression for the selection criteria.

This criterion is added to the previous criteria by the link AND.

The expression cannot contain fields from a table other than the Fixed assets table. These can be indexed.

Memo (field PAREXP)

Select this checkbox to save this search option.

Processing description

Reminder:
- Only the contracts In progress are processed.
- All invoiced open items, i.e. all the open items for which the invoice date and reference are entered, are excluded from the processing.

The processing generates for the selected contracts an event for each calendar month of each non-invoiced open item that meets the following criteria:

- The start date of the open item is included in the period to process
Or
- The end date of the open item is included in the period to process
Or
- The start date of the open item falls before the start date of the period to process
, and
- The end date of the open item falls before the end date of the period to process.
At the end of a non simulated processing, the flag of the fee events generation (CoA posting flag and/or IFRS posting flag) is automatically activated on each processed open item of the selected contracts.

Examples for the loading of event fields:

Quarterly open items:
E1: from 15/03/N to 14/06/N
E2: from 15/06/N to 14/09/N
E3: from 15/09/N to 15/12/N
Period to process: from 01/01/N to 30/06/N

The open items E1 and E2 are selected.
The processing generates the following 8 events:

1/ Generation of an event for March - open item E1

Date fields	Title	Value
PAYSTRDAT	Start date of the period processed	01/01/N
PAYENDDAT	End date of the period processed	06/30/N
PERSTRDAT	Month start date/processed open item	03/15/N
PERENDDAT	Month end date/processed open item	03/31/N
FSTMTHDAT	End date of the processed calendar month	03/31/N
Amounts fields	Title	Value
LEAPAYAMT	Fee amount	Value stored over the payment period
LEAPRIAMT	Financial depreciation amount	Value stored over the payment period
LEAINTAMT	Financial cost amount	Value stored over the payment period
LEAPAYAM	Fee amount for March	Calculated in proportion to the day
LEAPRIAM	Financial depreciation amount for March	Calculated in proportion to the day
LEAINTAM	Financial cost amount for March	Calculated in proportion to the day

2/ Generation of an event for April - open item E1

Date fields	Title	Value
PAYSTRDAT	Start date of the period processed	01/01/N
PAYENDDAT	End date of the period processed	06/30/N
PERSTRDAT	Month start date/processed open item	04/01/N
PERENDDAT	Month end date/processed open item	04/30/N
FSTMTHDAT	End date of the processed calendar month	04/30/N
Amounts fields	Title	Value
LEAPAYAMT	Fee amount	Value stored over the payment period
LEAPRIAMT	Financial depreciation amount	Value stored over the payment period
LEAINTAMT	Financial cost amount	Value stored over the payment period
LEAPAYAM	Fee amount for April	Calculated in proportion to the day
LEAPRIAM	Financial depreciation amount for April	Calculated in proportion to the day
LEAINTAM	Financial cost amount for April	Calculated in proportion to the day

3/ Generation of an event for May - open item E1

Date fields	Title	Value
PAYSTRDAT	Start date of the period processed	01/01/N
PAYENDDAT	End date of the period processed	06/30/N
PERSTRDAT	Month start date/processed open item	05/01/N
PERENDDAT	Month end date/processed open item	05/31/N
FSTMTHDAT	End date of the processed calendar month	05/31/N
Amounts fields	Title	Value
LEAPAYAMT	Fee amount	Value stored over the payment period
LEAPRIAMT	Financial depreciation amount	Value stored over the payment period
LEAINTAMT	Financial cost amount	Value stored over the payment period
LEAPAYAM	Fee amount for May	Calculated in proportion to the day
LEAPRIAM	Financial depreciation amount for May	Calculated in proportion to the day
LEAINTAM	Financial cost amount for May	Calculated in proportion to the day

4/ Generation of an event for June - open item E1

Date fields	Title	Value
PAYSTRDAT	Start date of the period processed	01/01/N
PAYENDDAT	End date of the period processed	06/30/N
PERSTRDAT	Month start date/processed open item	06/01/N
PERENDDAT	Month end date/processed open item	06/15/N
FSTMTHDAT	End date of the processed calendar month	06/30/N
Amounts fields	Title	Value
LEAPAYAMT	Fee amount	Value stored over the payment period
LEAPRIAMT	Financial depreciation amount	Value stored over the payment period
LEAINTAMT	Financial cost amount	Value stored over the payment period
LEAPAYAM	Fee amount for June	Calculated in proportion to the day
LEAPRIAM	Financial depreciation amount for June	Calculated in proportion to the day
LEAINTAM	Financial cost amount for June	Calculated in proportion to the day

5/ Generation of an event for June - open item E2

Date fields	Title	Value
PAYSTRDAT	Start date of the period processed	01/01/N
PAYENDDAT	End date of the period processed	06/30/N
PERSTRDAT	Month start date/processed open item	06/15/N
PERENDDAT	Month end date/processed open item	06/30/N
FSTMTHDAT	End date of the processed calendar month	06/30/N
Amounts fields	Title	Value
LEAPAYAMT	Fee amount	Value stored over the payment period
LEAPRIAMT	Financial depreciation amount	Value stored over the payment period
LEAINTAMT	Financial cost amount	Value stored over the payment period
LEAPAYAM	Fee amount for June	Calculated in proportion to the day
LEAPRIAM	Financial depreciation amount for June	Calculated in proportion to the day
LEAINTAM	Financial cost amount for June	Calculated in proportion to the day

6/ Generation of an event for July - open item E2

Date fields	Title	Value
PAYSTRDAT	Start date of the period processed	01/01/N
PAYENDDAT	End date of the period processed	06/30/N
PERSTRDAT	Month start date/processed open item	07/01/N
PERENDDAT	Month end date/processed open item	07/31/N
FSTMTHDAT	End date of the processed calendar month	07/31/N
Amounts fields	Title	Value
LEAPAYAMT	Fee amount	Value stored over the payment period
LEAPRIAMT	Financial depreciation amount	Value stored over the payment period
LEAINTAMT	Financial cost amount	Value stored over the payment period
LEAPAYAM	Fee amount for July	Calculated in proportion to the day
LEAPRIAM	Financial depreciation amount for July	Calculated in proportion to the day
LEAINTAM	Financial cost amount for July	Calculated in proportion to the day

7/ Generation of an event for August - open item E2

Date fields	Title	Value
PAYSTRDAT	Start date of the period processed	01/01/N
PAYENDDAT	End date of the period processed	06/30/N
PERSTRDAT	Month start date/processed open item	08/01/N
PERENDDAT	Month end date/processed open item	08/31/N
FSTMTHDAT	End date of the processed calendar month	08/31/N
Amounts fields	Title	Value
LEAPAYAMT	Fee amount	Value stored over the payment period
LEAPRIAMT	Financial depreciation amount	Value stored over the payment period
LEAINTAMT	Financial cost amount	Value stored over the payment period
LEAPAYAM	Fee amount for August	Calculated in proportion to the day
LEAPRIAM	Financial depreciation amount for August	Calculated in proportion to the day
LEAINTAM	Financial cost amount for August	Calculated in proportion to the day

8/ Generation of one event for September - open item E2

Date fields	Title	Value
PAYSTRDAT	Start date of the period processed	01/01/N
PAYENDDAT	End date of the period processed	06/30/N
PERSTRDAT	Month start date/processed open item	09/01/N
PERENDDAT	Month end date/processed open item	09/15/N
FSTMTHDAT	End date of the processed calendar month	09/30/N
Amounts fields	Title	Value
LEAPAYAMT	Fee amount	Value stored over the payment period
LEAPRIAMT	Financial depreciation amount	Value stored over the payment period
LEAINTAMT	Financial cost amount	Value stored over the payment period
LEAPAYAM	Fee amount for September	Calculated in proportion to the day
LEAPRIAM	Financial depreciation amount for September	Calculated in proportion to the day
LEAINTAM	Financial cost amount for September	Calculated in proportion to the day

Memo
Recall
Delete Memo

Specific Buttons

Click this action to save the current settings to a Memo code to be reused later. The memo is linked to your user profile, not to the function or the screen.

The STD memo code is associated with the screen and is loaded immediately when you open the function.

For more information on the advanced use of the Memo action, refer to the documentation on the General ergonomics of SAFE X3 software.

Click this action to enter a Memo code to load the settings associated with the code.

Click this action to delete a Memo code.

Generic messages

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation