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 expense grouping does not make it possible to update pre-existing assets.

Prerequisites

See also Refer to documentation Implementation

Screen management

Header

Field descriptions
Company (field CPY)

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.

Tab Parameter definition

Field descriptions

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

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

Tab Extended selection

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.

Error messages

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation