Leasing commitments

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
soc	Company	CPY
type	Contract type (Local menu Lease , Long term rent, Rent)	M3224
contexte	FY type (Local menu Finance, Context 2, Context 3, Context 4...)	M3100
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/ For the Context setup: Fiscal year type, only the choice of the Accounting and Financial context or the IAS/IFRS context is authorized.

2/ The Comment setup: 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 setups 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

Description of the report

Implicit Selection:

Are selected only the lease contracts:
 
- From the On hold status with an end of contract date higher than the start of fiscal year date.
- 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
  - Current fiscal year start and end date of the selected plan.
  - Current fiscal year start and end date of the selected plan.
  - Start date of the N+2 fiscal year and end date of N+5 fiscal year
  - The start date for the N+6 fiscal year.

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

Information		Rule
Fees paid	Of the fiscal year	Total amount of paid fees in the current fiscal year of the selected context.
	Accumulated	Total of the amounts of the paid fees from the contracts start date to the selected context current fiscal year end date.
Fees remaining to be paid	Up to 1 year (1)	Total of the amounts of fees remaining to be paid for the due dates contained between the next fiscal year start date (N+1) and the next fiscal year end date.
	+ 1 year to 5 years (2)	Total of the amounts of fees remaining to be paid for the due dates contained between the N+2 fiscal year start date and the N+5 fiscal year end date.
	+ 5 years (3)	Total of the amounts of fees remaining to be paid for the due date higher than the N+6 fiscal year start date.
Total to pay		Total of the fees remaining to be paid: (1) +(2) +(3)
Residual purchase price		Total of the contract buyback values still active by the end of the of the current fiscal year of the selected context.

Tables concerned

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

Table	Table description
AFCTFCY [AFF]	Site profile function
COMPANY [CPY]	Company
CONTEXT [CNX]	Contexts
FISCYEAR [FIS]	Fiscal year
LEABILBOOK [LBB]	Lease contract schedules
LEASE [LEA]	Lease contracts