Export VAT Transactions Batch Job
Creates one or more text files in .ccf file format based on a VAT transactions report.
You must submit the generated files to the tax authorities. When you have submitted the files, you must mark the VAT report as submitted. For more information, see How to: Create Electronic VAT Transactions Reports.
Options
Option | Description |
---|---|
File Name |
Specify the name of the file that the list of transactions will be exported to. |
Detailed Export |
Select the check box to export information about transactions in detail. The check box controls whether to export the data in detailed format or in aggregate. If in aggregate, lines are further grouped by VAT registration number or fiscal code. |
Additional Information
The batch job exports VAT report lines for individual documents and lines that are related to contracts, such as blanket orders and service contracts. According to the Italian tax authorities, invoices related to contracts can be exported in two ways:
Export one detail record for each invoice.
In this case, the document number of the invoice is reported.
Export one detail record for each operation type (sales or purchases) for each contract.
In this case, the document number of the contract is reported.
Microsoft Dynamics NAV only supports the export of a detail record for each invoice because this provides more accurate reporting and a clear audit trail
If the VAT transactions report contains more than 1500 lines, Microsoft Dynamics NAV creates more than one file, and each file contains a maximum of 1500 lines. This is caused by the requirements of the Italian Revenue Agency.
For example, if a VAT transactions report consists of 4499 lines, Microsoft Dynamics NAV creates 3 text files that are numbered consecutively. Each file specifies its file number and the total number of files that were exported for the VAT transactions report.
For corrective reports, the exported files include the receipt number from the tax authorities that you specified for the original report.
The exported file contains the following types of records:
Record type | Description |
---|---|
0 |
A header record. These are VAT report lines where the Record Identifier field is set to R0. Fields 12 to 17 are always exported with the default values for the data types. Microsoft Dynamics NAV supports only companies as the reporting party and not individual persons. Field 19 is always exported with the value 0 to indicate that it is a report for a single company. Microsoft Dynamics NAV supports only reporting for one company in each exported file. Field 24 specifies who has prepared the report. If the report is submitted by your own company, the value is 1. If the report is submitted by a tax representative, the value is 2. If the report is submitted by an external party that acts as an intermediary, the value is blank. |
1 |
VAT transactions with subjects without a VAT registration number. These are VAT report lines where the Record Identifier field is set to R1. |
2 |
VAT transactions with subjects with a VAT registration number. These are VAT report lines where the Record Identifier field is set to R2. |
3 |
VAT Transactions with non-residents. These are VAT report lines where the Record Identifier field is set to R3. Field 6 is always exported with the value EE because this record type is used only for reporting VAT transactions with non-residents. |
4 |
VAT transaction corrections with subjects with a VAT registration number. These are VAT report lines where the Record Identifier field is set to R4. Fields 10 and 11 are always exported with the value C for credit because Microsoft Dynamics NAV does not support debit notes. |
5 |
VAT transaction corrections with non-residents. These are VAT report lines where the Record Identifier field is set to R5. Field 6 is always exported with the value EE because this record type is used only for reporting VAT transactions with non-residents. Fields 18 and 19 are always exported with the value C for credit because Microsoft Dynamics NAV does not support debit notes. |
9 |
A footer record. These are VAT report lines where the Record Identifier field is set to R9. Fields 12 to 17 are always exported with the default values for the data types. Microsoft Dynamics NAV supports only companies as the reporting party and not individual persons. Field 19 is always exported with the value 0 to indicate that it is a report for a single company. Microsoft Dynamics NAV supports only reporting for one company in each exported file. Field 24 specifies who has prepared the report. If the report is submitted by your own company, the value is 1. If the report is submitted by a tax representative, the value is 2. If the report is submitted by an external party that acts as an intermediary, the value is blank. |
Tip
For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.
See Also
Tasks
How to: Create Electronic VAT Transactions Reports