Plan Revaluation

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)	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