HDTN-269804 - Unable to import the load shipment if contract has multiple sequence for a contract.

Issue No: LG-3198
Created 2/6/2022 7:04:14 PM
Type Bug
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 21.2
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-269804 - Unable to import the load shipment if contract has multiple sequence for a contract.|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-269804]   *Steps to Reproduce:*   1. Create Purchase Contract with 2 Sequences; The first sequence should have less qty than the second (ex. seq 1 = 20 Qty, seq 2 = 120 Qty).   2. Create Import file for creating LS for the 2nd contract sequence only. Make the Qty more than the qty of the 1st sequence (ex. 60)   3. Import the file using Import Load   *Issue:*   Import function is trying to create load for Sequence 1 and not Sequence 2   *Acceptance:*   Import function should follow the contract sequence specified on the import file       _original report:_   Pre condition   contract should have multiple sequences.   Steps   1. Download the attached DB.   [https://irelyftp.blob.core.windows.net/upload/irely01_MotherParkers.zip?sv=2020-08-04&st=2022-02-06T23%3A53%3A11Z&se=2022-02-18T23%3A53%3A00Z&sr=b&sp=r&sig=SqnQFB7ERkdL7py%2FNqQ4wJXE8bzP%2BWp8IVo0QjgUekE%3D]   2. Remove all the load and update schedule qty to zero in the contract detail table     {panel:borderStyle=dashed} {color:blue}delete{color}{color:blue}from{color} tblLGLoad   {color:fuchsia}update{color} tblCTContractDetail {color:blue}set{color} dblScheduleQty {color:gray}={color} 0   {panel}   3. Import load shipment through file[attached here]   Issue   Unable to import it through file.   Expectation   system should import the data.   Note   While processing second sequence, error shows for 1st seq, saying that contract qty is not available.   Version   21.2.0204.300