ANALYZE INVENTORY PERFORMANCE

The RICS inventory features enable retailers to track and analyze items through sales and inventory transactions as they are transacted through the RICS Back Office and the RICS POS.

This document is a resource for retailers to understand how to analyze inventory performance using:
Generate a Stock Status Report

 


GENERATE A STOCK STATUS REPORT
The RICS Stock Status report enables retailers to view current inventory based on hand, quantity sold, on order, etc. as determined by selected criteria.


REPORT OPTIONS TAB

1. In the RICS Back Office, go to Reporting :: Inventory/Purchase Orders :: Stock Status at the store level

2. Select or enter the necessary options to determine how and which items to display

Options:

CSV Output options – Select this option to display a size COL row for all sizes available on an item with or without On Hand inventory. Only available through CSV.

How do you want to sort the results? – From the dropdown menu, select an option to determine how results are displayed on a report based on how an item is set in Setup :: Manage SKUs.

Filter by these dates – Enter a date timeframe to narrow down results. In order for an item to display, the item must have sales within this timeframe and the “Available to POS On” field for the item as set in Setup :: Manage SKUs must occur within this timeframe. RICS recommends leaving this field blank.

Select Which Inventory Items – From the dropdown menu, select an option to determine which item(s) you would like to display on a report based on inventory state.

How to value your inventory? – From the dropdown menu, select a date option to determine when a store’s inventory value should be displayed.

Show Only SKUs With Sales In – From the dropdown menu, select a Sales Period option to display only items with sales during the selected or entered sales period.


REPORT CRITERIA TAB

1. After selecting the report options, click the Report Criteria tab

Note: To report on all items within a store based on selections on the Report Options tab only, leave the Report Criteria fields blank and proceed to Printing Options tab section.

2. Select and enter the necessary criteria to determine what items to display on a report. Multiple criteria options can be selected to narrow down a user’s search

Options:

By Supplier – Enter or search for a supplier code(s) to select which supplier(s) to output.

By Class – From the dropdown menu, select the class or classes to select which class to output.

By Color – Enter a color(s) to select which color(s) to output.

By SKU – Enter or search for an item(s) to select which item(s) to output.

By Col – From the dropdown menu, select the column value(s) within the column grid(s) to output.

By Row – From the dropdown menu, select the row value(s) within the row grid(s) to output.

By PO# - Enter or search for a Purchase Order Number(s) to select which PO to output.

Product Custom Entries – If setup within your store, enter a custom entry or entries to determine which custom entry to output.

Note: If selecting multiple Suppliers, Colors, SKUs, or Product Custom Entries, separate the values by commas. If wanting to exclude the selected value(s), select the checkbox next to Exc.

3. Use the Pricing selection to determine items reported based on price and perk as of today:

Pricing Options:

Include Only SKUs At Retail Price (as of today) – Select to display items based on previously set criteria without a Markdown Price on the Setup :: Manage SKUs screen.

Include Only SKUs At Markdown Price (as of today) – Select to display items based on previously set criteria with a Markdown Price on the Setup :: Manage SKUs screen.

Include Only SKUs With Perks (as of today) – Select to display items based on previously set criteria with a Perk on the Setup :: Manage SKUs screen.


PRINTING OPTIONS TAB

1. After selecting the report criteria, click the Printing Options tab

2. Select the necessary Print Which Quantities option to determine what quantities to display

Note: At least one selection is required for the report to display results. Multiple selections can be made for a single report.

Print Which Quantities Options:

Model – Select this option to display current model quantities entered for an item, if setup in Inventory :: Stock Maintenance :: Enter Product Models.

On Hand – Select this option to display current inventory quantities for an item.

Short – Select this option to display the quantity difference between On Hand and model, if setup for item.

Critical – Select this option to display the quantity difference between On Hand and model, if setup for item and not on order.

Max – Select this option to display current max model quantities entered for an item, if setup in Inventory :: Stock Maintenance :: Enter Product Models.

Reorder – Select this option to display current reorder quantities entered for an item, if setup in Inventory :: Stock Maintenance :: Enter Product Models.

On-Order (At Once) – Select this option to display quantities on order for an item within 30 days, unless changed by the store under Setup :: Manage Store :: Setup Settings.

On-Order (Future) – Select this option to display quantities on order for an item after 30 days, unless changed by the store under Setup :: Manage Store :: Setup Settings.

On-Order (Total) – Select this option to display quantities on order, At Once or Future, for an item.

In Transit (Multi-Store) – Select this option to display transferred but not received items from another store.

Show Negative On Hand – Select this option to display negative On Hand inventory for an item. On Hand must be selected as well.


3. Select the necessary Also Print options to determine additional information to display

Also Print Options:

Costs – Select this option to display the Cost and current Price of an item as set in Setup :: Manage SKUs

ROI and Turns – Select this option to display the ROI and Turns for an item. ROI measures how many dollars of gross profit or margin a store is earning for each dollar invested in inventory based on its present rate of sales and average inventory for the period. Turn is an annual ratio of how many times a store’s inventory is sold and replaced during any given period.

Age – Select this option to display the days between the inventory valuation date and when the item was first and last received.

Sales History By Month – Select this option to display the total sales of an item by month.

Location (Warehouse) – Select this option to display the location the item is located.

Perks – Select this option to display the perk placed on the item as set in Setup :: Manage SKUs.

Column Totals – Select this option to display the total number of On Hand inventory per column size.

4. Select the Print selected quantities grouped by row checkbox to display the Printing Options previously selected in Step 2 by row instead of data quantity selected

Print selected quantities grouped by row – Unselected

Print selected quantities grouped by row – Selected

5. Select a date or date range(s) from the Sales Period dropdown menu to display the number of units sold of an item during a specific timeframe

AGING OPTIONS TAB

1. After selecting the printing options, click the Aging Options tab

Note: To report on all items within a store based on Report Options, Report Criteria and Printing Options tab only, leave Aging Options fields black and proceed to Step 4.

2. Enter the aging date options to narrow down the list of items to display on a report based on a receiving date

Aging Options:

Date Last Received from – Include items with a last received date falling between the dates entered.

Date First Received from – Include items with a first received date falling between the dates entered.

3. Click Add Job and Run

Have more questions? Submit a request

Comments

Powered by Zendesk