Please add a place to enter forecasted sales quantities, which could then be printed on the 'Sales Analysys' report so that you can easily see how your actual sales compare to your sales forecast at any point in time.
The 'Sales Analysis' report currently shows sales by item for Period To Date, Prior Year Period, Year To Date, & Prior Year YTD. This is good, but what is missing from this report is forecast data, both for the current Month-To-Date and the current Year-To-Date. Ideally you would have the option to enter & report the sales forecast data by item, by sales territory, and by month.
by: Ralph A. | over a year ago | 4 - Reports / BI
Comments
We enter our forecasts using the demand adjustment for a future period in the replenishment module. The problem is, you can only enter one SKU at a time. We have created an Excel program to update 52 periods and multiple SKUs at once.
Where do I get more info re: "Excel program to update 52 periods and multiple SKUs at once"? chuck.zuleger@schencksc.com
If you have MRP or Replenishment you can do this with Demand Adjustment but there is no import. It is not likely that someone will want to key monthly sales forecast with out an import from excel. It is also very limited.
Rich
DSG, Inc.
Sage Inventory Advisor provides forecasting capabilities in an online, drag and drop interface.