Once Access Connect has been installed, the VAT return feature in Dimensions will be disabled.
The following error message will appear when attempting to run the VAT return in Dimensions:
The application was unable to insert into the table, SYS_TAX_AUDIT, successfully. The error retrieved from the server was :
37000:[Microsoft][SQL Server Native Client 11.0][SQL Server]Because you have a Dimensions integration with Access Digital Tax, you can no longer do VAT returns in dimensions. Please use Access Digital Tax for your VAT returns 37000:[Microsoft][SQL Server Native Client 11.0][SQL Server]The transaction ended in the trigger. The batch has been aborted
This error can be bypassed and a VAT return can be run in Dimensions by following these steps:
Select the System tab.
In the VAT section, select VAT Return, VAT Return.
Click Print icon.
Ensure the correct periods have been selected.
Change the VAT Reference to ADT-<Date>. For example, 'ADT-260419'. 📌 **Note:** The VAT Reference must contain 'ADT-' — this identifies the VAT return and bypasses the error message.