Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-241671 - 20009-01 IRELY wrong batch issue|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-241671]
Steps:
1. Run the below script in database available in link [ftp://74.208.186.24/Databases/CBI/CBI92.7z]
BEGIN TRANSACTION
GO
SELECT strLotAlias
FROM tblICLot
WHERE strLotNumber = '20009-01-104' and intStorageLocationId =438
GO
DECLARE @intInventoryAdjustmentId NVARCHAR(MAX)
EXEC uspICInventoryAdjustment_CreatePostLotMerge @intItemId = 27
,@dtmDate = '2020-01-31 00:00:00.000'
,@intLocationId = 1
,@intSubLocationId = 2
,@intStorageLocationId = 417
,@strLotNumber = 'R19227-01-900'
,@intNewLocationId = 1
,@intNewSubLocationId = 2
,@intNewStorageLocationId = 438
,@strNewLotNumber = '20009-01-104'
,@dblAdjustByQuantity = - 1.00000000000000000000
,@intItemUOMId = 27
,@dblNewSplitLotQuantity = NULL
,@dblNewWeight = NULL
,@intNewItemUOMId = NULL
,@intNewWeightUOMId = NULL
,@dblNewUnitCost = NULL
,@intSourceId = 1
,@intSourceTransactionTypeId = 8
,@intEntityUserSecurityId = 11
,@intInventoryAdjustmentId = @intInventoryAdjustmentId OUTPUT
,@strDescription = ''
GO
SELECT strLotAlias
FROM tblICLot
WHERE strLotNumber = '20009-01-104' and intStorageLocationId =438
GO
ROLLBACK TRANSACTION
Issue: Lot alias of destination lot is changing after merging a lot
Expectation: System should retain the same lot alias of destination lot
|