Lost items can hurt your business. When items are missing in your store, you lose investment dollars and then spend more money to replace them.

While you can address each loss individually, grouping losses by a location or department may expose larger trends. For example, you may find that losses are concentrated in certain areas of your store.

The PaladinNsightLoss Experience Tool offers this larger perspective along with the lost item details.

The tool informs you about losses in three different ways:

  • Meter: Shows the total cost of lost items in investment dollars.
  • Viewer: Summarizes the financial impact of lost items by department or location.
  • Details: Gives details about the lost items in a department or location.
Loss Experience Tool Overview

The Loss Experience Tool is in the Inventory module in the Inventory tab. It is available to managers and designated employees.

This tool requires accurate stock-on-hand SOH values. SOH is recorded when you review inventory. To find out more about inventory reviews, read Take charge of your inventory investment with the Investment Review Tool.

Loss Experience Meter – A bird’s eye view

The Loss Experience Meter shows the total investment dollar loss from items that disappeared in the last 30 days.

Loss experience meter

Monitor this meter for unexpected changes. A sudden increase in your investment dollar loss may require an investigation.

Loss Experience Viewer – Catching larger trends

The Loss Experience Viewer shows losses by department or location. Click the magnifying glass to open it.

Open the Lost Experience Viewer

The interactive list shows you where your losses are occurring. You can set the time period and sort the list by investment dollars lost and other options.

Loss Experience Viewer

Use the following options to customize your view.

View option Values Description
Order By
  • Location [default]
  • Department
Show losses by location or department.
Display By
  • # of items [default]
  • $Loss
Show losses as a number of items or investment $ loss.
Within the last __ Days Number of days backward in time [default: 30] Show losses for the specified time.
Limit to Supplier List of suppliers [default: 0-None] Show losses for the selected supplier only.
Sort by column values n/a Click any column title to sort the list by those column values.

To open this data in Excel, click the Excel Report button. (Microsoft 2007 or later is required.)

Tip Investigate the departments or locations that are losing the most money first. To display them at the top of the list, follow these steps:

  1. In the Order By: options, select $Loss.
  2. Click the column title $Loss/Gain Last 30 days until the the largest dollar loss appears on top.

Loss Experience Details – An item-by-item account of your losses

To see the lost item details for a location or department, click the magnifying glass to open the Loss Experience Details view.

Opening Loss Experience Details

Use these details to investigate lost items or to identify trends.

Loss Experience Details

To open this list in Excel, click the Excel Report button. You can print or save the lost item list. (Microsoft 2007 or later is required.)

Investigating lost items is worth your time

There are many reasons that items disappear, including misplaced inventory, incorrect SOH counts, and theft. These losses hurt your business. When you use the Loss Experience Tool regularly, you minimize the financial impact and increase your awareness of lost items.

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 3/20/18