Error when merging accounts tied to AP Withholding - Account Merge
Description of Issue
Error occurs when merging accounts
Additional information concerning a status error of -691: [Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK_WithholdingDetail_AccountId_AccountsId".
The conflict occurred in database "munXXXXXXX", table "dbo.WithholdingDetail", column 'AccountId'.
Context
Account Merge
Cause
Error occurs when both accounts contain AP Withholding transactions
Resolution
Work ticket MUN-463713 is open with development to address the issue
There is no workaround at this time
Additional Information