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)

Reminder:

  • The events relating to the various actions performed on contracts (subscription, update, purchase option exercise, etc.), as well as automatic entries which enable their generation, are automatically managed when saving these actions.
     
  • The user can view the events in the Event Journal window that can be accessed from the Other info tab of the Contracts management function.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

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

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.

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

  • 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

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.

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.

..\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.

Block number 1

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

Specific Buttons

Memo

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.

Recall

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

Delete Memo

Click this action to delete a Memo code.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation