A run through the Option fields on the “Export to Excel” request page

Export Forecast to Excel
Video 2/6
  • 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

Let’s take a run through the field where you export to Excel on the tap options.

This is what happens in the video

First of all, you enter the starting date, meaning the first date you want the columns to be built from then you select a forecast name that you want to export to, you select how many periods and of course the more periods, the longer time it takes if the calculation is heavy, then you select a period length that you can define and this should, of course, reflect your normal forecasts so you have to be aware if you have some forecast working in weeks, and other in month, it could be quite complex to do so you have to be aware of what you’re doing here.

You can select forecast type sales or component forecast or both which reflects or applies to Microsoft Business Central standard forecast type.

Then you can divide into item categories if you’re using item categories on your item card and you want the forecast to be divided into that so we have a bundle of item categories in the beginning and then later on, etc.

And you can select to only include lines with quantities, meaning if you have many items where you don’t have any movements or any forecast, they will just be left out of the export.

So these are the fields on the option types.