web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • NataliiaS Profile Picture
    NataliiaS on at
    RE: Demand Forecast Table vs Sales Lines

    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?

  • Jose Eliseo Nunez Profile Picture
    Jose Eliseo Nunez 29 on at
    RE: Demand Forecast Table vs Sales Lines

    yes that is exactly what I'm talking about

  • NataliiaS Profile Picture
    NataliiaS on at
    RE: Demand Forecast Table vs Sales Lines

    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
    RE: Demand Forecast Table vs Sales Lines

    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 :)

  • Suggested answer
    NataliiaS Profile Picture
    NataliiaS on at
    RE: Demand Forecast Table vs Sales Lines

    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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans