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:
Inventory Inquiry
Find Inventory by Size
Generate a Stock Status Report
Generate an Inventory Detail Report
Print a Receiving Log

 


INVENTORY INQUIRY
The RICS Inventory Inquiry feature enables retailers to view on hand inventory while analyzing past sales transactions, receiving transactions, and incoming inventory for an item.


GENERAL TAB

1. In the RICS Back Office, go to Inventory :: Inventory Inquiry at the store level

2. To select an item, enter or search for a SKU in the SKU field

Note: After the item is selected, the SKU Details will display providing general information about the item.

Note: General information displayed is determined by a user’s permission settings and roles.

3. Use the Primary and Secondary dropdown menus to determine what inventory value to display

Note: Depending on the Primary view selected, the Secondary view option may not be available.

4. If necessary, enter a store or state in the corresponding fields

Note: This option should only be used in a multi-store environment.

 

OPTIONAL DETAILS TAB

1. With the item selected on the General Tab, click the Optional Details tab

2. Select the Show Sales Summary, Show Detailed Report, Show Info Report and/or Show Purchase Order Detail checkbox to determine what information to display

Summary and Detail Options:

Show Sales Summary – Select to display a summary of weekly, monthly, yearly, and seasonal sales including quantity sold, net sales, and profit for an item.

Show Detailed Report – Select to display all transactions processed through the RICS Back Office and the RICS POS for an item including date, column and row, type of transaction, cost, etc.

Show Purchase Order Detail – Select to display purchase order details for open or recently closed POs for an item.

Show Info Report – Select to display monthly sales quantity and dollars, GP%, ROI and Turns for an item.

 

 


FIND INVENTORY BY SIZE
The RICS Find Inventory By Size feature enables retailers to view on hand inventory for items within a store based on selected criteria.


CRITERIA TAB

1. In the RICS Back Office, go to Inventory :: Find Inventory By Size at the store level

2. Select and enter the necessary criteria to determine in which size you want on hand information displayed. Multiple criteria options can be selected to narrow down a user’s search.

Criteria 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.

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. After you have set the criteria, click Display Results to view the items matching the criteria


VIEWING RESULTS

Note: Use the Sort Results By dropdown menu to change the how results are displayed.

 


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

1. In the RICS Back Office, go to Reporting :: Report Creator

2. Type Stock Status in the search box or navigate to Inventory/Purchase Orders :: Stock Status in the menu


FILE OPTIONS

1. Use the File Type dropdown menu to determine the output format

Note: If choosing CSV, use the Advanced Options dropdown to set a Field Delimiter.

2. As needed, enter a report description in the Report Name field

Note: Report descriptions will display in the Report Manager screen.

3. As needed, enter a valid email address in the Email A Copy To field to email the report

REPORT OPTIONS

1. Use the scroll bar to navigate to the Report Options section

2. If running in CSV file format, select the CSV Output option to display a size COL row for all sizes available on an item with or without on-hand inventory

3. Use the In Order Of dropdown menu to determine the order in which to sort and display the analyzed inventory

In Order Of Options:

Supplier – Select to display inventory in ascending order based on supplier.

Location (Warehouse Only) – Select to display inventory in ascending order based on warehouse location.

Class – Select to display inventory in ascending order based on class.

 

4. Use the Store Options dropdown menu to determine how analyzed store data will be grouped

Store Options:

Separate Stores – Select to display inventory by individual store.

Combine Stores – Select to display combined inventory for all stores.

Compare Store – Select to display a comparison of inventory for all stores.

Store Summary – Select to display a SKU total of inventory by individual store.

5. If necessary, enter a date range in the Filter by These Dates section to determine if the analyzed inventory will report on availability dates as set in the Setup :: Manage SKUs screen

Note: Leave blank to prevent inventory and sales transactions from being excluded.

6. Use the Select Which Inventory Items dropdown menu to determine what items to display

7. Use the Date dropdown menu to determine when to value inventory for the analyzed inventory

8. Use the Sales Period dropdown menu to display only items with sales during the selected or entered sales period

 

REPORT CRITERIA

1. After selecting the report options, use the scroll bar to navigate to the Report Criteria section

Note: To report on all items within a store based on the selections in the Report Options section only, proceed to Printing Options section.

2. Select and enter the necessary criteria to determine what items to display

Report Criteria Options:

By Store – Enter or search for a store code(s) to determine which store(s) to output.

By Store State – Enter a state’s abbreviation(s) to determine which state(s) to output.

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: Multiple criteria options can be selected to narrow down a user’s search. If selecting multiple Stores, States, 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

1. After selecting the report criteria, use the scroll bar to navigate to the Printing Options

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

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.

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

3. If necessary, select the 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. Use the Sales Period dropdown menu to display the number of units sold of an item during a specific timeframe

Note: Up to four Sales Periods can be selected.


AGING OPTIONS

1. After selecting the printing options, use the scroll bar to navigate to the Aging Options section

Note: To report on all items within a store based on the selections in the Report Options, Report Criteria and Printing Options sections only, proceed to Step 3.

2. Enter the aging date options to narrow down the list of items to display 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 Run

 

 

GENERATE AN INVENTORY DETAIL REPORT
The Inventory Detail report enables retailers to analyze inventory changes due to receiving, sales, purchase orders and physical inventory transactions as determined by the selected criteria and inventory change types. To generate an Inventory Detail report:

1. In the RICS Back Office, go to Reporting :: Report Creator

2. Type Inventory Detail in the search box or navigate to Inventory/Purchase Orders :: Inventory Detail in the menu

FILE OPTIONS

1. Use the File Type dropdown menu to determine the output format

Note: If choosing CSV, use the Advanced Options dropdown to set a Field Delimiter.

2. As needed, enter a report description in the Report Name field

Note: Report descriptions will display in the Report Manager screen.

3. As needed, enter a valid email address in the Email A Copy To field to email the report


REPORT OPTIONS

1. Use the scroll bar to navigate to the Report Options section

2. Use the Sales Period dropdown menu to determine what sales period to analyze

3. If necessary, select the Include Costs and Pricing option to determine if the cost of an item at the time the transaction will display

 

4. Use the Report Type and Sort By dropdown menus to determine in what level and order to display the analyzed items

Report Type Options:

Size Detail – Select to display item information by date, inventory change type and size.

SKU Detail – Select to display item information by date and inventory change type.

SKU Summary – Select to display item information by inventory change type.

Class / Supplier / PO Summary – Select to display the class, supplier, or purchase order information by inventory change type.

Store Summary – Select to display the store information by inventory change type.

Sort By Options:

SKU – Select to order items based on SKU as set in Setup :: Manage SKUs

Class / SKU – Select to order items based on class and SKU as set in Setup :: Manage SKUs

Supplier / SKU – Select to order items based on supplier and SKU as set in Setup :: Manage SKUs

PO – Select to order items based on purchase order and SKU as set in Setup :: Manage SKUs

5. Select the Inventory Change Type options to determine which inventory transactions to analyze

Inventory Change Type Options:

Transfer Out – Select to view items transferred out of the store’s inventory within the selected sales period.

Transfer In – Select to view items transferred into the store’s inventory within the selected sales period.

In-Transit – Select to view items transferred to the store but have not yet been received within the selected sales period.

Purchase Order Receipt – Select to view items received into the store’s inventory on a purchase order within the selected sales period.

Physical Count – Select to view items entered into the store’s inventory via Inventory :: Physical Inventory :: Enter Physical Counts within the selected sales period.

Receipts w/out Purchase Order – Select to view items received into the store’s inventory without a purchase order within the selected sales period.

Return to Supplier – Select to view items removed from the store’s inventory to be returned to the supplier within the selected sales period.

Store Sales (COGS) – Select to view items sold from the store within the selected sales period.

Adjustments – Select to view items reconciled, reduced, or increased based on transfers, or merged within the selected sales period.

Into Non-Sellable – Select to view items moved into the store’s non-sellable inventory within the selected sales period.

From Non-Sellable - Select to view items moved out of the store’s non-sellable inventory within the selected sales period.

Note: Multiple options can be selected to expand or narrow down a user’s report.


REPORT CRITERIA

1. After selecting the report options, use the scroll bar to navigate to the Report Criteria section

Note: To report on all items within a store based on the selections in the Report Options section only, proceed to Step 3.


2. Select and enter the necessary criteria to determine what items to display on the report

Report Criteria Options:

By Store – Enter or search for a store code(s) to determine which store(s) to output.

By Store State – Enter a state’s abbreviation(s) to determine which state(s) to output.

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

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

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

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

By PO# - Enter or search for a purchase order number(s) to determine which purchase order(s) to output.

Product Custom Entries – If set up within the store, enter a custom entry or entries to determine which custom entry to output.

Note: Multiple options can be selected to narrow down a search. If selecting multiple Stores, States, Suppliers, Colors, SKUs, Purchase Orders or Product Custom Entries separate the values by commas. To exclude the selected value(s), select the checkbox next to Exc.

3. Click Run

 


PRINT A RECEIVING LOG
The Print Receiving Logs feature enables retailers to re-print past receiving logs for purchase orders, transfer orders, and receipts without purchase orders. To print a Receiving Log:

1. In the RICS Back Office, go to Reporting :: Print Receiving Logs

2. Enter the necessary criteria to determine what receiving logs to re-print. Multiple options can be selected to narrow down a search

Receiving Log Options:

Purchase Order #: Enter or search for a purchase order number to view any receiving logs associated with that purchase order.

Username: Enter or search for a username to view any receiving logs associated with that user.

Log Type: Enter a log type to view any receiving logs with the selected log type.

Start Date: Enter a start date to view any receiving logs generated on or after this date.

Receiving Log Names: Enter a receiving log name to view any receiving logs with that name.

Transfer Order #: Enter or search for a transfer order number to view any receiving logs associated with that transfer order.

Supplier Code: Enter or search for a supplier code to view any receiving logs associated with that supplier

PO Supplier Codes: Enter or search for a purchase order supplier code to view any receiving logs associated with purchase orders by that supplier.

End Date: Enter an end date to view any receiving logs generated on or before this date.


Note: Select the Page Break Between Orders checkbox to add a page break between each order.

3. Click Search to display the receiving logs below the criteria options based on selected criteria in Step 2

4. Select the receiving log(s) to be re-printed

Note: Click Select All to re-print all displayed receiving logs.

5. Click Print Selected Logs

Have more questions? Submit a request

Comments

Powered by Zendesk