Overview:

Steps to Reproduce:

Case 1

1. Create an invoice

2. Add 2 invoice-level adjustments using the same fund and expense class, but different amounts (not prorated)

3. Approve and pay the invoice

4. Cancel the invoice

Case 2

1. Create an invoice

2. Add 2 invoice-level adjustments using the same fund and expense class, and the same amounts (not prorated)

3. Try to approve the invoice

Expected Results:

The invoice is cancelled (case 1) or approved (case 2).

Actual Results:

An error occurs: duplicate key value violates unique constraint "transaction_payment_idx_unique"

Additional Information:
When the invoice is cancelled, the records end up with the same amount and this creates a conflict with the unique key

Interested parties: