Duplicate insert duplicate row in object 'dbo.BankDepositReceiptMatches' when matching new receipts that were part of a Deposit with Partial matches completed
- Knowledge Assistant
Owned by Knowledge Assistant
Description of Issue
- Munis deposit receipts are partially matched on day 1. On day 2, additional receipts from the same Deposit are selected to be matched. The match returns an error.
Cannot insert duplicate key row in object 'dbo.BankDepositReceiptMatches' with unique ind ex 'IX_Unique_BankDepositReceiptMatches'. The duplicate key value is (XXXX, XX, XX, XXX, X).
- The Match Details indicate that all of the receipts for the Deposit are selected, not just the day 2 receipts.
Context
- Bank Reconciliation Manager
- Matching
- Deposits
- Receipts
- 2018.1.25
- 2019.1.16
Cause
Deselecting transactions from Partial match prompts the error.
Resolution
- MUN-383800 is currently open with Development to resolve the error that occurs when attempting to complete a match after deselecting then reselecting receipts in a partial Deposit.
- There is no need to deselect the prior Partial match.
- Only one clear date can be set for a Deposit : Deposit transactions consolidating in Bank Reconciliation Manager
Additional Information