Reports > Module Fixed Assets > Report DEPSITUREINT (Reintegration of depreciation) 

This report displays the situation of the depreciation reintegration of the financial year or of the current period for each of the selected assets.

The assets are classified by company then by values of Sort criteria 2and 3chosen by the user, with a sub-aggregation at each break on one of these criteria.

It is also possible to get a synthesis edition presenting only sub-aggregations by accounting codes, financial site and company.

A general total is presented in the case of a multi-company edition.

..\OBJ\SEEINFO The amounts of the exceptional depreciation are carried by the chart of accounts, contrary to the amounts of the exceptional depreciation carried by the chart of accounts, displayed at the level of the DEPSITUDERO report (Book vs tax situation).

 

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

situation

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

M3186

datdeb

Date range

D4

actif

Active assets (Local menu No, Yes)

M1

selentree

Entry selection (Local menu All Assets present in Fiscal year/Period...)

M3271

selbiensor

Selection of the issued assets (Local menu Issued and non issued assets, Non issued assets...

M3267

biensor

Basis = 0 if issue (Local menu No, Yes)

M1

tri2

Classification criterion 2 (Local menu Financial site, Accounting code, CoA account...)

M3265

tri3

Classification criterion 3 (Local menu Financial site, Accounting code, CoA account...)

M3265

detail

Detailed status by asset (Local menu No, Yes)

M1

impselections

Print selections (Local menu No, Yes)

M1

Comments

The parameter cpydeb can take several successive values. The report is then divided in parts that are printed successively and limited by the range values entered. This improves the  performance of Crystal Reports (slow pagination for  particularly large reports, with several thousand pages).

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

Miscellaneous

1/ The value entry for the 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 edition occurs.

2/ The Start and End datesentered at the level of the Start date setup: Date ranges, must exactly match the ranges of a financial year in the case of a Financial yearsituation, or at the ranges of a period, in the case of a Periodsituation.

3/ According to the chosen value for the Entry selectionsetup: Entry selection, the selection is applied in the following way:
- All the fixed assets available in the financial year/period : are selected only the fixed assets of which the smallest of the two following dates: Posting date and First use date, is lower or equal to the financial year end date/period asked.
- Fixed assets entered in the financial year/period: only the fixed assets of which the posting date is located on the financial year or on the period asked are selected.
- Fixed assets previous to the financial year/period: only the financial assets whose posting date is previous to the financial year start date or to the asked period are selected.

4/ The Issued asset setup: Basis =0 if assets issued, is applied only:
- to the assets whose issue date is lower or equal to the financial year or period end dates (according to the situation asked),
- to the assets whose depreciation start date is greater than the financial year or period end dates (according to the situation asked).
When the value is set to Yes, the heading Balance value is always displayed with the 0 value on the report.

Description of the report

Implicit selection:

Are selected only the assets having a depreciation amount to reintegrate for the period of the financial year asked.
Are systematically excluded, 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 and date ranges entered).

Grouping criteria/classification and aggregation

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

- Company. Aggregation per company with page break
- 2nd classification criterion: per default, theFinancial site. Aggregation per criterion with page break
- 3rd classification criterion: by default, the Accounting code. Aggregation by criterion with page break
- Fixed asset reference

The Sort criteria 2 and 3 have to be chosen among the values contained in the local menu 3265; it can come, for example, from the Financial site, from the Geographic site, from the Accounting code, from the CoA account or IAS/IFRS, from the Family, from an Analytical distribution key, from an Analytical dimension type, from anIFRS segment, from a TGU.

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
    - Current financial year of the context start and end dates Accounting and fiscal
    Current period of the context start and end dates Accounting and fiscal (displayed only if this is a periodical situation).
  • Detailed report
     
    This report displays 3 lines per fixed asset selected.
     
    On the first line: Asset identification

Information

Loaded from the headings

Table

Reference

AASREF

DEP

Description 1

AASDES1

FAS

Account

ACC or IASACC

FAS

Issue date

ISSDAT

FAS

On the 2nd line: values of the fiscal plan
On the 3rd line: values of the Chart of accounts

Information

Loaded from the headings

Table

Depreciation start date

STRDPRDAT

DEP (Fiscal) DEP_1 (Accounting)

Depreciation end date

ENDDPRDAT

DEP (Fiscal) DEP_1 (Accounting)

Depreciation method

DPM

DEP (Fiscal) DEP_1 (Accounting)

Depreciation duration

DPRDUR

DEP (Fiscal) DEP_1 (Accounting)

Depreciation rate

DPRRAT

DEP (Fiscal) DEP_1 (Accounting)

Balance sheet value

DPRBAS

DEP (Fiscal) DEP_1 (Accounting)

Aggregation of the depreciation at the start of the financial year
or
Aggregation of the depreciation at the start of the period

DPRCUM
or
DPRCUM + PERCLOCUM



DEP (Fiscal) DEP_1 (Accounting)

Financial year depreciation expense
or                                      
Period depreciation expense     

ENDDPE + EXCDPR
or
PERENDDPE + EXCDPR 


DEP (Fiscal) DEP_1 (Accounting)

Line 2:

Financial year start reintegrated balance

LEGCUM - LEGRVECUM

DEP

Reintegrated recovery of the financial year
- if non periodical financial year:
- if periodical financial year:
or
Reintegrated recovery of the period


LEGRVE
LEGRVE + PERLEGRVE
or
LEGRVE

 
DEP

Reintegrated closed periods (if periodical situation asked)

PERLEGCUM - PERLEGRVE

DEP

Line 3:

Reintegrated provision of the financial year
- if non periodical financial year:
- if periodical financial year:
or
Reintegrated provision of the period


LEG
LEG + PERLEGCUM
or
LEG

 
DEP

Recovery on issue*

NBV (DEP_1) – NBV (DEP), if NBV (DEP_1) >= NBV (DEP)

 


Reintegrated balance at the end of the financial year


or
Reintegrated balance at the end of the period

Calculated:
Reintegrated balance at the start of the financial year + Reintegrated provision -- Reintegrated recovery
or
Reintegrated balance at the start of the financial year + Reintegrated closed periods + Reintegrated provision -- Reintegrated recovery

 

*Amount calculated only if the issue is real or if it occurs during the current financial year or period.
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 in classification criteria 2, 3 and Company.
    - 2 lines of general total are also displayed in the last page, if the report concerns several companies.
     
    On the 2nd line: values of the chart of accounts
     
    - Total Balance value
    - Total of the depreciation aggregation of the financial year start or period start
    - Total Depreciation expense of the financial year or period
    - Total reintegration balance of the financial year start
    - Total Reintegrated recovery at the start of the financial year or period
     - Total Reintegration balance of the closed periods (if periodical situation asked)
     
    On the 3rd line: values of the chart of accounts
     
    - Total Balance value
    - Total of the depreciation aggregation of the financial year start or period start
    - Total Depreciation expense of the financial year or period
    - Total Reintegration provision of the financial year or period
    - Total Recovery on issue
     - Total Reintegration balance of the financial year or period

Grids concerned

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

Table

Table description

ADOVAL [ADW]

Parameter values

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