| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-248939 - Inventory Expensive query fix|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-248939]
1. Procedure name: uspICPostInventoryAdjustment
Please use the column 'intInventoryAdjustmentId' instead of strAdjustmentNo to update the table for the highlighted rows
!pastedImage_d141672_0.png|height=307,width=570!
!pastedImage_d141672_1.png|height=300,width=570!
Please add the highlighted condition in the join itself to restrict no of record in the join operation
!pastedImage_d141672_2.jpg!
2. Procedure name uspICCreateLotNumberOnInventoryAdjustmentSplitLot
Adjustment detail has more no of records, we should have a filter by item or you can use only item table to check whether any unit qty below 0. Please review it.
!pastedImage_d141672_3.png|height=356,width=556!
!pastedImage_d141672_4.png|height=214,width=556!
!pastedImage_d141672_5.jpg!
3. Procedure name uspICCreateLotNumberOnInventoryAdjustmentSplitLot
Please add the highlighted condition in the join itself to restrict no of record in the join operation
!pastedImage_d141672_6.png|height=252,width=556!
4. Procedure name uspICPostInventoryAdjustmentLotMove
Please add the highlighted condition in the join itself to restrict no of record in the join operation if you have multiple tables in the join.
!pastedImage_d141672_7.jpg!
!pastedImage_d141672_8.png|height=338,width=574!
!pastedImage_d141672_9.png|height=363,width=574!
!pastedImage_d141672_10.png|height=374,width=574!
|