Scanner > Append Handheld Scanner Counts for Existing Inventory

Issue No: ST-1169
Created 1/15/2019 3:28:59 PM
Type Feature
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 18.3
Description * Objective ** Set Inventory Counts to 0 for non-counted items *** This is done in Inventory by selecting an Inventory Count first *** Then appending it with handheld scanner counts ** Automate AutoBlending scenarios for when counts are done in multiple Items that are not stocked in inventory for each item *** IE Carton UPC and Pack UPC are both in inventory * Requirements ** Change Handheld Scanner process *** Change Button from Create Inventory Count to Update Inventory Count *** Add Drop down to select Open Inventory Counts to Append **** Filter to Match Store/Company Location on Handheld Screen **** Filter where Count Status = Open **** Ensure a valid Inventory Count has been selected before allowing to Update Inventory Counts *** Processing **** When Item > Auto Blend = Yes and Item = Recipe Item for the Store Location (Autoblend Processing) ***** Add Count to Input Item UPC ****** Append if Count for Input Item already exists ***** Input Item Count = Multiply Recipe Output Item Count * Input Quantity ****** Example: ******* Recipe Output Item = 1230010113 Carton UPC ******* Recipe Input Item = 1230000001 Pack Upc ******* Recipe Input Qty = 10 ******* Count of Recipe Output Item 1230010113 Carton UPC = 2 ******* Count of Existing 1230000001 Pack UPC= 17 ******* Inventory Count Record 1230010113 Carton UPC = 0 ******* Inventory Count Recort 1230000001 Pack UPC = 37 ******** Existing Input Item Physical Count + Recipe Output Item Count * Input Qty ******** 17 + 2 * 10 = 37 ***** Inventory Count > Physical Count should be replaced by the combined count from the handheld scanner **** Else(Normal Processing) ***** Inventory Count > Physical Count should be replaced by the count from the handheld scanner * Testing Scenarios ** Scanner Count where Item is part of Inventory Count selected *** Update Physical Count in Inventory Count ** Scanner Count where item is not part of Inventory Count Selected *** Create additional Inventory Count Detail Line with the Physical Count (IC SP should handle this without any additional store logic) ** Scanner Count where Recipe Output Item does not have existing Input Item Count *** Update Physical Count in Inventory Count ** Scanner Count where Recipe Item does have existing Input Item Count *** Combine with Recipe Item with Input Item and update Physical Count in Inventory Count