To resolve the immediate issue to get Dimensions force-updated with the VAT return which successfully submitted through to HMRC, please refer to one of the articles.
Access Digital Tax: How to submit a VAT Return in Dimensions after installing Access Connect
Access Digital Tax: How to submit your VAT Return in Dimensions following the install of Access Connect
Dimensions: VAT Return error: 'The application was unable to insert into the table, SYS_TAX_AUDIT, successfully.'
Access Digital Tax: Submitting a VAT Return in Dimensions following the install of Access Connect
Note: Ensure that you choose the period range appropriate to the obligation date, and confirm the figures match up before proceeding in force-updating.
Please refer to the below to troubleshoot and resolve the error so that it does not re-occur on the next submission.
There are multiple factors that can cause this.
Duplicate records in the ACP user records table in the sql database
An incorrect licence that lacks the required modules for Access Digital Tax to update Dimensions.
The connect service on the server is not running with a sufficient admin account
The connect service may be an older version which was found to have difficultly in updating large databases
There is a high network traffic, low connectivity or a restricted network
ADT may still be syncing to Dimensions to "get the figures", however may not be correctly syncing to perform the update into Dimensions - this can be classified as a "partial incomplete synchronisation". For assistance with Syncing Dimensions to Workspace, you can refer to article Access Digital Tax: Synchronise a Dimension User to Access Workspace to use Access Digital Tax
There may be an issue on the back-end of Access Workspace with the Link between ADT and Access Financials
The user submitting the VAT return within Digital Tax needs to have full permissions to the System area of Dimensions / Financials
The workspace organisation would need to ensure to only have 1 set of relay keys which match up to the ones used with the Access Connect
The user record of the ADT user within Dimensions should be marked as a workspace user
The ADT user must be a Workspace Organisation Administrator
To investigate which of these is causing the issue, our support team will need to investigate, run scripts or liaise with the hosting or development teams. Any Issues with contacting us, please see the following Get support in Access Digital Tax.