Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-265644 - ItemUOMId, Weight per qty and Weight are wrong when producing an item|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-265644]
1. Produce an item using pack UOM and weight in the work order screen
2. Check whether produced lot is created correctly or not in the inventory view.
Issue
Item UOM Id, Weight and Weight per qty are incorrect.
!pastedImage_d172102_0.png|height=316,width=600!
Expectation
Item UOM Id should be 49125
Weight should be 40237.5
Weight per Quantity 2175
SQL script
declare @p4 nvarchar(50)
set @p4=N'G21292003'
declare @p5 int
set @p5=2556
exec sp_executesql N'uspMFCompleteWorkOrder @strXML,@strOutputLotNumber out,@intParentLotId out',N'@strXML nvarchar(1164),@strOutputLotNumber nvarchar(50) output,@intParentLotId int output',@strXML=N'8462021-10-193103WO-601False368540237.5380860217518.549125340237.517880507False2123101False',@strOutputLotNumber=@p4 output,@intParentLotId=@p5 output
select @p4, @p5
Go
Select dblQty,intItemUOMId,dblWeightPerQty, dblWeight,intWeightUOMId from tblICLot Where strLotNumber ='G21292014'
|