Description |
Provide a procedure to add or update a record in the inventory count detail 'tblICInventoryCountDetail'
IC Procedure should be following input parameters.
@strInventoryCountNo NVARCHAR(50)
,@intLotId INT
,@intUserSecurityId INT
,@dblPhysicalCount NUMERIC(18, 6)
,@intPhysicalCountUOMId INT
When user scans a pallet through scanner application, it will update Qty in the inventory count detail table if the scanned lot is available in the scanned count No, otherwise it will insert a new entry in the inventory count detail table against scanned count no.
Please refer the uspMFCreateInventoryCountDetail.
|