Fixed assets > Processes > Movements > Capitalization of expenses 

This function is used to automatically create assets from the grouping of expenses.
It is based on a Grouping of expenses code whose setup specifies criteria for selecting and grouping the concerned expenses.

This processing is a single-company processing.

SEEREFERTTO A quite similar but unit processing for creating assets via expense capitalization is available from the Asset management function.
SEEREFERTTO See the documentation on Capitalization of expenses.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

This function is composed of:

- a header that is used to specify the processing options and to choose the company and the financial site(s) to which the expenses to be processed belong,

- the Parameters tab used to enter the reference of the grouping code on which the process is based,

- the Extended selectiontab used to select the expenses to be processed.

Header

Presentation

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

Close

 

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.

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.

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

Identification code of the site.

Close

 

Tab Parameter definition

Presentation

Only the Grouping code defined in the setups of the asset management must be entered.

Close

 

Fields

The following fields are present on this tab :

Grouping

  • Description (field GRPDES)

 

Close

 

Tab Extended selection

Presentation

This tab is used to enter the expense selection criteria. This selection is applied in addition to the one defined at the level of the setup of the Grouping of expensescode.

It contains five lines, each of them used to enter a criterion, with each criterion being linked to the next one 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 the LAYOUTFAS expense table, 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 the LAYOUTFAS expense table,

- enter a selection formula using the formula editor.

The selection options are the same as those used in the standard Advanced selection function.
SEEREFERTTOFor more information, see the documentation on X3 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

  • Expense selection
     
    The selected expenses are those not already linked to assets and meeting the selection criteria entered at the level of the grouping code setup, and completed when necessary, with the criteria entered in this function.
  • Expense grouping by application of:
    - implicit grouping criteria: company, financial site and activity sector,
    - setup criteria.

  • Main expense determination:
    - according to the criterion entered at the level of the grouping code.
  • Field loading rules for the asset:
     
    - The rules are the same as for a unit processing of asset creation by expense grouping and are specified in the documentation Capitalization of expenses (LOFLDAB).
     
    - The asset entry origin automatically takes the following value: "Expense grouping".

The list of capitalized expenses is displayed

  • In the log file displayed on exiting the processing:all the criteria are recalled followed by the created asset reference, the list of the capitalized expenses and the indication of the main expense.
     
  • At asset level:
     
    - the "Grouped expenses" left list displays the list of capitalized expenses,
     
    - the "Capitalize" button displays the expense capitalization unit processing window and displays the list of capitalized expenses along with their valuation and accounting posting. 
     
  • According to the entered selection criteria,the FASLISGRP - Expense grouping report displays the list of all the created assets and for each of them, the list of its attached expenses with the indication of the main expense.

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.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation