Reports > Module Fixed Assets > Report LEARNTDPR (Fees and depreciations) 

This report displays the distribution by balance sheet line, for the indicated fiscal year, the total at the fiscal year end:

- fees to be paid for the lease contracts subscribed by the company,
- depreciations posted on the selected plan for the assets attached to these contracts.

It also displays, for each balance sheet line, the original value of the assets attached to the contracts.

Prerequisite

Access to the report

This report can be accessed from the report menu of the group Fixed Assets - Funding.

List of criteria

Parameter

Parameter title

Type

cpydeb

Company limit

CPY

plan

Depreciation plan (Local menu Accounts, Finance, Minimum, Source, Reevaluation 76...)

M3101

datdeb

Date range

D4

comment

Comment

DCO

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 GESLEA (Lease contracts).

Miscellaneous

1/ The date ranges are used to calculate the information related to the contract. They are also used to determine the fiscal year to take into account for the display of depreciations of assets attached to the contracts. The date ranges must thus be coherent with the breakdown of fiscal years from the chosen plan.

2/ The Comment parameter: Comment is used to enter a free text of a maximum length of 60 characters. This text appears in page 2 of the report.

3/ Entering values for the parameters is not mandatory. The values displayed by default 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.

Report description

Implicit Selection:

Are selected only the lease contracts:

- From the On hold status with an end of contract date higher than the start date of the fiscal year defined by the date ranges.
- From the Buyback, status, with a purchase option removal date higher than the fiscal year start date and lower or equal to the fiscal year end date. In that case, only the due dates situated in the [fiscal year start date; purchase option removal date] interval are taken into account.
- From the Terminated status, with a termination date higher than the fiscal year start date and lower or equal to the fiscal year end date. In that case, only the due dates situated in the [fiscal year start date; termination date] interval are taken into account.
- From the Complete status, with a termination date higher than the fiscal year start date and lower or equal to the fiscal year end date. In that case, only the due dates situated in the [fiscal year start date; end of contract date] interval are taken into account.

Grouping/sorting criteria and aggregation

The amounts of fees paid are accumulated by Balance sheet line with a sub-total by nature (Fixed assets/Movable assets), and also a general total.

Restored information
  • Header
     
    The header recalls the following information:

    - Company reference
    - Start and end dates entered.

Are displayed on each balance sheet line, the following amounts:

Information

Rule

Original value

Sum of the ex. tax entry values of assets assigned to the selected contracts.

Contracts (1)
Fees paid

of the fiscal year

Total amount of paid fees in the selected fiscal year.

accumulated

Total of the amounts of the fees paid from the contracts start date to the selected fiscal year end date.

Contracts (1)
Financial
depreciations


of the fiscal year

Total amount of the financial depreciation on the fiscal year.

accumulated

Total of the financial depreciation from the contracts start date to the selected fiscal year end date.

Contracts (1)
Financial costs

of the fiscal year

Total amount of financial costs in the selected fiscal year.

accumulated

Total of the financial costs from the contracts start date to the selected fiscal year end date.

Contracts (1)
Repaid
capital

of the fiscal year

Total amount of the repaid capital in the selected fiscal year.

accumulated

Total of the amounts of the repaid capital from the contracts start date to the selected fiscal year end date.


Assets (2)
Depreciations

of the fiscal year

Sum of depreciations of assets attached to the selected contracts, until the fiscal year end date on the chosen plan.

accumulated

Total of depreciations of assets attached to the selected contracts, until the fiscal year end date.

  
(1) These amounts are calculated from the "Schedule" tab of the Lease contract function.
(2) These amounts are calculated from the assets attached to the contracts.

Tables concerned

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

Table

Table description

AFCTFCY [AFF]

Site profile function

COMPANY [CPY]

Company

CONTEXT [CNX]

Contexts

DEPREC [DEP]

Charge

FISCYEAR [FIS]

Fiscal year

FXDASSETS [FAS]

Assets

LEABILBOOK [LBB]

Lease contract schedules

LEASE [LEA]

Lease contracts