Stock Profile Details - Product dashboard

When you select a warehouse in the Stock Profile Analysis dashboard, you can drill across to the Stock Profile Details – Product dashboard. This dashboard is designed to provide a detailed analysis of incoming and outgoing stock for your selected warehouse and period. You can use this dashboard to analyze breakdowns of incoming and outgoing transactions of your selected warehouse and to see which products have high and low stock change. On this dashboard you can select a product for further analysis at date level on the Stock Transaction dashboard.

This dashboard can answer these business questions:
  • What transactions have transpired for incoming stock on a product level perspective?
  • What transactions have transpired for outgoing stock on a product level perspective?
  • What are the top or bottom products in terms of transaction quantity?

Reports and KPIs

The dashboard contains these reports:
  • Top Transactions by Product
  • Bottom Transactions by Product
  • Incoming Stock Details by Product
  • Outgoing Stock Details by Product

The term by Product is omitted in all the report titles in the dashboard.

This dashboard also contains these KPIs:
  • Manufactured
  • Purchased
  • Sold
  • Used

The KPIs use the Statistics Period Date as the date basis for analysis and the Sum aggregation.

Filters

These standard filters are available:
  • Facility
  • Warehouse (Config. 3)
  • Item (Config. 1)
  • Manufacturing Period (Config. 3)
  • ABC Class – Volume
  • ABC Class – Frequency
  • ABC Class – Contribution
  • ABC Class – Manual
  • Zero Suppression
  • Measure Type (Config. 2)
  • Show N Records

Measure Type and Zero Suppression are mandatory filters.

Drill across

By selecting an item either in the Incoming Stock Details or in the Outgoing Stock Details report, you can drill across to the Stock Transaction dashboard. Filter values are passed to the target dashboard together with the selected item.

Click <<Back to return to the Stock Profile Analysis dashboard.