/
Violation of UNIQUE KEY constraint UQ AccountsReceivableTenderCashAccountsTenderIdGeneralLedgerAccountIdReceiptLineAmountId

Violation of UNIQUE KEY constraint UQ AccountsReceivableTenderCashAccountsTenderIdGeneralLedgerAccountIdReceiptLineAmountId

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 

  1. Click Search and type in Batch Number 

  2. Click View-Rev

  3. Filter the Complete? column so receipts with N are at the top

  4. Click Accept 

  5. Click the Complete Transaction, if this does not work, click Cancel Transaction 

  6. Repeat process depending on how many receipts were not complete 

  7. Click Back 

  8. Click Output-Rel

Additional Information










Related content

Payments Journal ReceiptEngine.performSetBasedInsertToTenderCashAccounts duplicate key while posting
Payments Journal ReceiptEngine.performSetBasedInsertToTenderCashAccounts duplicate key while posting
More like this
Cannot Release Tyler Payments Batch From Enterprise ERP Payment Entry
Cannot Release Tyler Payments Batch From Enterprise ERP Payment Entry
More like this
An exception has occurred within MiscellaneousPaymentInterface error when entering a Miscellaneous Receipt against a Contract
An exception has occurred within MiscellaneousPaymentInterface error when entering a Miscellaneous Receipt against a Contract
More like this
An exception has occurred within MiscellaneousPaymentInterface
An exception has occurred within MiscellaneousPaymentInterface
More like this
Invoice Entry and Proof Error Creating Bill
Invoice Entry and Proof Error Creating Bill
More like this
Transfer of Overpayment error inserting detail record
Transfer of Overpayment error inserting detail record
More like this