Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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-Rec
  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






  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.