Description of Issue
Users are trying to Output and Release a Payment Entry batch, but receive the error message of [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of UNIQUE KEY
constraint 'UQ_AccountsReceivable.TenderCashAccounts.TenderId.GeneralLedgerAccountId.ReceiptInstLineAmountId'.
Cannot insert duplicate key in object 'AccountsReceivable.TenderCashAccounts'. The duplicate key value is.
Context
- UBCIS
- Payment Entry
- Lockbox
Cause
A receipt was not able to complete due to connection with the server and or Munis and will need to either be completed or canceled and voided.
Resolution
Navigate to Property Revenues > Payment Processing > Payment Entry
- Click Search and type in Batch Number
- Click View-Rec
- Filter the Complete? column so receipts with N are at the top
- Click Accept
- Click the Complete Transaction, if this does not work, click Cancel Transaction
- Repeat process depending on how many receipts were not complete
- Click Back
- Click Output-Rel
Additional Information
Add Comment