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
|