Account Merge - Duplicate key value on dbo.Checks
Description of Issue
Error received when merging GL accounts:
Munis (glacctmr)
Errors have occurred, please contact
Munis Financial Support with this information. -268 [ISAM -2601]
Additional information concerning a status error of -268:
[Microsoft][SQL Server]Cannot insert duplicate key row in object 'dbo.Checks' with unique index 'IX.Checks'. The duplicate key value is (XXXX, XXXX).
If you have a questions, please contact Munis Technical Support.
System log Id: XXXX
Context
Account Merge
Cause
Same check number was by the Original and Target accounts.
Resolution
Purged one of the checks since it was REPRINT VOID and was not needed, but when account merge was reprocessed, error occurred for dbo.CheckRuns. See: Account Merge Error - Conflict on dbo.CheckRuns
- MUN-402561 is open with Development to address errors occurring against Accounts Payable tables when merging accounts.Â
- This error would typically be specific to balance sheet accounts.
Additional Information
- In error Duplicate Key value numbers represent (AccountId, Check#)
- Checks must be cleared before they can be purged. AP checks are cleared here: Financials > Accounts Payable > Cash Disbursements > Check Reconciliation
- Also see :Â 'Errors have occurred, please contact MUNIS Financial Support' when Merging Accounts