Home Academy Video tutorials

Forecast months of stock on hand (custom mode)

2:21 min
Forecast months of stock on hand (custom mode)

Learn how to add a calculation in Custom mode that divides stock on hand by the average monthly quantity sold over the last 12 months. You'll define both measures and use offsets so the date range updates automatically, which keeps the column accurate if you save it as a favorite.

Supporting documentation

Phocas product
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

Combine inventory and sales to find dead stock
Analytics (Classic) Analytics (Classic)

Combine inventory and sales to find dead stock

Learn how to identify dead stock by comparing stock on hand value with sales value by product in total mode. Right-click a cell showing zero and filter for an exact value of zero to list items with no sales in the current month, then slice by warehouse and supplier to see where the most dead stock sits. You get the information you need to act on it quickly.

1:46 min
Stop losing stock to silence
Analytics Analytics

Stop losing stock to silence

Learn how to catch dead stock before it ties up cash and warehouse space. You'll filter for products with stock on hand but no sales, sort to find the biggest outliers, and build an inventory turns calculation you can duplicate for other periods. Save any result as a favorite, add it to a dashboard, or create an alert.

3:50 min
Explain the variance, don't just log it
Analytics Analytics

Explain the variance, don't just log it

Learn how to find the cause of cycle count and adjustment variances so they stop recurring. You'll view a stock snapshot over 12 months, switch to variances, and compare product groups to spot the largest discrepancy. Drilling into that item turns unknown shrinkage into a specific pattern or location, such as a bin or user, where your data supports it.

1:38 min
Know your weeks of cover
Analytics Analytics

Know your weeks of cover

Learn how to work out your forward stock position by bringing sales quantity and stock on hand into one grid and building calculations that reference other columns, such as average monthly sales. You can duplicate a calculation to compare other periods, then save, send, or download the report, which updates as ERP data refreshes.

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