Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / How to load Demand For...
Finance forum

How to load Demand Forecast history

(0) ShareShare
ReportReport
Posted on by Lance Garrett 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

Categories:
Finance and Operations
  • andreasraithel Profile Picture
    andreasraithel 4,840 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 8,564 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans