Setup > Fixed assets > Grouping of expenses 

This function is used to create expense grouping setups, each one identified by a code.

This setup is used during the Capitalization of expenses processing in which the expenses are grouped on the basis of common criteria, in order to lead to the automatic creation of assets.
A new asset will be created for each expense / expense group meeting the grouping criteria.

This setup is used to specify:

  • the list of fields (of the expense table) used as grouping criteria, in addition to the following implicit mandatory criteria: Company, Financial site and Activity sector,
  • the information used to determine the main expense,
  • a possible selection to apply to the expenses.

SEEINFOThe expense grouping does not make it possible to update pre-existing assets.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Fields

The following fields are present on this tab :

Specifies he company to which the setup is applied.
This information is optional. If not entered, the setup is defined by default for every company.

  • Active (field FGACTIF)

This indicator is used to specify if this reference is active or inactive.
A reference declared Inactivecan not be used and is not proposed in the selection list during the Capitalization of expenses processing.

  • Reference (field GRPREF)

Setup reference of the expense grouping.

  • Description (field DES)

Setup description.

Close

 

Tab Parameter definition

Fields

The following fields are present on this tab :

Grid Grouping

  • field NBCRIT

 

  • Field code (field CODZON)

This table is used to specify the grouping criteria. These are the expense table (LAYOUTFAS) fields from which the expense grouping processing will be carried out.
Three grouping criteria are mandatory and are automatically populated: the company, the financial site and the activity sector.

  • Description (field DESI)

 

Block number 2

  • Principal expense (field PRILOF)

This field is used to specify which information is used by the grouping processing to identify the main expense from all the selected expenses.
It can be the following information:

  • Largest tax excl amount
  • Most recent invoice date
  • Oldest invoice date
  • Most recent accounting date
  • Oldest accounting date

SEEINFODuring the processing, the identification criterion of the main expense may not identify only one expense as the main one (for example: same tax excl amount, same invoice date, etc. ). In this case, the expense considered as the main expense will be the first one in this expense list, sorted in ascending order on their Reference / Line no.

Close

 

Tab Extended selection

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.

 

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation