Skip to content
Enhanced Forecasting Worksheet app iconEnhanced Forecasting WorksheetFeature

Sales History Check for Microsoft Dynamics 365 Business Central

A forecast built on too little history is a guess, and it is easy to miss which items had almost no sales to work from.

Enhanced Forecasting Worksheet flags items that do not have enough posted sales history to forecast, and offers to use the history it found when there is less than the planner asked for.

How Sales history check works in Enhanced Forecasting Worksheet

  1. The planner sets the number of past periods and calculates the forecast.
  2. If less history exists than requested, Enhanced Forecasting Worksheet asks whether to use the history found.
  3. Items without enough posted sales history are flagged.
  4. The planner forecasts the rest, and plans flagged items another way or imports more history.

Key capabilities

Enough history to forecast

Forecasts are built from posted sales-type item ledger entries. Items without enough of them are flagged.

Shorter history, your call

If you ask for 18 past periods and only 15 exist, Enhanced Forecasting Worksheet asks whether to use the 15 instead, so empty periods do not skew the result.

New items and locations

A new item, or an item at a new location, has no sales history yet, so it cannot be forecast until history exists.

Bringing in older history

Companies that moved to Business Central recently can import sales history from their previous system with Import Export PowerTool. This is a completely free app from Insight Works for Business Central.

Details that matter on the floor

Honest about the input

Flagging thin history keeps a planner from treating a weak forecast as a strong one.

A way forward for new systems

Missing history from a previous system does not have to block forecasting; it can be imported.

Who uses Sales history check

Supply chain planners

Know which items the forecast does not cover.

Inventory managers

Plan new or slow items by other means until history builds up.

Business Central consultants

Load sales history from a previous system so forecasting can start.

Questions about Sales history check

How much sales history does Business Central need to forecast?

At least as many past periods of posted sales history as the periods you want to forecast. More history gives a better forecast, and 12 months is a good starting point. Enhanced Forecasting Worksheet flags items that do not have enough, and offers to use a shorter history when less exists than requested.

We just moved to Business Central. Can we still forecast?

Yes, if you bring your sales history across. Import Export PowerTool can import history from a previous system, after which Enhanced Forecasting Worksheet can forecast from it.

What happens to items that cannot be forecast?

They are flagged. Plan them another way, for example by reviewing usage with Item Planning Review, until enough history exists.

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 Sales history check?

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