Depreciation plan simulation

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