| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-264604 - Inventory Count is duplicating |https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-264604]
*Steps:*
1. Go to Inventory > Inventory Count
2. Create a Cycle Count ( Include On hand)
3. Do cycle count for one item using Handheld
*Issue 1:* The Count# is duplicated in Inventory Count screen
*Issue 2:* Even if we count for one storage unit, system taken count for other storage unit
!pastedImage_d170029_0.png|height=389,width=800!
!pastedImage_d170029_1.png|height=440,width=800!
BEGIN TRAN
select ICD.* from tblICInventoryCountDetail ICD JOIN tblICInventoryCount IC ON IC.intInventoryCountId = ICD.intInventoryCountId
AND IC.strCountNo = 'IC-5'
EXEC dbo.uspICUpdateInventoryPhysicalCount @strCountNo = 'IC-5'
,@dblPhysicalCount = 19000
,@intLotId = NULL
,@intUserSecurityId = 1
,@intItemId = 208
,@intItemLocationId = 365
,@intItemUOMId = 37161
,@intStorageLocationId = 492
,@intStorageUnitId = 17268
select ICD.* from tblICInventoryCountDetail ICD JOIN tblICInventoryCount IC ON IC.intInventoryCountId = ICD.intInventoryCountId
AND IC.strCountNo = 'IC-5'
ROLLBACK TRAN
*Expectation:* Count# should not be duplicated
|