Reports > Module Fixed Assets > Report VATREGHIS (VAT adjustment history) 

This multi-site and multi-company report displays, for a given depreciation plan, the history of VAT adjustments carried out on a selection of assets.

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