Locations dashboard

The Locations dashboard in the Inventory application provides an overview of on-hand storage locations for company products. Use this report to see where stock is stored, identify misplaced items, or view past inventory to see product locations on specific dates.

注釈

The Reporting menu in Inventory is only accessible to users with admin access.

To access the locations report, the Storage Locations feature must be enabled. To do that, go to Inventory app ‣ Configuration ‣ Settings. In the Warehouse section, tick the checkbox for Storage Locations, and click Save. Then, access the locations dashboard by navigating to Inventory app ‣ Reporting ‣ Locations.

レポートを生成

After learning how to navigate the locations dashboard, it can be used to create and share different reports.

A few common reports that can be created using the Locations dashboard are detailed below.

Dead stock report

To get list of expired items, also referred to as dead stock, follow these steps:

  1. Go to Inventory app ‣ Reporting ‣ Locations.

  2. Then, click the (caret down) icon to the right of the Search... bar to reveal a drop-down list of Filters, Group By, and Favorite options.

  3. Enable the Internal Locations and Expiration Alerts option under the Filters section.

The report now displays a list of expired products.

注釈

This report can also be generated from the Lot and Serials Numbers page, accessed by going to Inventory app ‣ Products ‣ Lots/Serial Numbers.

Show a list of products whose expiration dates have exceeded today.

Stranded inventory report

Businesses using multi-step flows in the Inventory or Manufacturing apps, may have stranded items, which are products not in their proper storage locations, due to human error. Use this report to periodically check transfer locations (e.g. WH/Input, WH/Pre-Processing) to ensure items are moved to their intended storage locations, and accurately recorded in the database.

To get a list of items that might be sitting idly in storage, follow these steps:

  1. Go to Inventory app ‣ Reporting ‣ Locations.

  2. In the Search... bar, begin typing the name of the location where products are intended to be moved to, such as WH/Input, or WH/Packing.

  3. Select the Search Location for: [location name] option from the resulting drop-down menu that appears beneath the Search... bar.

    Show search result for the location.

The report now displays a list of products at the transit location.

Example

Searching Input in Location shows a list of products at a WH/Input location.

The list shows 500 quantities of Chicken, which is alarming if not refrigerated soon after reception. The stranded inventory report helps identify items that have been idling in non-storage locations.

Show items stored at a specific location.

Inventory discrepancy report

To generate a report of items that have been moved since the last inventory audit, follow these steps:

  1. Go to Inventory app ‣ Reporting ‣ Locations.

  2. Then, click the (caret down) icon to the right of the Search... bar to reveal a drop-down list of Filters, Group By, and Favorite options.

  3. Enable the Internal Locations and Conflicts option from the Filters section.

  4. The report now displays items whose quantities have changed since the last cycle count.

    Show items from the *Conflicts* filter in the report.
  5. Click the History button to view inventory transfers, including receipts and deliveries, that have occurred since the inventory adjustment.

    Show *Moves History*, showing a delivery that occurred after an inventory adjustment.