Principal and component assets

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