Payments Journal ReceiptEngine.performSetBasedInsertToTenderCashAccounts duplicate key while posting

Owned by Knowledge Assistant
Dec 04, 2023
1 min read



Description of Issue

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



Context

  • Accounts Receivable

  • Payments Journal

  • Payment Reversals



Cause

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



Resolution

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



Additional Information

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Â