VAT adjustment history

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
plan	Depreciation plan (Local menu Accounts, Finance, Minimum, Source, Reevaluation 76...)	M3101
datdeb	Date range	D4
refdeb	Asset range	AAS
trisit	Sort by financial site (Local menu No, Yes)	M1
detail	Detail (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

Grouping/sorting criteria and aggregation

The assets are presented, grouped and sorted in ascending order according to the following criteria:

- Company                      page break
- Financial site                      page break
- Asset reference

Restored information

• Header
   
  The header recalls the following information:
  
  - Company reference
  - Date ranges entered as selection criteria.
   
• Detailed report
   
  This report displays for each selected financial asset:
  - a line per event at the origin of an adjustment,
  - an aggregation line

Information	Loaded from the fields	Table
Date of the event	DATVATREG	VAT
Event type:	VATREGTYP	VAT
Ex-tax receipt value	ACGETRNOT	VAT
Invoiced VAT amount	IVCVATAMT	VAT
Collected VAT amount	DEDVATAMT	VAT
Adjustment: Additional deduction/Transfer	VATREGDED – VATREGAMT	VAT
Data base after update	DPRBAS	VAT
Activity sector (VAT)	AASBUS	VAT
Current reference coefficients
Liability coefficient	ASJCOER	VAT
Taxation coefficient	TAXCOER	VAT
Admission coefficient	ADMCOER	VAT
Deduction coefficient	DEDCOER	VAT
Yearly coefficients
Liability coefficient	ASJCOE	VAT
Taxation coefficient	TAXCOE	VAT
Admission coefficient	ADMCOE	VAT
Deduction coefficient	DEDCOE	VAT
Adjustment residual duration	VATRSD	VAT
Period of adjustment duration	THESLI	VAT

Tables concerned

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

Table	Table description
COMPANY [CPY]	Company
FACILITY [FCY]	Sites
FXDASSETS [FAS]	Assets
VATHIS [VAT]	Tax - history