Inventory
The Inventory dashboard for Sage 500 gathers stock levels, warehouse distribution, transaction trends, and *material costs in real time. It brings together inventory management, warehouse activity, and stock availability.
How to use the inventory dashboard
- Read stock levels and warehouse efficiency in one overview.
- Follow material flow through the warehouses to identify potential supply chain bottlenecks.
- Examine inventory costs by warehouse to see the average cost of stock in each one.
- Plan inventory from stock levels and transactions to avoid overstocking and stockouts.
- Identify high value transactions by item, for procurement and sales strategy.
Filters
Use the filtering panel at the top of the Financial dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Company: multiple values
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Avg Cost by Warehouse | Pie | Splits average inventory cost across warehouses. |
| Qty on Hand by Warehouse | Funnel | Displays quantity on hand by warehouse. |
| Inventory Transactions Chart | Combination | Tracks sales amount, transaction amount, and material movement over time. |
| Qty by Company | Horizontal Bar | Compares quantity on hand by company. |
| Top 5 Items - Qty on Hand | Doughnut | Ranks the five items by quantity on hand. |
| Top 5 Items by Transaction Amount | Pie | Lists the five items with the highest transaction amount. |