HDTN-271417 - User not able to save LS. It is showing already exists message.

Issue No: LG-3266
Created 3/23/2022 6:21:42 AM
Type Bug
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 20.1
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-271417 - User not able to save LS. It is showing already exists message.|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-271417]   _Precondition: The next Starting Number of Load Schedule should be the same as the last Load Number (ex. if starting number is 1234, the last load number should be LS-1234)_   _You can use this query to update directly through SQL (change the number accordingly):_   _{color:fuchsia}UPDATE{color} tblSMStartingNumber {color:blue}SET{color} intNumber {color:gray}={color} 1234 {color:blue}WHERE{color} strTransactionType {color:gray}={color}{color:red}'Load Schedule'{color}_   *Steps:*   1. Create purchase contract   2. Create Shipment using the Purchase Contract   3. Save.   *Issue:*   Error message appears "\{0\} already exists!".   *Acceptance:*   LS should save without error.     _original report:_   Reported by logistics team very frequently after 16th March upgrade. Refer attached screenshot.