Cannot insert duplicate key row in object 'dbo.artrnsdt' with unique index Error In Transfer Of Overpayments

Description of Issue
  • Error creating transfer
  • The duplicate key value is (X, XXXX, XXXXX, X)
  • Additional information concerning a status error of -268 [-2601]
Context

Error encountered when trying to transfer an overpayment from an overpaid bill to a subsequent bill will a balance due

Cause

Transfer of Overpayments record has no header, only detail lines

Resolution

Create a case with the support team associated with the bill category (i.e. EERP General Billing & Misc Cash for category 1, EERP Utility Billing for category 60, EERP Tax for category 20, EERP Civic Services for category 55)

Additional Information