How to: Update VAT Transactions Data
Before you create the first VAT transaction report, you should prepare the existing data by running the Update VAT Transaction Data report. You should also run this report if you have made changes to the setup based on new requirements from the tax authorities.
You can run the Update VAT Transaction Data report as a test before you change any data. When you have verified that the filters meet your expectations and the requirements of the tax authorities, you should run the report again to make the appropriate changes to data.
Warning
Before you run the Update VAT Transaction Data report, you should activate the change log in the Change Log Setup window. Also, you should enable logging for modifications to the Include in VAT Transac. Rep. field on the VAT Entry table.
To update VAT transaction data
In the Search box, enter Update VAT Transaction Data, and then choose the related link.
Optionally, on the VAT Entry FastTab, set the appropriate filters.
On the Options FastTab, fill in the fields as described in the following table.
Field Description Compare Against Threshold
Select to compare VAT entries against the threshold amounts that are specified in the VAT posting setup.
Show List Only
Select if you do not want to update data.
If you select this field, Microsoft Dynamics NAV prints a report so that you can verify the changes before data is modified. The report contains a line for each document where the VAT base is equal to or greater than the threshold amounts.
WarningDo not select both this field and the Set Include in VAT Transaction Report field.Set Include in VAT Transaction Report
Select to set the Include in VAT Transac. Rep. to Yes on all VAT entries where the amounts meet the threshold amounts that are specified in the VAT posting setup.
WarningIf you select this field, your data is updated. You should run the report as a test before you run it to change data.Choose the Print button to update VAT transaction data, or choose the Preview button to view the changes.
When you run the report, Microsoft Dynamics NAV processes VAT entries based on the filters that you set. The following rules are also applied:
The Blacklisted field for the VAT entry must be blank.
The Type field for the VAT entry must not be Settlement.
See Also
Tasks
How to: Prepare for VAT Transactions Reports