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 build a stock report that calculates the months of stock remaining, based on the average quantity sold and stock on hand. This is done by adding a new column with a few simple calculations.

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

Combine inventory and sales to find dead stock
Analytics Analytics

Combine inventory and sales to find dead stock

This video takes you into an inventory database. Learn how to combine inventory and sales values to quickly establish what dead stock is on the shelves.
1:46 min
Take a tour of Flex Modes
Flex Modes Flex Modes

Take a tour of Flex Modes

Learn how to explore your data with Flex Modes, and see how the different modes and features give you greater flexibility in how you view, compare, and analyze your information.

 

2:29 min
Use custom mode to show target performance
Analytics Analytics

Use custom mode to show target performance

Learn how to use custom mode to add columns to the Phocas grid to compare sales and budget, track sales rep performance, and customize how your data is displayed.
5:06 min
Matrix Variance and Matrix Share mode
Analytics Analytics

Matrix Variance and Matrix Share mode

Learn how to use Matrix Variance mode to compare data across different periods by adding columns for the previous period and variance—perfect for spotting trends month-over-month or year-over-year. You'll also see how Matrix Share mode transforms your data into percentages, making it easy to analyze ratios, like the share of Product X versus Product Y.
3:13 min
NewSee the latest features, improvements and what's new in productView product updates