Know your weeks of cover
Bring sales, purchasing, and stock information together to get a clearer view of your inventory position. See how to add measures such as sales quantity and stock on hand, then use those values to create calculations directly in the grid. You’ll also see how to build measures such as weeks of cover and stock turnover, and adapt the calculations for different reporting periods. Because the results use the data already in your analysis, they update as new ERP data becomes available.
Supporting documentation
Analytics 
Related video tutorials
Analytics Stop losing stock to silence
Identify dead stock and slow-moving inventory before it ties up more cash and warehouse space. See how to combine sales and stock information in the same analysis, then filter for products with no sales activity but stock still on hand. You can sort the results to find your biggest inventory concerns and save the analysis as a favorite, add it to a dashboard, or create an alert. You'll also see how to build custom inventory calculations using sales and stock measures, then compare results across different reporting periods. This gives you a clearer picture of stock movement and helps you make informed purchasing and inventory decisions.
Analytics See margin next to every sale
Look beyond sales revenue to understand the profitability behind your results. See how to add profit and margin alongside sales so you can compare revenue and profitability in the same analysis. You can identify periods where margin is falling, move into customer-level detail, and sort the results to find the accounts contributing most to the change. From there, drill into the underlying transactions to identify low-margin or unprofitable sales and review the discounts or individual transactions behind them.
Analytics Make OTIF a number you manage
Keep track of on-time, in-full (OTIF) delivery performance so you can identify service issues before they affect customer relationships. See how to bring OTIF measures into your analysis and review performance trends across a rolling twelve-month period. You can investigate months where delivery performance falls, switch to customer-level analysis, and use filters to identify the lowest-performing customers. From there, explore product categories, individual products, and suppliers to understand what's contributing to missed delivery targets. This helps you identify recurring problems, focus on the areas that need attention, and take action to improve delivery reliability.
Analytics Explain the variance, don't just log it
Get to the bottom of inventory discrepancies instead of repeatedly writing off unexplained variances. See how to use stock snapshots and historical inventory data to investigate changes over a rolling twelve-month period. By switching between data streams, variance analysis, and product dimensions, you can identify where the largest differences occur and drill into the underlying detail. Depending on the data available, you can investigate discrepancies by product, warehouse location, bin, or user. This helps you uncover patterns behind stock variances, understand potential causes of shrinkage, and address recurring inventory issues before they continue costing your business money.
