web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Demand Forecast Table ...
Microsoft Dynamics AX (Archived)

Demand Forecast Table vs Sales Lines

(0) ShareShare
ReportReport
Posted on by Jose Eliseo Nunez 29

Hi I'm currently working on AX2012 R3 CU13, few weeks ago I started to get some issues running MRP seems that the demand forecast is not getting updated as sales order journals are, I would like to know if there is any way to get linked the sales line table with forecast sales, so in case any sales line is updated forecastsales is as well.

I would like to avoid created any development or change any MRP logic of AX standard.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    NataliiaS Profile Picture
    NataliiaS on at

    Hi Jose Eliseo Nunez,

    If you want to reduce forecast with actual sales then you can use Reduction principle on the master plan setup, refer to docs.microsoft.com/.../reduction-keys for examples

  • Jose Eliseo Nunez Profile Picture
    Jose Eliseo Nunez 29 on at

    Hi Natalia, I'm facing the issue that users are updating journals within sales orders but this changes are not reflected on the demand forecast, besides that link you provide me work for other issue I'm facing thanks a lot :)

  • NataliiaS Profile Picture
    NataliiaS on at

    Hi Jose Eliseo Nunez,

    When you say: "journals withing sales order" do you mean sales order with type journal?

  • Jose Eliseo Nunez Profile Picture
    Jose Eliseo Nunez 29 on at

    yes that is exactly what I'm talking about

  • NataliiaS Profile Picture
    NataliiaS on at

    Sales order with type “Journal” is considered as draft sales order, it does not affect stock quantity, standard AX does not create inventory transaction for it, therefore master planning does not see it as existing demand. Here is a detail explanation of order statuses https://technet.microsoft.com/en-us/library/aa551278.aspx

    It sounds like you are handling your demand forecast in two places as a Sales forecast and sales order journals. What is the reason behind this process? as now you are maintaining data in both entities separately since they are not related. Would it be an option for you to create and update forecast records only which will affect your MRP and do not use journals at all?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans