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.
Before you run the Update VAT Transaction Data report, you should activate the change log on the Change Log Setup page. Also, you should enable logging for modifications to the Include in VAT Transac. Report field on the VAT Entry table.
To update VAT transaction data
Choose the icon, 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, Business Central 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. Warning: Do 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 Trans. Report to Yes on all VAT entries where the amounts meet the threshold amounts that are specified in the VAT posting setup. Warning: If 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, Business Central 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.