Back

The views Item per Period and Forecast per Dimension is updated automatically when you open them

How to work with Forecasts
Video 8/8
Play
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An intermediate video requires some previous experience with Business Central, but it is still easily accessible to most people. Intermediate Videos with the tag "Commonly Used" describes the functionality that is used by most companies. Commonly Used This video includes functionality from the app "Flexible Forecast" which is available at Microsoft AppSource. Click to visit AppSource. Flexible Forecast

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Presenter: Sune Lohse, Chief Strategy Officer

When you work with demand forecasting in Business Central, two of the forecast views recalculate automatically when you open them, while the third does not. Knowing which is which prevents you from acting on outdated numbers.

The forecast per period view and the forecast per dimension view update automatically every time you enter them. The view where you enter many items in one period does not update automatically. You have to update it manually.

The manual update on that third view exists for performance reasons. If it recalculated every time you opened it, a forecast with 5,000 or 10,000 items would take too long to load.

Forecast per period updates automatically

When you open the forecast per period, it calculates and updates the data right away. For example, in the month of May you might see 60 on inventory. If you add another 40, leave the view, and enter it again, the view recalculates automatically and shows 100.

Forecast per dimension updates automatically

The forecast per dimension behaves the same way. It calculates when you open it. If you added 40 to item number 1000, that view already includes the change when you open it. Updating the forecast afterwards will not change anything, because the numbers are already current.

Forecast per item in one period must be updated manually

The view where you enter many items in one period is the exception. It does not update automatically. For example, the first line on item 1000 might show 520. When you update the forecast, it changes to 516, reflecting the actual current data.

The reason is performance. If this view recalculated every time you removed a filter, left the page, and re-entered it, a forecast with 5,000 or 10,000 items would never finish loading. The calculation would run again and again on a large dataset, making the page unusable. To avoid this heavy load, you update this view manually.

What to do in practice

Remember that the forecast per period and the forecast per dimension always show current data when you open them. The view with many items in one period shows the last calculated values until you trigger an update yourself. Before you rely on the numbers in that view, run the update so you are working with the correct figures.

Q&A

Which forecast views in Business Central update automatically?

The forecast per period and the forecast per dimension both recalculate automatically every time you open them.

Why does the forecast with many items in one period not update automatically?

For performance reasons. Recalculating every time you enter the page would make a forecast with 5,000 or 10,000 items extremely slow to load, so you update this view manually instead.

How do I get current numbers in the forecast per item in one period view?

Run the update manually. The view keeps showing the last calculated values until you trigger an update, after which it reflects the actual current data.

475010027-GG5UwD6ejTU-ENG20090426