| Oracle® Retail Store Operations Cloud Service User Guide Release 17.0 E88477-05 |
|
 Previous |
 Next |
| Oracle® Retail Store Operations Cloud Service User Guide Release 17.0 E88477-05 |
|
Previous |
Next |
This chapter covers stock counts. The following topics are covered:
Overview: Introduction to stock counts
Functionality: Description of available screens.
EICS provides the ability to schedule and authorize stock counts whereas SOCS provides the ability to execute the stock counts.
Portions of the stock count functionality, such as the setup of product groups, schedules, and authorizations, are performed on the EICS only. Users can configure and execute different types of stock counts such as cycle or annual counts, ad hoc counts, or counts that are based on inventory position or problems like negative stock on hand. Merchandising and individual level counting require setup and scheduling utilizing product groups, with the exception of AD Hoc counts. The Ad Hoc count will allow the user to decide which items they want to count by scanning from the shelf immediately.
Most of these counts can be scheduled to be executed repetitively on certain dates reducing the need for daily or weekly count management.
Because a variance percentage can be set, items within tolerance can, but do not have to be authorized individually.
Business Case
Ad Hoc stock count
A customer is looking for a blue tooth speaker in the color black. The customer finds the location on the shelf, but there are only bright pink speakers and asks a sales associate if there are any black speakers in the storage room. The sales associate looks up the inventory and the system shows there are three on hand. The sales associate looks in the backroom and cannot locate any in the store and informs the customer and reports to the store manager. The store manager instructs the sales associate to perform an ad hoc stock count to immediately correct the inventory.
Unit stock count
The dairy department of a grocery retailer orders milk on Tuesdays and Fridays. Before they get the order in, they are always running out of stock. The department manager decides to perform a unit count each day to determine when they are running short or if there might be some pilferage occurring.
Problem Line stock count
Due to ineffective receiving processes or supply chain issues, items regularly have negative stock on hand. Inventory control schedules a stock count that tracks this behavior automatically to correct such problems without having to generate manual stock count lists for each store.
Unit and Amount stock count
The Store Manager is informed when it is time to financially report their store's current value of inventory. The corporate user will schedule the Unit and Amount stock count to be executed by Department and the store manager will schedule additional staff to count all items in the store. Each Department manager will be required to complete and approve their section of the stock count. When complete, the financial value will be associated with each item counted in the store and sent to the merchandising system to have it in a similar way corrected.
Each type of stock count can be useful for a retailer and all play an important part in the management of inventory.
Unlike the other stock count types, Ad Hoc stock counts are not scheduled, but rather performed at random times when a user decides to correct inventory.
Since this count type is performed randomly, there are no predefined lists and the user can scan any item in any order. The user can count any inventory item even if the item has been discontinued.
The inventory snapshot is taken as each item is added to the stock count. Snapshot is a process in which the system will capture the current stock on hand quantity. For Ad Hoc counts, discrepancy thresholds are set up differently from other count types by accessing the Ad Hoc Stock Count screen.
Inventory Adjustments will be created and sent to the merchandising system when an inventory change is made in the system.
The unit stock count must be scheduled. They can be scheduled and executed the same day if the user desires. This count type can be setup on a recurring basis: daily, weekly, monthly or yearly.
The items to include in the stock count are identified by setting up a product group. The product groups are a one-time setup and can be reused for future stock counts. Product groups are used for creating the list of items as well as identifying how the stock count is processed. When setting up the stock count, the user can define which items to include by selecting by item, supplier, promotion or merchandise hierarchy level. There are various settings used to determine how an item will be identified as being discrepant.
Unit counts are the only stock count type that allows the user to select any item status to include in the count. The user can also select whether to include items that do not have any stock on hand. Inventory Adjustments are created and sent to the Merchandising System for any inventory adjustments made.
The problem line stock count is setup once and scheduled to run daily. If there are no problem items, a stock count will not be created. Setup of the stock count can be done at the item, supplier, promotion or merchandise hierarchy level. Each day, the system will run the problem batch and find any problem items and populates those items on a stock count. Discrepancy Thresholds are defined the same as the Unit count, but there are additional criteria defined during Product Group Setup. The additional information the user can select for the problem line counts includes, Actual Pick Amount less than Suggested Pick Amount and negative available inventory.
Problem line stock counts follow exactly the same workflow as unit counts. The only exception is the product group setup.
The Unit and Amount stock counts must be scheduled for a specific date. These stock counts, need to be scheduled at least 1 day ahead of time. When the count is scheduled it is sent to the merchandising system so that it can also create a corresponding stock count.
Item lists are created by merchandise hierarchy or can include all departments. Unit and Amount counts cannot select by item, supplier or promotion, because the merchandising system holds the valuation at the merchandise hierarchy level.
The item status and SOH Quantity cannot be selected and are defined by the system. Inventory is updated in the system and a flat file is created with the new SOH quantity, rather than the delta. The file will be sent out externally for other systems such as merchandising.
The following figure shows a summary of the similarities and differences between the various types of stock counts.
Unit, Problem Line, Unit and Amount stock counts all use predefined items lists and must be scheduled. Ad Hoc stock counts do not use a predefined item list, are not scheduled. The snapshot for Unit, Problem Line and Unit & Amount stock counts is taken for all items on the count at the same time, while the Ad Hoc stock count takes the snapshot as each item is counted. Only the Unit and Problem Line allow the snapshot to be retaken during the recount. Ad Hoc stock counts never use guided counting and as a result files cannot be imported from a Third Party service. Only the Unit stock count can be scheduled on a recurring basis. The Problem Line can only be scheduled daily and Unit and Amount scheduled for a specific date.
Since the Ad Hoc stock count is not defined using product groups, it is the only type of count that does not have a recounting stage.
This section covers the available screens.
The following is a list of features for Stock Counts in SOCS:
Search for stock count
Create a new AdHoc stock count
View or edit an existing stock count
Count items for stock count
After logging into SOCS, the main menu drawer is displayed. The user can select Stock Counts from which under the Inventory management menu.
The Stock Counts module in SOCS contains Stock Count List, Creating a new Ad hoc Stock count, Child Stock Count List and viewing the item details.
The user can select Stock Count from the Main Menu Drawer and be directed to the Stock Count List screen. The user will need permissions to access this screen. When the user enters the screen, the system will default to display records with a status of "Active" and type of "Active."
The transactions may include, Ad hoc stock count, Unit count, Problem Line count, and Unit and Amount count:
The user is required to have the Edit Adhoc Stock Count permission to edit an Adhoc stock count.
The user is required to have the Edit Unit Stock Count permission to edit a Unit stock count.
The user is required to have the Edit Unit Amount Stock Count permission to edit a Unit and Amount stock count.
The user can select Create Ad Hoc from Stock Count List and be directed to the Add Stock Count popup to add a description for an Ad Hoc stock count. The user will need permissions to access this screen. When the user enters the screen, the text box for entering description for Ad Hoc stock count is filled with highlighted <user ID> which, once written with text, goes off.
The user can select the eye glasses from the stock count list screen and be directed to the Search criteria screen. When the user enters the screen, SOCS will default to display records with a status of 'Active' and type of Active.
Fields
Criteria Applied <x>: The number of criteria applied to the search, where X is the number.
Scheduled Date: The date for which the scheduled stock count is scheduled. Defaults to blank.
Department - List of values containing all of the departments. The value will be defaulted to All. Since a Product Group can consist of more than one merchandise hierarchy, the filter will return all stock counts that are affiliated with the department or where the counting groups contains that hierarchy. When a department is cleared out, the class and sub-class will also be cleared out.
Class - List of values containing all of the classes for the selected department. The user must select a department first for the class to be editable. The value will be defaulted to All. Since a Product Group can consist of more than one merchandise hierarchy, the filter will return all stock counts that are affiliated with the class and counting groups that contain that hierarchy. When a class is cleared out, the subclass will also be cleared out.
Sub-Class: List of values containing all of the sub-classes for the selected class. The user must select a class first for the class to be editable. The value will be defaulted to All. Since a Product Group can consist of more than one merchandise hierarchy, the filter will return all stock counts affiliated with that subclass and counting groups that contain that hierarchy.
Count Group: List of all product groups that exists in the system. Defaults to All.
Type: List of values. Valid values are Stock Count, Re-Count, Authorize, Active, and All. Default value is Active. Active is a type represents Stock Count and Recount (not Authorize).
Status: valid values are New, In Progress, Processing, Completed, All, and Active. Default value is Active. Active will include New and In Progress stock counts.
|
Note: Confirmed is the status of a guided Unit and Amount stock count for all items that are in Authorize Type and have not yet moved to Completed due to not having the results exported. Once exported, the stock count will move to Completed status. If user selects a stock count in confirmed or completed status it will be in view only mode. |
Search Limit: Entry field. The user can define a search limit for the number of transactions being displayed. It is a Required Field. The value will default through a system admin setting, Search Limit Default for stock count list - Mobile.
The user can select Stock Count from the Stock Count List and be directed to the Child Count List screen. When the user enters the screen, SOCS will sort the child count by ID. Closed child count should be at the bottom and Active child counts should be at the top and then this ID sorting should be applied.
Selecting a child count will take the user to the Stock Count Items /Stock Re-Count Items screen. Ad hoc Stock Counts will automatically have a single child count created. (Ad hoc stock counts will have one stock count to one child). The child count will be automatically named the same as the stock count (assigned description by user) with the words (child) after it.
The snapshot of a stock count will happen as follows:
Unit or Problem Line: Can be taken from Child count list screen for the whole stock count or from the Stock count item screen if not in re-count mode. For Re-Count, it will be taken automatically.
Adhoc: Takes snapshot as items are added.
Unit and Amount: Snapshot for this type can be taken via the Snapshot batch with the EICS module.
The user can access the Child Count List screen by creating an Adhoc stock count or selecting a stock count from the Stock Count List screen.
The user must have the Edit Adhoc Stock Count permission to open the screen in edit mode when displaying an Adhoc count; otherwise the screen will open as view only.
Similar to a unit count, the user must have the Edit Unit Stock Count permission to open the screen in edit mode when displaying a Unit count; otherwise, the screen will open as view only.
The user must have the Edit Unit and Amount Stock Count permission to open the screen in edit mode when displaying a Unit and Amount count; otherwise the screen will open as view only.
Snapshot: This will take snapshot for all the child counts on the stock count. This will take a snapshot for Problem line and Unit type of stock counts only. If any other type of stock count, this button will not be visible.
Footer Menu
This opens up a footer menu with following options:
Info: Info popup will be displayed.
Product Group Info: Product Group Info popup will be displayed.
Notes: Notes dialog will be displayed.
Back: This will navigate the user back to the Stock Count List screen.
Delete: This will delete the Stock Count that is under consideration and have not yet been authorized.
Close: This will navigate the user to stock count list screen.
The user can select a child count from the Child count list screen and be directed to the Stock Count items or stock Re-count items screen depending upon the status of the stock count. This screen appears when a child stock count is selected and the Child stock count type is Stock Count New or Stock Count In Progress. Item Images will be displayed per a system admin setting for stock counts. The system will default to show the "uncounted" records.
Selecting an item will go to the Item Detail for that item. All newly added items and modified items will have a bar on left to denote those have been modified.
When the user enters the screen, SOCS will sort the items left to count as below:
If guided and if items are sequenced, then order by sequence order.
If it is un-sequenced, "no location" items falling at the end by item description order.
If unguided, items are always sorted by item description.
Snapshot of stock count will happen as follows:
Unit: Can be taken from Child count list screen for the whole stock count or from Stock count item if not in re-count mode. For Re-Count it will be taken automatically.
Adhoc: Takes snapshot as items are added.
Unit and Amount: User can schedule the Snapshot batch for this purpose.
Problem line: Same processing as Unit Stock Count.
Footer Menu
Info: Info popup will be displayed.
Notes: Notes dialog will be displayed.
Complete: This will complete the child count and navigate the user to the Child Count List screen. The user is required to have the Complete Stock Count permission for this menu option to display.
Save: This will save the child count and navigate the user to Child count list screen.
Save & Continue: This will save the child count and user will be in the same dialog.
Cancel: This will discard changes to stock count / re-count and navigate the user to Child count list screen. This will be "back" when in view only mode.
Close: This will navigate the user to stock count items screen.
The user can select the eye glasses from the Stock count Items / Stock Re-Count Items screen and be directed to the Search criteria screen.
The default will be:
Stock Count: Count / Re-Count Qty = 'uncounted'
Re-Count: Count / Re-Count Qty = 'uncounted', Filter = 'Discrepant'
The Count / Re-Count Qty will default as the filter on the top of the Stock Count / Stock Re-Count screen.
Fields
Criteria Applied <x> - the number of criteria applied to the search, where X is the number.
Count / Re-Count Qty: Valid values are All, Counted and Uncounted.
Filter: Valid values are All Items and Discrepant Items. Displays only when it is a Re-Count.
Department: List of values containing all of the departments pertaining to that stock count. The value will be defaulted to All. Since a Product Group can consist of more than one merchandise hierarchy, the filter will return all stock counts that are affiliated with the dept or where the counting groups contains that hierarchy. When a department is cleared out, the class and sub-class will also be cleared out.
Class: List of values containing all of the classes for the selected Department. User must select a department first for the class to be editable. The value will be defaulted to All. Since a Product Group can consist of more than one merchandise hierarchy, the filter will return all stock counts that are affiliated with the class and counting groups that contain that hierarchy. When a class is cleared out, the subclass will also be cleared out.
Sub-Class: List of values containing all of the sub-classes for the selected Class. The user must select a Class first for the sub-class to be editable; the value will be defaulted to All. Since a Product Group can consist of more than one merchandise hierarchy, the filter will return all stock counts affiliated with that subclass and counting groups that contain that hierarchy.
Reset: Button will clear the screen of any previous search criteria that was entered by the user and set back to the default values. The screen will remain open for the user to enter in new search criteria.
The Review Item Detail screen is displayed when selecting an Item from the Stock Count / Stock Re-Count screen or scanned and scan mode in mode bar is set to "0". The image display will be controlled by the system parameter. This screen will help the user to review quantity for the stock count.
If the stock count is completed and where no further edits can be made, this will be a view only screen. Sorting of items will be, if guided and items are sequenced, then order by sequence order with non-sequenced "no location" items falling at the end by item description order. If unguided, items are always sorted by item description.
Removal of an item after it has been added is not allowed in Stock Count.
Cases or Units is the sum of the quantity of the items scanned until a new item is scanned. This field indicates the number of items a user has in front of them they have scanned.
User Quantity is the sum of all quantities for an item since the last time it was saved.
Total Quantity includes the quantities from the database when it was last read, increase with the user quantity.
Example: Assuming all items are units.
Scan item A.
User quantity 1
Session quantity 1
Total quantity 1
Scan item A again.
User quantity 2
Session quantity 2
Total quantity 2
Scan item B.
User quantity 1
Session quantity 1
Total quantity 1
Scan item A.
User quantity 1
Session quantity 3
Total quantity 3
Save count and scan item A.
User quantity 1
Session quantity 1
Total quantity 4
Scan item B.
User quantity 1
Session quantity 1
Total quantity 2
Footer Menu
If the user wants to reset the changes done in the same session, the user can reset it through the footer menu on the Item Detail screen.
