Hello,
I am having a problem using on hand inventory as safety stock. So, even if I have more inventory on hand than the minimum stock key, a replenishment order is created.
The “Fulfill minimum” key is set as “Today” but as I get it, if I have enough inventory I should not have an order to replenish the safety stock today.
Negative days are set as zero and positive days are 365.
Any ideas?
Thank you all.
Regards,
Nacho
A couple things to check:
On the master plan itself, make sure the “include onhand inventory” box is check/enabled. I can’t imagine this would be unchecked, but I’ve got to at least start with that 
Look at the setup for the coverage group assigned to the item. There’s a setting for consume onhand inventory that can be toggled between before or after all other supply. You’d want this set to before. Note that this winds up defaulting to the item coverage form, but can be overridden there.
Hi Chan,
I had already checked these settings. They are as you wrote.
Anything else?
Thank you for your fast response.
Regards,
Nacho
Hi Nacho, if parameters are ok you should analize other possible situations… the item is batch controlled? is it expired? the disposition code is available? The requirement profile button should show you the inventory if AX is considering it
Hi Héctor,
The item is not batch controlled.
The first line of the Net Requirements table is the on hand inventory and the second line is an order for the max quantity even if my min key is less than my on hand inventory.
It just works as it is expected if the min key is set to zero or if the Fulfill minimum is set to the end of the coverage period (because it does not create an unnecessary order).
Anymore ideas?
Thank you all.
Regards,
Nacho
I think that a screenshot from the Plan tab of the item itself, Item coverage, General tab would be of help.
Was this item created within AX, or was it created with an data import tool?
I would also want to see the net requirements screen, but first a question - why is the negtive days zero? What happens to your suggested supply if you set it to 365? If you cannot answer the first one and the second resolves it you have a solution
This is the table of the net requirements with negative days set to zero:
This is the capture of the net requirements with 365 negative days:
In both situations I do not understand why there is a purchase proposal if the on hand inventory is higher than the minimum key.
Thank you everybody.
Regards,
Nacho
Still need the coverage group screen shot please to see the coverage element.
What are your settings for the reduction key of the forecast
Can you tell me why you are using the Min/Max setting from a business perspective? Can you also set it to period and see what happens on a new run?
“It just works as it is expected if the min key is set to zero or if the Fulfill minimum is set to the end of the coverage period”.
If min=0, you’re effectively turning off the safety stock threshold, so that part’s not surprising. What is surprising, though, is that you say OR if you change the fulfill minimum setting to coverage time fence (with safety/min still at 20?) this does NOT generate a planned order due 2/6. That doesn’t make sense, especially if it is correctly generating planned orders for future requirements other than the initial 2/6 order.
Look at the pegging for the onhand line. It might shed some light on this.
I doubt this affects it (should be a bug if it does), but why does the item coverage show overriding the onhand inventory treatment (top right) and set the policy to consume inventory first, when that’s the setting you’re enforcing at the group level? You should only check the override to change away from the group setting, like you did by making the product min/max where the group is set to period.
Hi Adam,
I was just exploring the possibilities of using the min/max key on a product with demand forecast. I am aware that it does not make much sense but then I found out that AX did not work as I expected or at least as I expected the min/max key to work.
If I set the key to “period” it still creates another purchase order in order to cover the safety stock:
The reduction key is set for weekly periods.
Thank you Adam.
What it is doing (reading the net requirements) is retriggering supply when demand drops the inventory level below the maximum inventory. Now this should of course be the minimum trigger back up to the maximum, but from memory the Min/Max replenishment type has easily the most issues logged with MS. They fix parts, bring out new elements (like the inventory consumption) and it breaks it.
Simply put change it to period and it will work (guessing) how you want. You then need to question the business decision on the Min/Max approach and the business justifaction for this (I want you to tell me this :-)) You have not said your version of AX2012, but have a look on lifecycle services for Min/Maz issues and if your particular configuration is not there you would need to log it with MS.
My simple recommendation is never to use Min/Max.
Remove the forecast and see if it creates the planned PO first line then.
Hi Chan,
I have checked out that if I remove the flag for overriding the on hand inventory on the item coverage it still works the same way. If I set the fulfill minimum setting to coverage time fence it covers the safety stock at the end of the period so it does not create an additional order and it works as if the minimum stock key was zero.
Thanks Chan.
Hi Adam,
It does not create it. I have already checked that.
But with the period key it also creates the additional line instead of using the on hand inventory.
If it used the on hand inventory to cover the safety stock it would be ok.
Thanks.
Hi Adam,
I’ve been doing some tests and I’ve found that if the requirements are lower than the on hand stock there is no line created to replenish the safety stock. The problem appears when the requirements are higher than on hand stock then the safety stock is replenished on the date pointed out by the Fulfill minimum key (if it is set as today then the line appears today) and it doesn’t matter which coverage code is set.
Would it be possible to replenish the safety stock not on the Fulfill minimum key but on the date where the minimum key is reached?
The version is Ax 2012 R3.
Thank you.
Regards,
Nacho
