Update Stock
An overview of application used for entering or adjusting on-hand balances in the system without going through the entire physical inventory flow.
Overview
Different Select Options (allows a user to choose a way of adding new or searching for available Balance IDs).
Search Bulk - gives an overall, high-level searching criteria.
Search Detail - instantly fetches Balance ID(s) through label scanning.
Add - instantly add (a) new Balance ID(s) through label scanning or manual input.
Support for Alias Numbers.
Report Printing
Print Putaway Label (MWS450PF) for the created or updated inventory.
Decide upon number of copies and quantity per label.
Embedded Calculator function.
Adds/removes instantly scanned labels that counts quantities, catch weights, lot numbers and containers. You may edit scanned values.
Automate screens.
By-pass report screens to accelerate the reporting steps.
Preview lines before reporting.
Used APIs
Used Environment Properties
User Steps
Select Option
Use the following user step to define the action you want to take.
ENVIRONMENT PROPERTIES PER SCREEN (SELECT OPTION)
HEADER/INFO DATA
N/A
INPUT DATA
Detail/Bulk/Add
FUNCTIONALITY
Tap on Options check box to select one.
Detail Search allows you to identify Balance IDs by scanning the existing barcodes.
Bulk Search allows you to identify Balance IDs using searching criteria.
Add allows you to add new Balance IDs by scanning the existing barcodes or via manual entry.
Blank is assigned as default.
Default can be changed in the global properties on user/app level.
Click NEXT button to continue.
Click MENU button to get back to the main menu.
Search Balance ID (Detail)
Use the following user step to search for existing Balance ID(s) by scanning their barcodes.
ENVIRONMENT PROPERTIES PER SCREEN (SEARCH BALANCE ID (DETAIL))
INFO/HEADER DATA
Warehouse
Location (if used)
INPUT DATA
Add/Remove
Multi Data
FUNCTIONALITY
A list of available Balance IDs from predefined warehouse is preloaded in the background via MMS060MI.LstBalID.
If a location is selected, the list is filtered through that location.
Select either Add or Remove option button to adjust the behaviour when value is scanned into Mutli Data field.
Scan inside the Multi Data field to instantly retrive or remove the Balance ID to/from the Balance IDs list.
The input field is equipped with embedded translation engine which retrives multiple values used in the later reporting process.
The input field supports Alias Numbers. Make sure a proper configuration in MMS025 Item.Connect Alias Number is secured.
Refer to Managing Multiple Data Capture section to understand and configure capturing of the barcoded data.
When the scanned record refers to more than one hit, the Select Searched Balance ID screen pops up. Tap one record to add it to the list. Example below shows a lot number 2305101001 that has been identified in the scanned string. The string, however, does not provide any information about the location nor has it been selected via CHANGE option. Thus, the Select Searched Balance ID pops up where the correct Balance ID has to be chosen.
Click BACK to get back to Select Option screen.
Click EDIT to change or delete the scanned Balance ID(s) (applicable only for Detail Search).
Tap on a record you wish to change.
Type in numeric values inside Scanned Weight and/or Scanned Quantity fields.
Click DELETE RECORD to remove the record from the list.
Click <- to go back to the EDIT screen.
Click BACK to get back to Select Balance ID screen without saving.
Click NEXT to get back to Select Balance ID screen with new values being applied.
Click CHANGE to change Location and/or Warehouse.
Type in/scan a location inside Location field to assign a location filter on the fetched list of Balance IDs in the Search Balance ID screen.
Location ID will be added to the header.
Click BACK to get back to Search Balance ID screen without any changes.
Click LIST (LOCATIONS) to fetch a list of available locations.
List is fetched through MMS010MI.ListLocations with the predefined warehouse.
Location IDs and/or Location Names are used and can be filtered through.
Tap on a location to assign a location filter on the fetched list of Balance IDs in the Search Balance ID screen.
Click BACK to get back to Search Location screen.
Click LIST (WAREHOUSES) to fetch a list of available warehouses.
List is fetched through MMS005MI.LstWarehouses.
Warehouse IDs and/or Warehouse Names are used and can be filtered through.
Tap on a warehouse to reload the list of Balance IDs in the Search Balance ID screen.
Click BACK to get back to Search Location screen.
Click NEXT to get to Search Balance ID screen with applied changes.
Click NEXT to get to Select Balance ID screen.
Search Balance ID (Bulk)
Use the following user step to search for existing Balance ID(s) by using high-level searching criteria.
ENVIRONMENT PROPERTIES PER SCREEN (SEARCH BALANCE ID (BULK))
INFO/HEADER DATA
Warehouse
INPUT DATA
Location
Item Number
Lot Number
Container
FUNCTIONALITY
List is fetched through MMS060MI.LstBalID with the predefined warehouse.
Tap on Location drop-down menu to select one.
List is aggregated on a location level.
Location IDs are used and can be filtered through.
Tap on Item Number drop-down menu to select one.
List is aggregated on an item level.
Item IDs and Item Names are used and can be filtered through.
Tap on Lot Number drop-down menu to select one.
List is aggregated on a lot number level.
Lot Numbers are used and can be filtered through.
Tap on Container drop-down menu to select one.
List is aggregated on a container number level.
Container Numbers are used and can be filtered through.
Click BACK to get back to Select Option screen.
Click CHANGE WAREHOUSE to change Warehouse.
List is fetched through MMS005MI.LstWarehouses.
Tap on a warehouse in the list to select one.
Click BACK to get back to Search Balance ID screen without any change.
Click NEXT to get back to Search Balance ID screen with a confirmed warehouse change.
Click NEXT to get to Select Balance ID screen.
If any drop-down menu is used, it will be used as a filter in Select Balance ID screen.
Add Balance ID
Use Add Balance ID screen to add (a) new Balance ID(s) to stock.
ENVIRONMENT PROPERTIES PER SCREEN (ADD BALANCE ID)
INFO/HEADER DATA
Warehouse
Location
Reason
INPUT DATA
Add/Remove
Multi Data
FUNCTIONALITY
A list of available items from predefined warehouse is preloaded in the background via EXPORTMI.Select from MITBAL table.
A list of available reason codes is preloaded in the background via EXPORTMI.Select from CSYTAB table.
Select either Add or Remove option button to adjust the behaviour when value is scanned into Mutli Data field.
Scan inside the Multi Data field to instantly retrive or remove the Balance ID to/from the Balance IDs list.
The input field is equipped with embedded translation engine which retrives multiple values used in the later reporting process.
The input field supports Alias Numbers. Make sure a proper configuration in MMS025 Item.Connect Alias Number is secured.
Refer to Managing Multiple Data Capture section to understand and configure capturing of the barcoded data.
Click BACK to get back to Select Option screen.
Click CHANGE to change Warehouse, Location and/or Reason.
Type in/scan a location inside Location field to assign a new location in the Add Balance ID screen.
Location ID will be added to the header.
Click BACK to get back to Add Balance ID screen without any changes.
Click LIST (LOCATIONS) to fetch a list of available locations.
List is fetched through MMS010MI.ListLocations with the predefined warehouse.
Location IDs and/or Location Names are used and can be filtered through.
Tap on a location to assign a new location for added Balance ID(s) in Add Balance ID screen.
Click BACK to get back to Search Location screen.
Click LIST (WAREHOUSES) to fetch a list of available warehouses.
List is fetched through MMS005MI.LstWarehouses.
Warehouse IDs and/or Warehouse Names are used and can be filtered through.
Tap on a warehouse to assign a new location for added Balance ID(s) in Add Balance ID screen. List with available items and locations will be reloaded.
Click BACK to get back to Search Location screen.
Click LIST (REASONS) to fetch a list of available reason codes.
List is fetched through EXPORTMI.Select from CSYTAB table where CTSTCO = RSCD (equivalent to CRS103).
Reason IDs and/or Reason Descriptions are used and can be filtered through.
Tap on a reason to assign a new reason for added Balance ID(s) in Add Balance ID screen.
Click BACK to get back to Search Location screen.
Click NEXT to get to Add Balance ID screen with applied changes.
Click EDIT to change, delete the scanned or add (a) new Balance ID(s) (applicable only for Add Mode).
Tap on a record you wish to change.
Type in numeric values inside Scanned Weight and/or Scanned Quantity fields.
Click DELETE RECORD to remove the record from the list.
Click <- to save and go back to the EDIT screen.
Click ADD ROW to add (a) new Balance ID(s).
Location, Item Number and Onhand Quantity are mandatory fields
Click on Print Label to trigger Report Printing after successful add-on.
Click <- to go back to the EDIT screen.
Click CREATE to save and go back to the EDIT screen.
Click BACK to get back to Add Balance ID screen without saving.
Click NEXT to get back to Add Balance ID screen with new values being applied.
Click NEXT to get to Confirm screen.
If Print Label tickbox is ticked, you will be forwarded to Report Printing screen first.
Select Balance ID
Use Select Balance ID screen to choose the Balance ID(s) You would wish to update.
ENVIRONMENT PROPERTIES PER SCREEN (SELECT BALANCE ID)
INFO/HEADER DATA
Item Number
Lot Number
Container Number
Onhand Catch Weight / Scanned Catch Weight (available via Detail Mode)
Onhand Quantity / Allocatable Quantity / Scanned Quantity (available via Detail Mode)
INPUT DATA
Multi Data
FUNCTIONALITY
Scan into the Multi Data field to filter the list.
The input field is equipped with embedded translation engine which retrives multiple values used in the later reporting process.
Refer to Managing Multiple Data Capture section to understand and configure capturing of the barcoded data.
When the scanned record refers to an unique record, the Report Quantity screen pops up with all identified data. When more than one hit is identified, a filter is applied listing only identified records the list. Example below shows a lot number 2305101001 been identified in the scanned string. Only records with that lot number are shown.
Click NEXT to proceed to Report Quantity screen.
Report Quantity
Use Report Quantity screen to adjust the selected Balance ID for inventory update.
ENVIRONMENT PROPERTIES PER SCREEN (REPORT PRINTING)
INFO/HEADER DATA
Selected Balance ID
Location
Item Number
Lot Number (if applicable)
Container Number (if applicable)
Onhand Quantity
Onhand Catch Weight (if applicable)
INPUT DATA
Print Label
Reason
Catch Weight (if applicable)
Quantity
FUNCTIONALITY
Tap on Print Label tickbox to trigger the Report Printing screen after Report Quantity screen.
Putaway Label (MWS450PF) will be printed as an output.
Blank is assigned as default which can be changed in the environment properties on a global/user level.
Tap on Reason drop-down menu to select one.
Reason IDs and Reason Names are used and can be filtered through.
Blank is assigned as default which can be changed in the environment properties on a global/user level.
Type in/scan the numeric Catch Weight value.
Blank is assigned as default which can be changed in the environment properties on a global/user level.
Type in/scan the numeric Quantity value.
Blank is assigned as default which can be changed in the environment properties on a global/user level.
Click BACK to get back to Select Balance ID screen.
Click CALCULATOR to trigger calculator function.
Select either Add or Remove option button to adjust the behaviour when value is scanned into Mutli Data field.
Scan inside the Multi Data field to instantly retrive or remove the Balance ID to/from the Balance IDs list.
Refer to Managing Multiple Data Capture section to understand and configure capturing of the barcoded data.
The input field is equipped with embedded translation engine which retrives multiple values used in the reporting process.
Click BACK to get back to Report Quantity screen without applying any changes.
Click EDIT to edit the quantitive data of the scanned items.
Tap on a record you wish to change.
Type in numeric values inside New Catch Weight and/or New Quantity fields.
Click DELETE RECORD to remove the record from the list.
Click ADD ROW to add a new record.
Click BACK to get back to Calculator screen without any changes being saved.
Click NEXT to get back to Calculator screen with applied changes.
Click NEXT to get back to Report Quantity screen with applied changes.
Click NEXT to get to Confirm screen.
If Print Label tickbox is ticked, you will be forwarded to Report Printing screen first.
Report Printing
Use the following user step to adjust the label printout after creating or updating the Balance ID.
ENVIRONMENT PROPERTIES PER SCREEN (REPORT PRINTING)
INFO/HEADER DATA
Selected Balance ID
Item Number
Lot Number (if applicable)
Container Number (if applicable)
Reported Quantity
Reported Catch Weight (if applicable)
INPUT DATA
Printer
Number of Labels
Quantity per Label
FUNCTIONALITY
List of printers is fetched through CRS290MI.LstPrinters.
Tap on Printer drop-down menu to select one.
Printer IDs and Printer Names are used and can be filtered through.
Blank is assigned as default.
Default can be changed in the environment properties on user/app level.
Type in/scan the numeric Number of Labels value.
Blank is assigned as default.
Default can be changed in the environment properties on user/app level.
Type in/scan the numeric Qty per Label value.
Blank is assigned as default.
Default can be changed in the environment properties on user/app level.
Confirm
Use the following user step to do the final check before updating the Balance ID.
ENVIRONMENT PROPERTIES PER SCREEN (CONFIRM)
INFO/HEADER DATA
Balance ID(s) to be updated
FUNCTIONALITY
Click BACK to get back to Report Quantity or Report Printing screen.
Click UPDATE to run (a) selected transaction(s).
The application comes back with an approve message that the Balance ID has been created or updated.
You are redirected to the Select Option or Select Balance ID screen.
Last updated
