List of accounting assets

Prerequisite

Access to the report

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

It is also called by default from the following functions :

  Fixed assets > Fixed assets > Assets

List of criteria

Parameter	Parameter title	Type
cpydeb	Company limit	CPY
fcydeb	Financial site range	FCY
typdetdeb	Holding type (Local menu Owned, Rented, Leased, Provisional, Concession...)	M3171
ccptdeb	Accounting code range	CAC
accdeb	General account ranges	GAC
accifrsdeb	IFRS" account range	GAC
axe	Analytical dimension type	DIE
secdeb	Dimension range	CCE
acggrpdeb	Family range	FAM
bprdeb	Supplier range	BPR
actdeb	Activity code range	ADI
ugtdeb	UGT range	ADI
plndeb	Invest projets range	ADI
buddeb	Invest budgets range	ADI
datcptdeb	Allocation date range	D4
datmesdeb	Update date range	D4
datsordeb	Disposal date range	D4
refdeb	Asset range	AAS
actif	Active assets (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

The value entry for the selection parameters is optional. The default values displayed are those entered at the level of the Report dictionary.

When the values are entered, no existence control is carried out. In the case where they do not exist or are not consistent, no edition occurs.

Description of the report

Grouping criteria/classification and aggregation

The assets are displayed grouped and classified by ascending order according to the following criteria:

- Company                             Aggregation per company with page break
- Financial site                      Aggregation per financial site with page break
- Accounting code                 Aggregation per accounting code without page break
- Main asset reference  
- Asset reference                  

Recovered information

The report content varies according to the value entered for the setup: Report detailed per asset (or synthesis report).

• Header 
   
  The header recalls the following information:
  
  - Company reference
  - Financial site reference
   
• Detailed report 
  
  This report displays 2 lines per fixed asset selected.
   
  On the first line:
   

Information	Loaded from the headings	Table
Reference	AASREF	FAS
Description 1	AASDES1	FAS
Purchase date	PURDAT	FAS
First use date	ITSDAT	FAS
Group	ACGGRP	FAS
CoA account	GAC	FAS
CoA entered value:	ACGETRNOT	FAS
CoA invoiced VAT amount	IVCVATAMT	FAS
CoA recovered VAT amount	DEDVATAMT	FAS
CoA Depreciation basis	DPRBAS	DEP
CoA management currency	ACGCUR	FAS

- On the 2nd line:

Information	Loaded from the headings	Table
Holding type	OWNTYP	FAS
Posting date	AASIPTDAT	FAS
Issue date	ISSDAT	FAS
Accounting code	ACCCOD	FAS
IFRS account	IASACC	FAS
IFRS entered value	IASETRNOT	FAS
IFRS invoiced VAT amount	IVCVATAMTI	FAS
IFRS recovered VAT amount	DEDVATAMTI	FAS
IFRS Depreciation basis	DPRBAS	DEP_1
IFRS management currency	IASCUR	FAS

The report then displays the aggregation lines identical to those displayed below for a synthesis report.

•  Synthesis report 
  
  This report displays:
   
  - 2 aggregation lines per 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:
   
  - CoA ex-tax Total Entered value
  - Total amount of the CoA invoiced VAT
  -Total amount of the CoA recovered VAT
  -Total Depreciation basis of the chart of accounts
  -Currency
  
  On the 2nd line:
  
  - IFRS Ex-tax Total of the value entered
  -Total amount of IFRS invoiced VAT
  - Total amount of IFRS recovered VAT
  -Total depreciation basis of the IAS/IFRS plan
  -Currency

Grids concerned

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

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