Reports > Module Fixed Assets > Report DEPSIMU (Depreciation plan simulation) 

This report shows the depreciation plan of each selected asset. It is possible to obtain:

- either the fiscal year depreciation plan for the specified number of years,
- either the periodic depreciation plan concerning the current and next fiscal years.

The assets are presented, sorted by company, financial site and accounting code with a sub-aggregation to each shortage on one of these criteria.

It is also possible to obtain a synthetic report showing only the sub-aggregations by accounting code, financial site and company.

A global 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

horizon

Number of years

C

encours

In progress (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

1/ Entering values for the selection setups is not mandatory. The default values displayed are those entered in the Report dictionary.
When values are entered, any existence control is carried out. In the case where they are inexistent or inconsistent, any print is carried out.

2/ the default value of the Number of years setup corresponds to the value allocated to the NBEXESTO general setup: Number of fiscal years to store, defined in the Folder. This setup is only used for a Fiscal year simulation. For a periodic simulation, only the current and next fiscal years are displayed.

Description of the report

Implicit Selection:

The Inactive fixed assets are automatically excluded.

Note: when an asset has been the object of a provisional issue, the later fiscal years in which there is the issue date are not displayed.

Grouping/sorting criteria and aggregation

The assets are presented, grouped and sorted in ascending order according to the following criteria:

- Company                                  Aggregation by company with page break
- Financial site                      Aggregation by financial site with page break
- Accounting code                 Aggregation by accounting code without page break
- Fixed asset reference

Restored information

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

  • Header
     
    The header recalls the following information:

     - Company reference
    - Current fiscal year start and end date of the selected plan.
     - Selected period start and end date of the current selected plan (displayed only if it is a periodic simulation).
     
  • Detailed report
     
    This report shows, for each fixed asset, a line containing the asset's identification and also the characteristics of the selected depreciation plan, and then a line per fiscal year or period required.

On the 1st line:

Information

Loaded from the fields

Table

Reference

AASREF

FAS

Description 1

AASDES1

FAS

Detention type

OWNTYP

FAS

Depreciation start date

STRDPRDAT

DEP

Depreciation end date

ENDDPRDAT

DEP

Issue date

ISSDAT

FAS

Depreciation method

DPM

DEP

Depreciation duration

DPRDUR

DEP

Depreciation rate

DPRRAT

DEP

Residual value

RSDVAL

DEP

Following lines:

Information

Loaded from the fields

Table

Fiscal year end date (if fiscal year Situation required)
or
Period end date (if Period situation required)

FIYENDDAT
or
PERENDDAT

 

DEP

Balance sheet value

DPRBAS

DEP

Fiscal year start total depreciation
or
Period start total depreciation                     (1)

DPRCUM
or
DPRCUM + PERCLOCUM – PERCLOEXC                              

 

DEP

Fiscal year depreciation expense
or
Period depreciation expense

ENDDPE + EXCDPR
or
PERENDDPE + (EXCDPR if last fiscal year)

 
DEP

Total end of fiscal year
or
Total end of period       (2)

DPRCUM + ENDDPE       
or
(1) + PERENDDPE

 
DEP

End of fiscal year or period net value

DPRBAS – (2)

DEP

Then, are displayed the aggregation lines identical to those displayed below for a synthesis report.

  • Synthesis report
     
    This report displays:
     
    - 1 aggregation line per fiscal year or period with shortage on Accounting code, financial site and Company.
    - 1 line of general total is also displayed in the last page, if the report concerns several companies.
     
    These lines display the following aggregations:
     
    - Total balance sheet value
    - Total depreciation fiscal year or period start
    - Fiscal year depreciation expense or Period depreciation expense
    - Total fiscal year or period end
    - End of fiscal year or period net value

Tables concerned

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

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