We are trying to use the Replenishment report and Reordering Rules to manage our inventory, and it doesn’t seem to be doing what it says it should. I suspect that we’ve misconfigured something somewhere, but I can’t figure it out. We’re on Enterprise v16.
The documentation here (https://www.odoo.com/documentation/16.0/applications/inventory_and_mrp/inventory/product_management/product_replenishment/strategies.html) says
“By default, the replenishment report dashboard shows every product that needs to be manually reordered. If there is no specific rule for a product, Odoo assumes the Min Quantity and Max Quantity stock are both 0.00”
So this sounds like the Replenishment report dashboard works like a MTO model for any items that don’t have a Reordering Rule (RR)
So, the absence of a RR will result in a negative forecast (when an order is received), and the item will appear on the Replenishment report. This is good, because we have a lot of SKUs – the vast majority of which are not items we stock, and we haven’t created RRs for them.
But that’s not what we’re seeing.
When I go to the Inventory->Stock report, and use the built-in filter called “Negative Forecasted Quantity” (NFQ), I get scads of items that are not on the Replenishment report. Right now, I have 24 entries on the NFQ report, and 20 of them are not on the Replenishment report. So we have orders in our system for products that we do not have in stock, and the replenishment report is *not* telling us that we have to make or buy them. My purchasing and manufacturing departments are going crazy trying to figure out what to buy and schedule for production, because the Replenishment report is missing products that we need.
Notable: We are a manufacturer, so we have products (raw material) that we buy, and products (saleable) that we manufacture. We need to use manual intervention for most of our manufacturing replenishment, because we have similar products that come from the same batch, and we need to make them all at once, even if some aren’t calling for replenishment. (example: we make soft drinks is many different sizes, so when we run “Drink A”, we need to produce the 355 ml product, the 750ml product, the 2L product and the 20L product all from the same manufacturing batch. We will bring them all up to their maximum or so, even if some are not yet at their minimum. This requires manual intervention.)
We don’t have BOMs for every single item, but right now, I took a product that is in Negative (NFQ), and not on the RR:
I created a BOM for it, with purchasing lead time of the raw material of 10 days, and the Mfg lead time for the product is 2 days, and the order is scheduled for delivery tomorrow. The RM is showing OnHand of 0, forecast of 0, and the product is showing OnHand of 0, Forecast of (-1). And no indication that we need to make or order anything.
Finally, when I create an RR for the product (Min/Max = 0/0), I get a Replenishment entry.
But I have other Manufactured items on the RR that don’t have BOMs. What’s going on!?!?!?
were you able to get the suggested solution to work? I was able to get re-ordering rules to work if created manually, but I have thousands of products, so I created a re-ordering rule for all of them using a script, and then when I tried to go into the replenishment area, the system deleted the vast majority of the rules i created (but not all)! lol so confused.
Colin-
While I don't like that you're suffering like I am, I'm glad to hear that I'm not alone in this. No, the solution didn't work. I'm at a loss trying to figure it out.
We didn't initially configure our products with mfg (or any) lead times, and my sales reps do what they always did - they put in dates in the future for delivery. This, I thought, might have been causing the issue, because if it's not due to be shipped for a month, and the LT is zero, there's no action required at this time. But, even when I bump the Mfg LT up enough that it's going to be late - the replenishment report doesn't pick up the item.
I do suspect that there's some logic that I'm missing, but the documentation says it should be doing the exact opposite of what I'm seeing.
This has been going on since we began with Odoo in January. It has never worked as expected, and my staff are having to create BBS work-arounds.
Hey David, did you find any solutions on this? We are implementing Odoo now and this is our biggest issue/concern during testing. The 0/0 rule is only triggering if the sales order delivery is set to the next day, which is useless since all our products have vendor lead time.
Hi Colin - yes, it's a feature of the "Replenishment" menu option that is deletes existing Manual Reordering Rules and recreates them, so it's impossible to set Visibility Days. It should not delete the Automatic Reordering Rules!