You can export forecast to Excel based on previous forecast, last years forecast or sales history

With Flexible Forecast it is easy to work with forecast in Excel
Video 1/4
  • 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 The "Whys" focus on how your business needs can be supported with the erp-solution. The topic is visualized - not demonstrated. The Whys 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.

Open Playlist
Presenter: Sune Lohse, Chief Strategy Officer

When you export forecast to Excel, it is possible to choose to export to new forecasts based on last year sales, current forecast, or last year’s forecast.

This is what happens in the video

This means if you select last year sales, the new suggested forecast will be based on your sales last year.

So if we open the Excel sheet here, you can see the columns for one period here and the new forecast area is based on quantity sold last year that I selected which means when I use the forecast factor up here and multiply for instance by 1.5, I can see here the new forecast is one and a half times last year sales.

This way, it is possible to base new forecast on different columns.