Announcements
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
*This post is locked for comments
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
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
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
I send a message to the author
I hope i will have an answer
Regards
Anthony
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
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.
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!
Yeah, I hate when "we know something doesn't work, but we're not going to fix it" is the answer.
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
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
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.
André Arnaud de Cal...
293,707
Super User 2025 Season 1
Martin Dráb
232,679
Most Valuable Professional
nmaenpaa
101,158
Moderator