Skip to main content

Transactions stuck in temp table

For help when transactions are stuck in the temp table.

Written by Emma
Updated today

Overview

There are some transactions stuck in the temp table. When we try to process these through, the below error appears:
​Msg 50000, Level 16, State 1, Procedure AA_SYS_RETURN_SQL_ERROR, Line (x) Without a VAT registration number the Tax code must be of EU type T or U, or Tax code 8 for an EU Customer. Msg 50000, Level 16, State 1, Procedure AA_SYS_RETURN_SQL_ERROR, Line (x) Execution of procedure AA_SLTRN_CHECK_ANALYSIS_S has failed Msg 3609, Level 16, State 1, Line (x) The transaction ended in the trigger. The batch has been aborted.
​
The VAT registration number exists on the customer code for the transactions that are stuck.


Need further help?

Please contact support, and please include any errors you may be seeing, as well as examples of transactions thay may be stuck. We will be happy to help.

Did this answer your question?