Stock Value & Forecast

You can find these config files at: System > Configuration > Magmodules > Stock Forecast.

Magento Stock Forecast

1. General Settings:
Configure the Stock Forecast however you want with the settings below.

Use Cron.
Select if you wish to use the cronjob to keep the stock forecasting automatically.

Decimal Seperator.
Select how you want to seperate the decimals shown in the Forecast.

Number of decimals - Sales.
Select the number of decimals you want to show for the sales table.

Number of decimals - Stock.
Select the number of decimals you want to show for the stock table.

Grid Fields
Select which data you want to show in the grid.

Cost Source.
Select the attribute that you use for the Costs to calculate the right Cost in the Forecast.

Optimal Stock. 
Optimal Stock.
Select how you wish to calculate the optimal stock, based on the previous sales or based on an attribute.

If based on sales: Based on Sales.
Select the time period for calculating the optimal stock.

If based on sales: Based on attribute.
Select the attribute for calculating the optimal stock.

Divide by.
Select a number to divide it by.

Multiply with.
Select if you wish to multiply the stock number.

Sales last 30 days. 
Generate. 
Select if you wish to calculate the sales based on this period. 

Sales last 90 days. 
Generate. 
Select if you wish to calculate the sales based on this period.

Normalize to month.
Select if you wish to normalize this number to month.

Sales last Year. 
Generate. 
Select if you wish to calculate the sales based on this period.

Normalize to month.
Select if you wish to normalize this number to month.

Sales +30 days last year. 

Generate. 
Select if you wish to calculate the sales based on this period.

Sales +90 days last year. 
Generate. 
Select if you wish to calculate the sales based on this period.

Normalize to month.
Select if you wish to normalize this number to month.

Magento Stock Forecast

1.1. General Settings - Custom Fields
You may use this functionality to exclude the selected attribute from the rapport. 

Generate.
Set to "yes" to enable this custom field.

Days.
Select the time in history of future in days.

Type.
Last year - Calculates statistics based on future days
Current year - Calculates the statistics on the basis of the past days

Magento Stock Forecast

2. Stock by Supplier:
Select the attribute you are using for the Supplier.

Magento Stock Forecast

3. Exclude:
You may use this functionality to exclude the selected attribute from the rapport. 

Use Exclude Function.
Set to "yes" to enable the exclude function.

Attribute.
If enabled, select the attribute that you wish to exclude.