How to Analyze Non-Sellable Inventory

The RICS non-sellable inventory features enables retailers to track and analyze damaged or otherwise compromised inventory through the RICS Back Office. To assist a retailer with tracking and analyzing these transactions, RICS has several features and reports.

This document is a resource for retailers to understand how to analyze non-sellable inventory using:
Generate a Non-Sellable Packing Slip
Generate a Non-Sellable Inventory Report
Export a Non-Sellable Inventory Report

 


GENERATE A NON-SELLABLE PACKING SLIP
The RICS Non-Sellable Packing Slip enables retailers to create a packing slip to include with the damaged goods being sent back to the manufacturer.


REPORT OPTIONS TAB

1. In the RICS Back Office, go to Reporting :: Non-Sellable Inventory :: Non-Sellable Packing Slip from the Store level.

2. Use the Batch Completed, Received and Batch Created dropdown menus to select the date or date ranges to determine what periods to analyze

Options:

Batch complete date range – Select to display items analyzed based on when a batch is completed.

Received date range – Select to display items analyzed based on when a batch is received.

Batch created date range – Select to display items analyzed based on when a batch is created.

 

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.

2. Select and enter the necessary criteria to determine which packing slips to output. Multiple criteria can be selected to narrow down a user’s search.

Options:

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

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

By Batch Name – Enter a Non-Sellable Batch Name(s) to determine which item(s) to output.

By RMA Number – Enter a RMA Number(s) to determine which item(s) to output.

By Non-Sellable Supplier – Enter a Supplier Code(s) to determine which item(s) to output.

By Batch Type – Select the checkbox for the corresponding batch type to determine which item(s) to output.

By Return Code – Enter a Return Code(s) to determine which item(s) to output.

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

 
PRINTING OPTIONS TAB

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

2. Select the necessary Also Print options to determine additional information to display on a report

Also Print Options:

Print as Columns – Select to display the packing slip in columns.

Class – Select to display class on the packing slip.

3. Click Add Job and Run

 


GENERATE A NON-SELLABLE INVENTORY REPORT
The RICS Non-Sellable Inventory Report enables retailers the ability to report on items added to non-sellable inventory during a selected period of time.


REPORT OPTIONS TAB

1. In the RICS Back Office, go to Reporting :: Non-Sellable Inventory :: Non-Sellable Inventory from the Store level.

2. Use the Report Type dropdown menu to determine how to display the results

Options:

Store – Select to display result totals based on store.

Supplier – Select to display result totals based on supplier.

Class – Select to display result totals based on class.

Batch – Select to display result totals based on batch.

SKU – Select to display result totals based on SKU.

SKU by Supplier – Select to display result totals based on SKU by supplier.

SKU by Class – Select to display result totals based on SKU by class.

SKU by Batch – Select to display result totals based on SKU by batch.

3. Select or enter the necessary Non-Sellable options to determine which items to display

Options:

Include Return Codes – Select to include return codes.

Include items not on a batch – Select to include items not on a batch.

Include items on an uncompleted batch – Select to include items on an uncompleted batch.

Include items on a completed batch – Select to include items on a completed batch.

4. Use the Batch Completed, Received and Batch Created dropdown menus to select the date or date ranges to determine what items to display

Options:

Batch complete date range – Select to display items on a completed batch during the selected period.

Received date range – Select to display items added to non-sellable during the selected period.

Batch created date range – Select to display items on a batch created during the selected period.

5. If necessary, enter the Class Depth limit in the field provided.

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 Step 3.

2. Select and enter the necessary criteria to determine which non-sellable inventory items to output. Multiple criteria can be selected to narrow down a user’s search.

Options:

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.

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

By Batch Name – Enter a Non-Sellable Batch Name(s) to determine which item(s) to output.

By RMA Number – Enter a RMA Number(s) to determine which item(s) to output.

By Non-Sellable Supplier – Enter a Supplier Code(s) to determine which item(s) to output.

By Batch Type – Select the checkbox for the corresponding batch type to determine which item(s) to output.

By Return Code – Enter a Return Code(s) to determine which item(s) to output.

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

3. Click Add Job and Run

 


EXPORT A NON-SELLABLE INVENTORY REPORT
The RICS Export Non-Sellable Inventory Report enables retailers the ability to export items added to non-sellable inventory during a selected period of time.

1. In the RICS Back Office, go to Reporting :: Non-Sellable Inventory :: Export Non-Sellable Inventory from the Store level.

2. Select or enter the necessary Non-Sellable options to determine which items to display

Options:

Include items not on a batch – Select to include items not on a batch.

Include items on an uncompleted batch – Select to include items on an uncompleted batch.

Include items on a completed batch – Select to include items on a completed batch.

3. Use the Batch Completed, Received and Batch Created dropdown menus to select the date or date ranges to determine what items to display

Options:

Batch complete date range – Select to display items on a completed batch during the selected period.

Received date range – Select to display items added to non-sellable during the selected period.

Batch created date range – Select to display items on a batch created during the selected period.

4. If necessary, enter the Class Depth limit in the field provided.

 

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 Step 3.

2. Select and enter the necessary criteria to determine which non-sellable inventory items to export. Multiple criteria can be selected to narrow down a user’s search.

Options:

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.

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

By Batch Name – Enter a Non-Sellable Batch Name(s) to determine which item(s) to output.

By RMA Number – Enter a RMA Number(s) to determine which item(s) to output.

By Non-Sellable Supplier – Enter a Supplier Code(s) to determine which item(s) to output.

By Batch Type – Select the checkbox for the corresponding batch type to determine which item(s) to output.

By Return Code – Enter a Return Code(s) to determine which item(s) to output.

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

3. Click Add Job and Run

Have more questions? Submit a request

Comments

Powered by Zendesk