Reports > Module Financials > Report DCLEECVATBEL2 (EU VAT statement reprint) 

Report available from Update 8.0.0

The EU VAT statement preparatory report can be reprinted.

Prerequisites

List of criteria

Parameter

Parameter title

Type

numrpt

Query number

L

impselections

Print selections (Local menu No, Yes)

M1

Report description

Each part of the report contains the following information:

Header

  • The query number
  • The company code
  • The currency
  • The frequency of the declaration (month, quarter or year) and the corresponding dates

'Entry detail' part

  • The information is sorted by customer (with the customer code and company name) and EU VAT number. For each EU VAT number/customer combination, the extracted invoice lines are displayed.
  • The invoices are then sorted by ascending operation code (L then S), invoice number and tax rate.

SEEINFO The operation code 'L' stands for 'EU deliveries of goods'. This code corresponds to accounts with a tax allocation of 'Collected sales', 'Collected fixed assets' or 'Adjustment for company' types.

The operation code 'S' stands for 'EU service provisions'. This code corresponds to accounts with a tax allocation of 'Collected services' type.

  • The tax excluded turnover amount is displayed in the Turnover ex tax column.

'Summary' part

  • The total tax excluded turnover amounts are displayed in the Turnover ex tax column. These amounts are sorted by company, query number, customer code, EU VAT number and operation code.
  • The BP company name displayed in this part is dependent on the BP type (normal customer of miscellaneous BP).
    • For the Sales module invoices:
      • For a normal customer, the company name originates from the BP record.
      • For the miscellaneous customer, the company name originates from the document.
    • For the A-P/A-R module invoices, the company name always originates from the BP record.

      For a BP/EU VAT number combination, and a miscellaneous customer with several invoices (sales invoices only, or BP invoices only, or sales and BP invoices) the first invoice read determines the company name.