VAT return reporting

• VAT form (field VATFRM)

Enter or select the VAT form to filter based on the declaration and legislation defined on the VAT form.

You can then select to filter for VAT boxes related to this declaration and legislation combination.

• Description (field DESTRA)

This field displays information for the selected VAT form and cannot be modified.

• Declaration (field VATFNC)

• Legislation (field LEG)

• Validity start date (field VLYSTRDAT)

This field displays information for the selected VAT form and cannot be modified. This is the date for the form, not the return.

• Validity end date (field VLYENDDAT)

• VAT entity (field CODVATGRP)

Select a VAT entity. The VAT entity selection is limited to those that match the legislation for the VAT form.

• Head member (field VATHEA)

This field displays the head member for the selected VAT entity.

• field HEAFCY

This field displays information for the Head member and cannot be modified.

• Currency (field AMTVATCUR)

• Company tax ID number (field CRN)

• EU VAT no. (field EECNUM)

• Additional tax identifier (field ADLTAXID)

• Start date (field STRDAT)

Enter a date range to filter for declarations within that timeframe.

If there is more than one declaration within that timeframe, the related amounts are combined.

If the date range includes a VAT return that is in simulation mode, an information message displays.

• End date (field ENDDAT)

• VAT on debit (field VATDBT)

Select this checkbox to include VAT on debit.

If the Detail checkbox is also selected, all related information displays in the VAT on debit details grid when you extract.

• VAT on payment (field VATPAY)

Select this checkbox to include VAT on payment.

If the Detail checkbox is also selected, all related information displays in the VAT on payment details grid when you extract.

• Detail (field SHODET)

• Amount type (field AMTTYP)

Select one:

Basis: This is the excluded VAT amount.

Amount: This is the VAT amount.

Both: This is the recommended option.

• From VAT box (field BOXFROM)

Select a VAT box range. The selection list is based on the declaration and legislation combination for the entered VAT form. This is list is not limited to the boxes in the VAT return but includes all Detail VAT box types defined in the VAT boxes setup.

If you do not enter a range, all related VAT boxes are included in the inquiry.

• To VAT box (field BOXTO)

Select a VAT box range. The selection list is based on the declaration and legislation combination for the entered VAT form. This is list is not limited to the boxes in the VAT return but includes all Detail VAT box types defined in the VAT boxes setup.

If you do not enter a range, all related VAT boxes are included in the inquiry.

• Company (field CPY)

This field displays information based on the selection criteria and cannot be modified.

• Company name (field CPYNAM)

• VAT boxes (field VATBOX)

• Description (field DESVATBOX)

• Extracted value (field VATAMT)

This field displays information based on the selection criteria and cannot be modified.

For overlapping declarations, this is the combined value.

• Total amount (field TOTAMT)

This field displays the total amount of the extracted values.

• Currency (field CUR)

This field displays the currency for the extracted values based on the declaration and legislation for the selected VAT form.

• Number of lines (field NOLINES)

The maximum line limit is 5000 and you are warned when you reach 1000 lines. You can manage this using the ENSLB - No. lines EC Sales List activity code.

• Account (field ACC)

This field displays information for the journal entry and cannot be modified.

• Site (field FCY)

• Declared amount (field AMT)

• Entry type (field TYP)

• Document no. (field NUM)

• VAT code (field VAT)

• Tax management (field FLGVAT)

• Tax allocation (field VATIPT)

• VAT rate (field VATRAT)

• Query no. (field NUMRPT)

• Simulation (field SIM)

• Accounting date (field ACCDAT)

• Chart code (field COA)

• Currency (field CUR)

• Company (field CPY)

• Amount type (field TYPAMT)

• Matched control account (field MTCACC)

This field displays information for the journal entry and cannot be modified.

• Matched BP (field BPR)

• Match letter (field MTC)

• Matching date (field MTCDAT)

• Site (field FCY)

• Payment amount (field AMTVCR)

• Base including tax (field ATIVCR)

• Entry type (field TYP)

• Document no. (field NUM)

• VAT code (field VAT)

• Tax management (field FLGVAT)

• Tax allocation (field VATIPT)

• Base before tax (field BASNOTLIN)

• Tax base (field BASVATLIN)

• Declared amount (field AMT)

• VAT rate (field VATRAT)

• Query no. (field NUMRPT)

• Simulation (field SIM)

• Accounting date (field ACCDAT)

• Chart code (field COA)

• Account (field ACC)

• Record type (field TYPREC)

• Currency (field CUR)

• Company (field CPY)

• Journal date (field DATMAX)

• Amount type (field TYPAMT)

This field displays information for the journal entry and cannot be modified.