Home Academy Video tutorials

Stop losing stock to silence

3:50 min
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.

Supporting documentation

Phocas product Analytics Analytics
Category
Phocas Software help and support
Help & support

Have questions or need to report an issue with a Phocas product?

Get support

Related video tutorials

Know your weeks of cover
Analytics Analytics

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.

3:52 min
Use alerts
Analytics Analytics

Use alerts

Learn how to monitor important results with alerts. You'll set the metric and red, yellow, and green thresholds, choose when you're notified, and set up email delivery. You'll also test an alert before creating it, subscribe to shared alerts, and restore deleted alerts within 45 days.

2:56 min
See margin next to every sale
Analytics 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.

2:02 min
Get your own answer in seconds
Analytics Analytics

Get your own answer in seconds

Ask questions about your data in plain language and get answers directly in Workspaces. See how conversational AI can return a chart or grid, highlight relevant figures, and provide observations that help explain the result. You can continue the analysis by asking follow-up questions or opening the result for a closer look. When you have what you need, you can save it as a favorite, add it to a dashboard, or export it to share with your team.

2:05 min
NewSee the latest features, improvements and what's new in productView product updates