Skip to content
Enhanced Forecasting Worksheet app iconEnhanced Forecasting WorksheetFeature

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

  1. The planner sets the item, item category, or location filter.
  2. The planner sets the period type and the number of forecast and past periods.
  3. The planner chooses Calculate Forecast for the filtered items.
  4. 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.

Enhanced Forecasting Worksheet app icon

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.

Ask a product question

Product Questions