Description |
Getting the error " *Failed to process the lot number for PALLETCAP. It may have been used on a different sub-location or storage location* " while staging a packing material from storage location to staging location.
SQL script:
{noformat}SELECT*FROM tblICLot
WHERE strLotNumber ='P16338HU10005'AND intStorageLocationId IN(
2
,5
)GODECLARE @intInventoryAdjustmentId INTEXEC uspICInventoryAdjustment_CreatePostLotMove @intItemId = 345
,@dtmDate ='2017-01-16',@intLocationId = 1
,@intSubLocationId = 1
,@intStorageLocationId = 2
,@strLotNumber ='P16338HU10005',@intNewLocationId = 1
,@intNewSubLocationId = 1
,@intNewStorageLocationId = 5
,@strNewLotNumber ='P16338HU10005',@dblMoveQty = 1
,@intItemUOMId = 344
,@intSourceId = 1
,@intSourceTransactionTypeId = 8
,@intEntityUserSecurityId = 1
,@intInventoryAdjustmentId = @intInventoryAdjustmentId OUTPUT
{noformat}
!pastedImage_d68617_0.png!
Attached db in the below path:
[ftp://ftp.i21server.com:2121/Shree/] testTE_20170116.zip
|