Forecast by Item, Category, or Location for Microsoft Dynamics 365 Business Central
Forecasting every item in the company at once rarely helps. Planners work by product family or warehouse, and a forecast that mixes everything is hard to review.
Enhanced Forecasting Worksheet filters the forecast by item, item category, or location, so each run covers the group of items a planner is responsible for.
How Forecast by item, category, or location works in Enhanced Forecasting Worksheet
- The planner sets the item, item category, or location filter.
- The planner sets the period type and the number of forecast and past periods.
- The planner chooses Calculate Forecast for the filtered items.
- The planner reviews the results, then changes the filter for the next group.
Key capabilities
Item filter
Forecast a single item or a set of items when only a few need attention.
Item category
Forecast a whole category, such as one product line, in one run.
Item location
Set a location to forecast demand at that location only, or leave it blank to forecast across all locations.
Stockkeeping units at several locations
Companies that use several locations with stockkeeping units forecast one location at a time.
Pairs with period settings
Filters work with the period type and number of periods to define each run.
See Forecast by item, category, or location on screen
Real screens from Enhanced Forecasting Worksheet, shown with demo data.
Details that matter on the floor
One location per run where it matters
For multi-location companies with stockkeeping units, forecasting location by location keeps results and planning updates tied to the right stockkeeping unit.
Reviewable batches
A category-sized run produces a list a planner can actually review before sending it anywhere.
Who uses Forecast by item, category, or location
Inventory managers
Forecast the categories they manage.
Supply chain planners
Forecast each location separately.
Purchasing managers
Forecast the items bought from one source as a group.
Questions about Forecast by item, category, or location
Can I forecast by item category in Business Central?
Yes, with Enhanced Forecasting Worksheet. Set the Item Category filter and calculate the forecast for every item in that category in one run.
Can I forecast by location?
Yes. Set the Item Location filter to forecast one location. Companies that use several locations with stockkeeping units forecast one location at a time.
Can I filter on other fields?
The worksheet filters by item, item category, and location. Developers can use the events Insight Works provides to filter on other criteria.
Related Enhanced Forecasting Worksheet features
All Enhanced Forecasting Worksheet features →Part of Enhanced Forecasting Worksheet
Precise, customizable inventory forecasting to prevent stockouts and optimize stock levels.
Have a question about Forecast by item, category, or location?
Send us a note and the Enhanced Forecasting Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
