Skip to main content

Repost stuck transactions from the temp table and different errors generate

Written by Charnjit Singh Dharival

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.

Or,

Msg 50000, Level 16, State 1, Procedure AA_SYS_RETURN_SQL_ERROR, Line 78 [Batch Start Line 2]

Journal Ref 12345 does not balance


Please start a conversation on the Access Community Portal.How to contact Support via the MyAccess Portal | Access Supply Chain Help Centre


Did this answer your question?