Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How to load Demand For...
Finance forum
Suggested answer

How to load Demand Forecast history

Posted on by 5

Is there a way in Dynamics 365 for Operations to load demand history? The demand forecasting functionality uses historical data to generate a statistical baseline forecast, but for new customer with no history or when a customer adds a new product in and still wants a forecast (based on a similar product), there doesn't seem to be a way to manage this.

I can see there is a way to remove outliers but effectively this is done by use a query to restrict what historical transactions are included. But no the ability to add in history.

Thanks

  • andreasraithel Profile Picture
    andreasraithel 4,643 Super User 2024 Season 2 on at
    RE: How to load Demand Forecast history

    This way works for me.

    - Add the Items with historical demand to Item allocation keys.

    - If you have product dimensions import these as well with historical data file.

    - Run Generate statistical baseline forecast for this Item allocation key.

  • MiguelParra95 Profile Picture
    MiguelParra95 5 on at
    RE: How to load Demand Forecast history

    NJK, did you found a solution to the forecast not taking into consideration the historical? I'm experiencing the same issue

  • NJK Profile Picture
    NJK 160 on at
    RE: How to load Demand Forecast history

    Hi, I'm facing a similar issue where I used the sample CSV file to import historical data for an item into D365FO. But once I import the file into the system and copy the data to the target table from the staging table with bare minimum data (Item number, demand date, demand quantity, site and warehouse), I find that the system doesn't take the data into consideration when running a forecast. Is there a step which is missing in between?

  • Suggested answer
    Deepak Agarwal Profile Picture
    Deepak Agarwal 148 on at
    RE: How to load Demand Forecast history

    Not very much sure if Historical external demand entity will help. As i tried the same but didnt get data on front end. I am working on the issue.

  • Suggested answer
    Joe Tews Profile Picture
    Joe Tews 10 on at
    RE: How to load Demand Forecast history

    Hi Lance,

    Not sure if you've found the answer to this or not, but there is an "Historical external demand" data entity (Workspaces | Data management | Data entities | Historical external demand) that will populate a table with external demand for you. This is where the demand forecasting will get the historical information for you.

    Check out this doc for more information: docs.microsoft.com/.../import-historical-data

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans