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.  To generate a Non-Sellable Packing Slip:

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

2. Type Non-Sellable Packing Slip in the search box or navigate to Non-Sellable Inventory :: Non-Sellable Packing Slip 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 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

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 which packing slips to output

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

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

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

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 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. To generate a Non-Sellable Inventory Report:

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

2. Type Non-Sellable Inventory in the search box or navigate to Non-Sellable Inventory :: Non-Sellable Inventory 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 Report Type dropdown menu to determine how to display the results

Report Type 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

Non-Sellable 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

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

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

Store Options:

Separate Stores – Select to display non-sellable inventory by individual store.

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

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 selection only, proceed to the Step 3.

2. Select and enter the necessary criteria to determine which non-sellable inventory items to output

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.

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: Multiple criteria can be selected to narrow down a user’s search. If selecting multiple Stores, States, 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 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.  To generate an Export Non-Sellable Inventory:

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

2. Type Export Non-Sellable Inventory in the search box or navigate to Non-Sellable Inventory :: Export Non-Sellable Inventory 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. Select or enter the necessary Non-Sellable options to determine which items to display

Non-Sellable 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

Batch 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

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 selections in the Report Options section only, proceed to Step 3.

2. Select and enter the necessary criteria to determine which non-sellable inventory items to export

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.

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

Have more questions? Submit a request

Comments

Powered by Zendesk