Mass updating New Forecast with a factor in the Excel Sheet

Import Forecast from Excel
Video 2/3
  • 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 Watch the "basic" videos to take the tour of the main processes of Business Central. This is the basic, need-to-use functionality. The Basics 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

Once you have exported your forecast to Excel, there’s a formula in all the new forecast columns and this formula will be a multiplication of field B2 and the information or the quantity in the column that you have selected. So in this scenario, I have selected the column current forecast and therefore, it multiplies by 230 and with this, you can mass update the forecast if you want to take last year’s forecast and you think you’re growing 25%, you could just add 25% to all of your forecast entries, all the entries.

This is what happens in the video

So this is one way of updating your forecast and of course you can use all the intelligence you want in AI functionality or data or consolidated Excel sheet or whatever to grab data into this new forecast column. When you import, it will just use the new forecast column.