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