Reports > Module Fixed Assets > Report FASMAIN (Principal and component assets) 

This report reproduces the list of the fixed assets with the Main status, responding to the selection criteria, by displaying for each of them, when the print is asked in detailed form, the list of the fixed assets with ComponentandAdditional componentstatus that are attached to it.
The values of the depreciation plan specified in setup are displayed for each of these fixed assets.

The assets are classified by company, financial site and accounting code with a sub-aggregation at each break on one of these criteria.

It is also possible to get a synthesis edition displaying only sub-aggregations per main asset, accounting code, financial site and company.

A general total is displayed in the case of a multi-company print.

Prerequisite

Access to the report

This report can be accessed from the report menu of the group Fixed Assets - Fixed assets.

List of criteria

Parameter

Parameter title

Type

cpydeb

Company limit

CPY

fcydeb

Financial site range

FCY

ccptdeb

Accounting code range

CAC

accdeb

General account ranges

GAC

accifrsdeb

IFRS" account range

GAC

typdetdeb

Holding type (Local menu Owned, Rented, Leased, Provisional, Concession...)

M3171

refdeb

Asset range

AAS

plan

Depreciation plan (Local menu Accounts, Finance, Minimum, Source, Reevaluation 76...)

M3101

situation

FY or period (Local menu Financial year, Period, Period total)

M3186

datdeb

Date range

D4

actif

Active assets (Local menu No, Yes)

M1

detail

Detailed status by asset (Local menu No, Yes)

M1

impselections

Print selections (Local menu No, Yes)

M1

Comments

The data is filtered by site according to the rights granted to the user on the function GESFAS (Assets).

Miscellaneous

The value entry for the selection parameters is optional. The default values displayed are those entered at the level of the Report dictionary.

When the values are entered, no existence control is carried out. In the case where they do not exist or are not consistent, no print occurs.

Description of the report

Implicit selection:

Are selected only the assets with Main status and the assets with Component or Additional component status that are attached to it.

Are excluded:

-the fixed assets issued during the previous financial years,-
- the assets whose depreciation start date is greater than the current financial year end date or the current period (according to the value entered for the selection setup: Financial year situation or Period).

Grouping criteria/classification and aggregation

The assets are displayed grouped and classified in ascending order according to the following criteria:

- Company                             Aggregation per company with page break
- Financial site                      Aggregation per financial site with page break
- Accounting code                 Aggregation per accounting code without page break
- Main asset                  Aggregation per principal asset

Recovered information

The report content varies according to the value entered for the setup: Report detailed per asset (or synthesis report).

  • Header 
     
    The header recalls the following information:
    - Company reference

    - Financial year chosen (current or following) start and end dates of the depreciation plan selected
  • Detailed report
     
    This report displays two lines per fixed asset selected (main asset and component asset).

    On the first line:

Information

Loaded from the headings

Table

Reference

AASREF

FAS

Description 1

AASDES1

FAS

Purchase date

PURDAT

FAS

Depreciation start date

STRDPRDAT

DEP

Account number

ACC or IASACC

FAS

Holding type

OWNTYP

FAS

Ex-tax receipt value

ACGETRNOT or IASETRNOT

FAS

Balance sheet value

DPRBAS

DEP

Residual value

RSDVAL

DEP

Financial year or period end net value

NBV

DEP

Market value

NSPVAL

DEP

On the 2nd line:

Information

Loaded from the headings

Table

Description 2

AASDES2

FAS

First use date

ITSDAT

FAS

Issue date

ISSDAT

FAS

Mode

DPM

FAS

Duration

DPRDUR

FAS

Rate

DPRRAT

FAS

Depreciation aggregation financial year or period start

DPRCUM or DPRCUMR

DEP

Impairment loss balance financial year or period start

IMLBLC

DEP

Financial year* or period charge

ENDDPE or PERENDDPE

DEP

Financial year or period recovery or impairment loss

Calculation: {DEPREC.IMLRVE_0} – {DEPREC.IML_0}

DEP

*This is the normal depreciation expense + exceptional depreciation expense

The report then displays the aggregation lines identical to those displayed below for a synthesis report.

  • Synthesis report
     

    This report displays:
     
    - 2 aggregation lines per shortage on main asset selected, accounting code, company financial site.- 2 lines of general total are also displayed in the last page, if the report concerns several companies.
     
    On the 1st line:
     
    - Ex-tax Total Entered value, CoA or IFRS according to the selected depreciation plan
    - Total Balance value, of the selected plan
    - Total residual value, of the selected plan
    - Total net value financial year or period end, of the selected plan
    - Total Market value, of the selected plan

    On the 2nd line:

    -Total Aggregation depreciation, of the selected plan
    -Total impairment loss balance, of the selected plan
    -Total (Normal depreciation expense + Exceptional depreciation expense), of the selected plan
    -Total (Recovery-Impairment loss), of the selected plan

Grids concerned

The data extracted from the following tables are processed by the report FASMAIN :

Table

Table description

AFCTFCY [AFF]

Site profile function

COMPANY [CPY]

Company

CONTEXT [CNX]

Contexts

DEPREC [DEP]

Charge

FACILITY [FCY]

Sites

FISCYEAR [FIS]

Fiscal year

FXDASSETS [FAS]

Assets

GACCCODE [CAC]

Accounting codes