This processing is used to generate fee/rent events (LEAPAY) recorded on the financial lease contracts. These events are used to generate the accounting entries:
- of the Fees/Invoices to receive, for the CoA individual accounts (LSPAY – Leasing due date),
- of the Accrued interests for the IFRS consolidated accounts (LCPAY – Leasing due date)

Prerequisite

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.

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

Field descriptions

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.

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 of Contexts 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

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

Field descriptions

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

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.

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.

Field descriptions

Block number 1

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

Fields (field FLD)

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.

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:

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

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

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

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

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

Generation of fee events

Prerequisite

Screen management

Processing setup

Header

Options

Grid Company selection

Grid Site selection

Options

Company selection – Site selection

Tab Setup definition

Individual accounts

Consolidated accounts

Tab Extended selection

Block number 1

Block number 2

Processing description

Examples for the loading of event fields:

Specific Buttons

Error messages

Tables used