Reports > Module Fixed Assets > Report DEPREEVAL (Plan revaluation) 

This report reproduces the revaluations carried out during the fiscal year or during the current period of a given depreciation plan.

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

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

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

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

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.

Description of the report

Implicit Selection:

Are automatically excluded:

- The fixed assets non revaluated in the fiscal year or the period (according to the entered value for the selection setup: Fiscal year situation or Period).
- The fixed assets which depreciation start date is higher than the fiscal year or the selected period end date (according to the value entered for the selection criteria: Fiscal year situation or Period).
- The Inactive fixed assets.

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
- 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.
     - Current fiscal year start and end date of the selected plan (displayed only if a periodic situation is required).
  • Detailed report
     
    This report displays 2 lines by selected fixed asset.

     On the 1st line:

Information

Loaded from the fields

Table

Reference

AASREF

FAS

Description 1

AASDES1

FAS

Depreciation start date

STRDPRDAT

DEP

Account

IASACC

FAS

Initial balance sheet value

BSEVAL

DEP

Revaluation coefficient

RVACOE

DEP

Revaluated balance sheet value

DPRBAS

DEP

Period revaluation

RVAAMT

DEP

On the 2nd line:

Information

Loaded from the fields

Table

Appraiser

RVAAPR

FAS

Revaluation date

RVADAT

DEP

Revaluation reserve

RVADEV

DEP

Market value

NSPVAL

DEP

Revaluated net value

NBV

DEP

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

  • Synthesis report

    This report displays:
     
    - 2 aggregation lines by shortage on Accounting code, Financial site and Company.
    - 2 lines of general total are also displayed in the last page, if the report concerns several companies.
     
    On the 1st line:

    - Total initial balance sheet value
    - Total balance sheet revaluated
    -Total revaluation

    On the 2nd line:

    -Total reserve revaluation
    - Total market value
    - Total revaluated net value

Tables concerned

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

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