icon, enter VAT Entries, and then choose the related link.This topic describes the reports in Dynamics NAV that you can use to submit information about value-added tax (VAT) amounts for sales and purchases to tax authorities in your region.
You can use the following reports :
If you want to view a complete history of VAT entries, every posting that involves VAT creates an entry on the VAT Entries page. These entries are used to calculate your VAT settlement amount, such as your payment and refund, for a specific period. To view VAT entries, choose the icon, enter VAT Entries, and then choose the related link.
In the EU, all companies that sell goods and services to VAT-registered customers, including customers in other European Union (EU) countries, must submit an electronic version of the European Community (EC) Sales List report in XML format through their local tax authority's website, for example in UK, Her Majesty's Revenue and Customs (HMRC). The EC Sales List report works only for countries in the EU.
The report includes one line for each type of transaction with the customer, and displays the total amount for each type of transactions. There are three types of transactions that the report can include:
B2B goods and services specify whether you sold a good or a service, and are controlled by the EU Service setting in the VAT posting setup. B2B Triangulated Goods indicate whether you engaged in trade with a 3rd party, and are controlled by the EU 3-Party Trade setting on sales documents, such as sales orders, invoices, credit memos, and so on.
After the tax authority reviews your report, they will send an email to the contact person for your company. In Dynamics NAV, the contact person is specified on the Company Information page. Before you submit the report, make sure that a contact person is chosen.
Use this report to submit VAT for sales and purchase documents, such as purchase and sales orders, invoices, and credit memos. The information in the report is in the same format as on the declaration form from the customs and tax authorities.
VAT is calculated based on the VAT posting setup and the VAT posting groups that you have set up.
For the VAT return, you can specify the entries to include:
Dynamics NAV provides service connections to tax authority websites. For example, if you are in the UK, you can enable the GovTalk service connection to submit the EC Sales List and VAT Return reports electronically. If you want to submit the report manually, for example by entering your data on the tax authority's website, this is not required.
To report VAT to a tax authority electronically, you need to connect Dynamics NAV to the tax authority's web service. This requires that you set up an account with your tax authority. When you have an account, you can enable a service connection that we provide in Dynamics NAV.
icon, enter Service Connections, and then choose appropriate link.Fill in the required fields. Choose a field to read a short description of the field or link to more information.
It's a good idea to test your connection. To do this, choose the Test Mode check box, then prepare and submit your VAT report as described in the To prepare and submit a VAT report section. While in Test Mode, the service tests whether the tax authority can receive your report, and the status of the report will indicate whether the test submission was successful. It's important to remember that this is not an actual submission. To submit the report for real, you must clear the Test Mode check box, and then repeat the submission process.
icon, enter VAT Report Setup, and then choose the related link. icon, enter EC Sales List or VAT Return, and then choose the related link. To generate the content of the report, choose the Suggest Lines action.
For the EC Sales List report, you can review the transactions included in the report lines before you submit the report. To do that, choose the line, and then choose the Show VAT Entries action.
To validate and prepare the report for submission, choose the Release action.
Dynamics NAV validates whether the report is set up correctly. If the validation fails, the errors display under Errors and Warnings so that you know what to fix. Typically, if the message is about a missing setting in Dynamics NAV, you can choose the message to open the page that contains the information to correct.
After you submit the report, Dynamics NAV monitors the service and keeps a record of your communications. The Status field indicates where the report is in the process. For example, when the authorities process your report, the status of the report changes to Succeeded. If the tax authority found mistakes in the report you submitted, the status of the report will be Failed. You can view the errors under Errors and Warnings, correct them, and then submit the report again. To view a list of all your EC Sales List reports, go to the EC Sales List Reports page.
In some countries, you exchange messages with the tax authority when you submit reports. You can view the first and the last message you sent or received by choosing the Download Submission Message and Download Response Message actions.
If you use another method to submit the report, for example by exporting the XML and uploading it to a tax authority website, afterward you can choose Mark as Submitted to close the reporting period. When you mark the report as released, it becomes non-editable. If you must change the report after you mark it as released, you must reopen it.
Periodically, you must remit the net VAT to the tax authorities. If you need to settle VAT frequently, you can run the Calc. and Post VAT Settlement batch job to close the open VAT entries and transfer purchase and sales VAT amounts to the VAT settlement account.
When you transfer VAT amounts to the settlement account, the purchase VAT account is credited, and the sales VAT account is debited with the amounts calculated for the specified period. The net amount is credited or debited, if the purchase VAT amount is larger, to the VAT settlement account. You can post the settlement immediately or print a test report first.
When you use the Calc. and Post VAT Settlement batch job, if you don't specify a VAT Bus. Posting Group and a VAT Prod. Posting group, entries with all business posting groups and product posting group codes are included.
You can use the EC Sales List report out-of-the-box, however, you can also create your own reports. This requires that you create a few codeunits. If you need help with that, contact a Microsoft Partner.
The following table describes the codeunits that you must create for your report.
| Codeunit | What it must do |
|---|---|
| Suggest Lines | Fetch information from the VAT Entries table, and display it in lines on the VAT report. |
| Content | Control the format of the report. For example, whether it is XML or JSON. The format to use depends on the requirements of your tax authority's web service. |
| Submission | Control how, and when, you submit the report based on the requirements of your tax authority. |
| Response Handler | Handle the return from the tax authority. For example, it might send an email message to your company's contact person. |
| Cancel | Send a cancellation of a VAT report that was submitted earlier to your tax authority. |
When you create codeunits for the report, pay attention to the value in the VAT Report Version field. This field must reflect the version of the report that is, or was, required by the tax authority. For example, you might enter 2017 in the field to indicate that the report conforms to the requirements that were in place that year. To find the current version, contact your tax authority.
Setting Up to Calculations and Posting Methods for Value-Added Tax
How to: Work with VAT on Sales and Purchases
Set Up Sales
How to: Invoice Sales
© 2017 Microsoft. All rights reserved.