Skip to main content

Damaged Items Report

Understand the Damaged Items report: tracking items that need repair or are unrepairable/lost, how grouping changes the columns, and what it automatically leaves out.

Written by Hrant Minasyan

The Damaged Items report helps you track inventory that has been damaged — items that need repair, and items that are unrepairable or lost — over a date range, along with the related repair or replacement fees.


Where to Find It

Reports → Operations & Logistics → Damaged Items


What This Report Shows

  • Product name

  • Quantity damaged

  • Date(s) of damage

  • Transaction number and Fee — these two columns appear only when you group by Transaction (see below)


Filters You Can Apply

  • Date range — the period you want to review. A single report can cover up to about 13 months at a time. To review a longer period, run several consecutive date ranges and combine the exported files in Excel.

  • Location — if your company has more than one location, you can limit results to specific locations. (Single-location accounts won't see this filter.)

  • Repair status — choose Needs Repair (items currently set aside awaiting repair) or Unrepairable or Lost (items written off)


Choosing How Results Are Grouped (Type)

The Type filter controls how results are grouped — and it changes which columns you see:

  • Product name — one row per product, showing the product, quantity damaged, and date(s).

  • Category — one row per category, showing the category, quantity damaged, and date(s).

  • Transaction — one row per item per order, and adds the Transaction number and Fee columns so you can see which order the damage came from and what was charged.

Note: the Transaction number and Fee columns only appear when Type is set to Transaction.


⚠️ What This Report Already Filters Out

This report pulls from two different places depending on the Repair status you choose, and each has built-in behavior:

  • Only currently-active damaged items are shown. Once a damaged item has been repaired and returned to stock (or otherwise resolved), it drops off the report.

  • The two views never mix. You see either items that need repair or unrepairable/lost items — never both at once. Switch the Repair status filter to see the other set.

  • The date is matched to the relevant moment. For Needs Repair, your date range matches when the item was set aside for repair (including items whose repair period overlaps your range). For Unrepairable or Lost, it matches the date the item was marked broken or lost.


How to Read the Results

Quantities are totaled within each group (by product, category, or transaction), and a single row can cover multiple damage dates, which are listed together. When grouped by Transaction, the Fee column totals the repair or replacement fees recorded on that order.


Permissions & Visibility

You will only see data for the locations you have access to.


Exporting

You can export the report to Excel, CSV, or PDF. Larger reports are generated in the background — you'll be notified when the file is ready to download.


Need Help?

If you have questions about the Damaged Items report, contact us at [email protected].

Did this answer your question?