Forecast months of stock on hand (custom mode)

2:18 min
Here we show you how to build a stock report that tells you many months' worth of stock is left based on the average quantity sold compared with stock on hand. We do this by adding a new column containing a couple of simple calculations.

Supporting documentation

David Chambers
Presented by David Chambers
Solutions Consultant
User level
Phocas Software help and support
Help & support

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

Get support

Related video tutorials

Add a new column to the grid to show target performance

Add a new column to the grid to show target performance

In this video you'll learn how to add a column to the Phocas grid to show a variance between sales and budget, to see how sales reps are tracking against their budget. We do this using custom mode.
1:49 min
Customize column formatting

Customize column formatting

This video shows you how to format the measures in a particular column, so the data appears just how you want to see it. Use custom mode to add dollar signs to your data - in just one column on the grid, or as many as you like.
1:00 min
Generate a budget based on previous sales

Generate a budget based on previous sales

Learn how to use custom mode to build next years budget based on the last two years sales. And take the forecasting further with a look at individual reps and their product classes.
2:26 min
Copy and paste 

Copy and paste 

See to easy it is to copy data out of the Phocas grid into another application. In this video we show you how to copy and paste into Excel.
0:40 min
Phocas Software

Let’s talk

Are you interested in becoming a Phocas partner?

Phocas Software

Contact us

Fill in the form below, and we will get back to you as soon as possible.

Phocas Software