WMS - Inventory Dashboard

History and Stock Reports of Particular SKUs

Notes: Filter Past dates e.g. Yesterday, Between (choose specific dates), etc.

Create date - ASN received from client (Date upload of Receipts)

 

BI-inventoryDASH.gif

Historic Stock Report (By At End Of Date)

Provides the Available Stock Quantity and location of a specific Product Code/SKU At the end of the Day.

Stock Inventory Summary

Provides the quantity breakdown of stock location of a specific Product Code/SKU within specified dates.

Free

Available Stock/ On hand

Free Pending

Available Stock for confirmation

Query

Items under investigation 

Query Pending

Items under investigation for confirmation

To Put Away

Stock that has been received into a bin box but not yet put away into a location.

Free Allocated

Stock for confirmed dispatch requests in an "Available Stock" location ready to be picked.

Picked

Order has been picked in full and is ready to be packed

To Dispatch

Order has been packed in full, documentation created, shipper labelled applied and is in the Dispatch area ready to load on to vehicle.

Quarantine

Stocks put in isolation due to damage, missing parts, etc. 

QC

Product that is within "Quality Control" 

Stock Summary Detail (Sum of Carton Qty by Location)

Shows details of Total quantity of each Product by Location

Stock Adjustments - Increase (By Create Date)

List of stock adjustments performed by the DC with Increased qty, showing adjustment number and reason.

Stock Adjustments - Decrease (By Create Date)

List of stock adjustments performed by the DC with Decreased qty, showing adjustment number and reason.

Complete Count Adjustments (By Confirmed Date)

A Count Adjustment is created when a recount record matches last count quantity and does not match system quantity.

Provides Positive or Negative Count. Quantity and Count complete date.

Aged Inventory Report

Shows how long each Products/item of inventory had activity since Receipt Date and Last dispatch date.

Product Master Core Fields (By Create Date)

Product List Report showing SKUs Properties and Attributes by Create Date