Configuration guidelines for ‘VAT Report Template. Open’ (TXS005, TXS009, TXS006, TXS007, TXS004)

Configuration guidelines for ‘VAT Report Template. Open’ (TXS005/E)

Before the online VAT report can be created, you must define report templates in ‘VAT Report Template. Open’ (TXS005):

  • You must define separate templates for sales invoices (DTE) and for purchase invoices (DTR).
  • You must define separate templates for the Spesometro and Esterometro reports.

In ‘VAT Report Template. Open’ (TXS005/E), specify this information:

Field Value
Report template

For the Spesometro report:

  • For example, SPE17DTE for sales invoices
  • For example, SPE17DTR for purchase invoices

For the Esterometro report:

  • For example, EST19DTE for sales invoices
  • For example, EST19DTR for purchase invoices
Description

Name

For the Spesometro report:

  • For example, Spesometro Sales (DTE) for sales invoices
  • For example, Spesometro Purchases (DTR) for purchase invoices

For the Esterometro report:

  • For example, Esterometro Sales (DTE) for sales invoices
  • For example, Esterometro Purchases (DTR) for purchase invoices

Configuration guidelines for ‘VAT Report Template. Connect Line Selection’ (TXS009)

Because domestic invoices must be excluded from the Esterometro report, you must define an exception for these invoices:

Field Exception from Exception to
From/To country IT IT

Configuration guidelines for ‘VAT Report Template. Connect Columns’ (TXS006)

You must define the columns of the VAT report template exactly as described in this section. Otherwise, the nodes cannot be populated in the online VAT report file in XML format using the FBM mapping.

For the invoice report template for sales and purchases, specify this information:

Report column Description Column heading Value type Column present Reverse sign
1 Base amount Base amount 1 1 Cleared
2 VAT account type 1-VAT payable VAT account type 1 1 1 Cleared
3 VAT account type 2-VAT receivable VAT account type 2 1 1 Cleared

Configuration guidelines for ‘VAT Report Template. Connect Col Select' (TXS007)

For the invoices report template for sales and purchases, specify this information:

Report column Column selection Description VAT code VAT account type Deductible VAT From Deductible VAT To
1 1 Invoice net amount To 99 From 3-Revenue account to 9-User defined Cleared Cleared
2 1 VAT account type 1-VAT payable To 99 From 1-VAT payable to 1-VAT payable Cleared Selected
3 1 VAT account type 2-VAT receivable To 99 From 2-VAT receivable to 2-VAT receivable Cleared Selected

Depending on whether you select the Deductible VAT – To check box or not, you must define one of these two alternative setups, but you cannot mix them:

  • If you select the Deductible VAT – To check box, then you must specify the VAT codes for deductible VAT in (TXS035) using fields 840-870.

    Therefore, the non-deductible VAT amount is included in the selection and displayed in ‘VAT Run. Open User-Defined Lines’ (TXS118). The VAT amount that is reported in the XML file is calculated using the VAT base amount multiplied by the VAT rate.

  • If you clear the Deductible VAT – To check box, then do not specify the VAT codes for deductible VAT in (TXS035). Fields 840-870 must not exist in (TXS035).

    Therefore, the non-deductible VAT amount is not included in the selection, but displayed in (TXS118). The VAT amount reported in the XML file is as displayed in (TXS118).

Configuration guidelines for ‘VAT Report Template. Connect User-Defined Report Template’ (TXS004)

The VAT report template must be defined exactly as described in this section. Otherwise, the XML elements cannot be populated in the online VAT report file using the FBM mapping.

For key fields, specify this information:

Field sequence number Field
10 VTCONO
20 VTDIVI
30 VTVRTM
40 &CVOP
50 &INYR
60 &SINO
70 &YVRN
80 &CUSP
90 &VTCD

For numeric fields, specify this information:

Field sequence number Field
10 &VTP1
20 &VTP2
30 &INYR
40 &OINY
50 &VONO

For alphabetic fields, which are displayed in the Alpha field section, specify this information:

Field sequence number Field
10 &SIN2
20 &OCIN
30 &CSNM
40 &FTCO
50 &VSER

For date fields, specify this information:

Field sequence number Field
10 &IVDT
20 &VATD
30 &ACDT
40 &DEDA