...
Customer Level
Customers/Product Level
...
Combination of both if Customer Level (Targets) and Product Level (Forecasts)
Targets - These are entered at the start of the year and can not be modified there after.
...
If the system is set to Customer Only Level there is also a grid showing the product level sales totals for the selected Reporting Upto Up to Accounting month.
...
If the system is Customer/Product Level this grid also shows if your up / down on your current Target and Forecasts based on the sales invoices values for each product.
...
For Customer level only Import Format is as follows if you want to enter one amount for the whole year and the import will automatically divide the amount across all 12 months.
Customer_ID
Forecast_Year
Target_Sales_Value
Forecast_Sales_Value
For Customer level only having separate Targets and Forecasts for each month, this has two import formats:
Format 1 - An Excel row one per customer and month.
Customer_ID
Forecast_Date (one record per accounting month)
Target_Sales_Value
Forecast_Sales_Value
For Customer level only Import Format is as follows if you want to enter one amount for the whole year and the import will automatically divide the amount across all 12 monthsFormat 2 - An Excel row one per customer and the 12 Target and Forecasts months as columns.
Customer_ID
Forecast_Year
Target_Period1
Target_Period2
Target_Period3
Target_Sales_ValueForecast_Sales_Value_Period4
Target_Period5
Target_Period6
Target_Period7
Target_Period8
Target_Period9
Target_Period10
Target_Period11
Target_Period12
Forecast_Period1
Forecast_Period2
Forecast_Period3
Forecast_Period4
Forecast_Period5
Forecast_Period6
Forecast_Period7
Forecast_Period8
Forecast_Period9
Forecast_Period10
Forecast_Period11
Forecast_Period12
For Customer/Product Level Import Format is as follows:
Customer_ID
Product_ID
Forecast_Date (one record per accounting month)
Target_Qty
Forecast_Qty
Sales_Price
Cost_Price
Please note: The Target_Sales_Value and Forecast_Sales_Value are automatically calculated based on the Qty multiplies by the Sales_Price.
Imports are from the first sheet in the Excel document, usually this is called Sheet1
Importing will update existing records if they already exist otherwise they are added.
There is an import preview data-grid before finally committed the import.
There is also a Delete All option that will clear and remove all records (use with care)