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 make 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 verify 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.
Achtung
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.
Steps to update VAT transaction data
- [!INCLUDE [open-search](../../includes/open-search.md)], 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 the absolute VAT base with Threshold Amount Excl. VAT. The report uses the threshold with the latest starting date on or before the entry's Operation Occurred Date. Show List Only Select to list the matching entries without changing them. This option disables Set Include in VAT Transaction Report. Set Include in VAT Transaction Report Choose Set Fields to select Include in VAT Transac. Rep. on matching entries, or Clear Fields to clear it. This option applies only when Show List Only is cleared. Select Show List Only, and choose Preview to review the matching entries.
- To apply the changes, run the report again with the same filters. Clear Show List Only, choose Set Fields or Clear Fields, and run the report. Confirm the update when prompted.
Achtung
Show List Only, not the choice between Print and Preview, controls whether the report changes data. Keep Show List Only selected for a test run.
When you run the report, [!INCLUDE[prod_short](../../includes/prod_short.md)] processes VAT entries based on the filters that you set. The following rules are also applied:
The report excludes entries with Type set to Settlement. An entry also needs an applicable threshold record, even when Compare Against Threshold is cleared.