Load / Shipment Schedule - While saving LS getting error message

Issue No: LG-3147
Created 11/28/2021 7:12:42 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 21.2
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-267116 - LS creation error|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-267116]   _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:_   JDE customer has reported the below issue in their Live environment while doing their Happy flow testing after it was upgraded to 21.2v     Unfortunately I am not able to create an LS for the POs I have tested:   5900069058   5900066571   5000023137   Please see below the error popping out:   !pastedImage_d174932_0.jpeg|height=391,width=562!     *Work-around:* Increment "Load/Shipment Schedule" Starting Number