You can easily modify the forecast in Excel before importing it again

With Flexible Forecast it is easy to work with forecast in Excel
Video 3/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

The whole idea of exporting forecast to Excel from Business Central is, of course, the ability to modify the Excel sheet so you can import it afterwards.

This is what happens in the video

So once you have opened the Excel sheet, you can modify the column new column, which is the information that would be imported. You can do this either by the multiplication field up here and you can multiply by whatever factor you like and then after that you can override it and modify however you want all the different forecasts entries in here. So this way it is possible to create forecast bills based on last year’s sales, new forecast, etc, and then modify it directly in the Excel sheet before importing it.