Accolent ERP includes several KPIs (Key Performance Indicators) that deliver graphical visualization dashboards for important performance metrics. All the data is summarized as of the end-of-business on the prior day and cached to improve performance. The warehouse dashboard shows for a particular warehouse, the (1) sales for the MTD compared to Last MTD, (2) total shipments pending (3) total POs pending (4) warehouse sales for the current partial month and the previous 11 full calendar months (5) top 10 pending shipments by dollar value and (6) top 10 Open POs by PO amount.
General Definitions
- All KPIs are presented as of end-of-day for the previous business day; this is the date of the dashboard shown in parentheses in the title of the dashboard
- All sales are in dollars (NOT qty) unless specified otherwise
- For graphs, sales are presented in $000s
- All sales values are expressed as the sum of the extended price (i.e., excluding freight, labor and sales tax) in order to be able to be tied back to product sales
- MTD means “month to date” and is measured from the beginning of current calendar month to date of the dashboard
- Last MTD means “last month to date” and is measured from the beginning of the previous calendar month to the same day as the date of the dashboard in the previous month
- Shipments Pending for the warehouse are defined as order in shipping status
- Top 10 Pending Shipments for the warehouse means the 10 highest orders in shipping status
- POs Pending for the warehouse means POs that have been submitted but have not yet been received
- Top 10 Open POs for the warehouse means the 10 highest POs Pending by PO amount
- All graphs showing 12 months show the current partial month and the prior 11 full calendar months
Warehouse KPI
- First select the warehouse and click Submit
- This is the Warehouse KPI
Dashboard Controls
- The icons at the top right-hand side of all dashboards provide options to refresh the dashboard, to edit the dashboard, and to filter the dashboard
- Do not edit the dashboard unless you are familiar with using the report designer
Element Controls
- Each dashboard consists of several graphical elements combined into a dashboard
- Rolling the mouse over the top right-hand side of any element provides several additional options
- The up/down arrows provide some options to sort the data
- The full screen icon allows the element to be viewed on a full screen
- The search icon provides the data being visualized
- The download icon gives several options to save the element
- The eye icon allows you to select which fields in a grid to display
Graphs
- All graphs have a mouse rollover that shows the actual values (in $000s)
Modifying the Dashboard
- Contact ADS Solutions if you want help modifying the sales dashboard or creating new custom dashboards
- Any standard report can be turned into a dashboard or dashboard element