HDTN-220791 - Import volume created duplicate records - Add Unique Key Constraint

Issue No: PAT-991
Created 11/23/2018 6:19:23 PM
Type Bug
Priority Major
Status Closed
Resolution Fixed
Fixed Version 18.3
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-220791 - Entered Credit Memo - looks like it is add to volumes instead of Subtracting|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-220791]   Importing volume created duplicate records for customer, fiscal year and Patronage category. Because of these transactions are adding volume multiple times.     From PAT989:   _When importing volume from excel, it should update if the customer has volume for the fiscal year and patronage category instead of inserting another record. Unique key constraint should be included in the table._