Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Master planning, demand forecast and customer sellable days

Posted on by 265

Hi,

I am testing the master planning functionality, with demand forecast, while taking into account item shelf life. 

The scenario is the following:

- There is a demand forecast line for item-customer combination with requirement date 1st of December 2015, 3.000 pieces.

- There is a sales order for the customer with requirement date 16th of November 2015.

- There is on-hand inventory of 50.000 pieces that expires on 26th of December

- the customer has a setting for sellable days for that item: 90 days. 

- the item has shelf life 270 days. 

After running master planning, AX correctly proposes that the SO should be covered with a new batch order (the item is a production item), because the on-hand inventory doesn't satisfy the sellable days criterion.

However, the demand forecast line is covered with the on-hand inventory.

Is this a bug, or is there a logical explanation?

Thanks,

Maja

Categories:
  • PaulThompson Profile Picture
    PaulThompson on at
    RE: Master planning, demand forecast and customer sellable days

    Hi,

    I am getting same results.

    Open sales order - planning takes sellable days into account.

    Customer specific demand forecast line - planning does not take sellable days into account.

    This does not seem to be correct as I would expect both to take sellable days into account.

    In the process manufacturing manual - chapter four - it states following which does not appear to be the case in the environment I am using.  I will raise a new issue with MS for this and see if this is functioning as expected.

    Process manufacturing in Microsoft Dynamics AX 2012 considers the following functionalities during master planning:

    FEFO date-controlled items with customer sellable days

    Regards, Paul

  • Maja RB Profile Picture
    Maja RB 265 on at
    RE: Master planning, demand forecast and customer sellable days

    I was looking at the same blog, and I got AX to work like it's described there - when you have a sales order and on hand quantity, MRP will take into account the expiry date and customer sellable days.  

    However, with demand forecast it won't, it will ignore customer sellable days and only look at the expiry date. If the expiry date of on hand quantity is later than the demand forecast date, AX will satisfy the demand  with on hand quantity, no matter what is the sellable days setting. Even if that means that the item will expire the next day, which is unacceptable.

    However, if the author gives you some useful tips, please share.

    Best regards,

    Maja

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Master planning, demand forecast and customer sellable days

    Hi,

    i'm working on the same case and i have the same problem in using sellable days with MRP.

    on this blog, it seems to be ok 

    http://www.erpsoftwareblog.com/2014/05/prevent-shipping-short-dated-products-to-your-customers-with-microsoft-dynamics-ax/#comment-204797

    I send a message to the author

    I hope i will have an answer

    Regards

    Anthony

  • Maja RB Profile Picture
    Maja RB 265 on at
    RE: Master planning, demand forecast and customer sellable days

    If it's not a bug, I'm more than happy to admit that my setup is flawed :)

    I really need that functionality to work, so if someone knows how to make it work (presuming that it's not a bug), please let me know.

    Thanks,

    Maja

  • jac_rod Profile Picture
    jac_rod 1,268 on at
    RE: Master planning, demand forecast and customer sellable days

    Hey Guy,

    Yeah.  I agree with you.  I've seen that as well.  If that were the case, though, it'd be nice if they explained it a bit instead of just saying "Microsoft will not be issuing a fix at this time".  

    If it's a piece of functionality that's intended and just not being used correctly, I've seen the comment "Microsoft has evaluated this issue, and has determined that this functionality is working as designed."  If that's the case, they'll sometimes include an explanation or link to references, as well.

  • Guy Terry Profile Picture
    Guy Terry 28,463 Super User 2024 Season 2 on at
    RE: Master planning, demand forecast and customer sellable days

    In my experience, 'Microsoft has evaluated this issue, and will not be issuing a fix at this time' is also used when there is no bug. It could be that the person who logged that incident was doing something wrong, or they were expecting the system to do something it is not designed to do.

    In the case of the latter, I have also seen that one incident could be closed as 'will not be issuing a fix', and a new incident opened to request a change to the design.

    What I am saying is, we don't know the details of that incident, and we can't be sure that there is a bona fide bug which MS are refusing to fix!

  • jac_rod Profile Picture
    jac_rod 1,268 on at
    RE: Master planning, demand forecast and customer sellable days

    Yeah, I hate when "we know something doesn't work, but we're not going to fix it" is the answer.

  • Maja RB Profile Picture
    Maja RB 265 on at
    RE: Master planning, demand forecast and customer sellable days

    Hi Jake,

    thanks for the answer, it seems to be the same issue.

    I am really disappointed that there is no fix planned, cause without it "sellable days" is just another feature that looks nice on paper but is only partially implemented.

    Thanks again,

    Maja

  • Suggested answer
    jac_rod Profile Picture
    jac_rod 1,268 on at
    RE: Master planning, demand forecast and customer sellable days

    Hey Maja,

    I haven't personally seen this behavior, but there's a similar issue logged in LCS.

    fix.lcs.dynamics.com/.../NotFixed;qc=56d898f8a3ff20085fbdc450285cff99ebfbe8b80c02e8a37dedf3fe0a8b9a01

    It's possible that the problem you're seeing is caused by the same issue.  If so, it looks like it's a known bug and has no fix planned.

    -Jake

  • Maja RB Profile Picture
    Maja RB 265 on at
    RE: Master planning, demand forecast and customer sellable days

    Yes, I have FEFO date controlled checked on the item model group.

    MRP works fine with SO, it takes the dates into account, so something IS set right :)

    However, with demand forecast it doesn't.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans