Replenishment of Missing Quantities

This module allows you to define logistic rules that will replenish only the missing quantities.
This functionality is standard in Odoo V18. The code is well-documented, making it easy to customize to your specific needs.
The module is available in both English and French.

How Replenishment Works in Odoo Standard

In Odoo Standard, you have four options for replenishment:

1. You don't configure automated replenishment; instead, you manually replenish stock as needed.
2. You configure a logistic route to replenish demand regardless of the current stock. For example, if you create a sales order "A" for 4 tables, even if you have 6 tables in stock, Odoo will generate a replenishment for 4 units, which will be automatically reserved for sales order "A".
3. You configure a logistic route to replenish demand only if stock is insufficient. For instance, if you create a sales order "B" for 4 tables and you have more than 4 tables in stock, Odoo will reserve them. Otherwise, it will create a replenishment for 4 tables, even if you already have 2 in stock.
4. You configure a reorder point (ROP). In this scenario, if the stock falls below a minimum level, Odoo will generate a replenishment. If you set both the minimum and maximum replenishment quantities to zero, Odoo will only generate replenishment for the missing quantities. For example, if you create a sales order "C" for 3 tables and have 1 in stock, ROP will trigger a replenishment for the 2 missing units.

These four options cover most scenarios. However, there are specific cases where you may want to decide manually whether to generate a replenishment. One major drawback of the ROP method is the lack of flexibility—it automatically generates replenishment whenever the stock falls below the minimum threshold. With logistic routes, you can decide on a sales order whether to generate a replenishment. However, Odoo will not generate replenishment only for the missing quantities but for the entire demand if stock is insufficient.

What Does This Module Enable?

This module enables the configuration of logistic routes that generate replenishments only for the missing quantities. This way, you gain the best of both worlds: replenishing only what's needed while retaining the flexibility to decide whether or not to trigger a replenishment.

Example of a Possible Configuration

Configure two logistic routes:

• The route on the left replenishes only what is missing.
• The route on the left triggers a replenishment for the entire demand, regardless of the stock level.

As you can see, both routes are similar. The key difference lies in the rules configuration:

• The rules for the MTS + MTO route use the supply method: "Take From Stock, if unavailable, Trigger Another Rule."
• The rules for the MTO route use the supply method: "Trigger Another Rule."

Now, let's check the stock levels of three products.

• The drawer has 15 units reserved and 13 units available (5 + 8).
• The drawer case black has 8 units available.
• The table has 2 units available (1 + 1).

Next, we'll create a sales order with these three products and assign a different route to each one.

Upon configuring, replenishments are generated according to the specified logistic rules:

• The table is manufactured, so Odoo generates a Manufacturing Order (MO).
• The drawer case (black) is purchased, so Odoo generates a Purchase Order (PO).

On the delivery slip, some quantities have been reserved from the stock:

• The two available tables have been reserved.
• 13 drawers have been reserved.

A manufacturing order has been generated for the 3 missing tables.

A purchase order has been generated for the demand of 10 drawer cases (black), regardless of the 8 units in stock.

No replenishment has been generated for the two missing drawers; this will need to be handled manually.

Do you want to test this module?

Request access to a demo system by contacting us at: contact@thefishconsulting.be.