Payments Journal ReceiptEngine.performSetBasedInsertToTenderCashAccounts duplicate key while posting

Posting a reversal batch in Payments Journal and receiving an error

• ReceiptEngine.performSetBasedInsertToTenderCashAccounts

• EXECUTE performSetBasedInsertToTenderCashAccounts FAILED

• Violation of UNIQUE KEY constraint UQ_AccountsReceivable.TenderCashAccounts.TenderId.GeneralLedgerAccountId.ReceiptInstLineAmountId. Cannot insert duplicate key in object AccountsReceivable.TenderCashAccounts

• CALL TO BatchEngine.dropJournalAccountTempTables FAILED

• Accounts Receivable

• Payments Journal

• Payment Reversals

When utilizing the RVA (Reversal Batch Approval) workflow, approvers are going into the program and releasing the batch instead of approving first. 

Users should attempt to approve the pending action for the reversal batch if possible. If errors are encountered, please contact Enterprise ERP (Munis) Support

Error may present itself as CALL TO BatchEngine.dropJournalAccountTempTables FAILED in Payments Journal when posting batch, reviewing system log will provide more in depth error

[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 (XXXXXX, XXXXXX, XXXXXX) where the