Overview of Reordering Rules in Odoo 17

For an establishment, maintaining proper inventory levels is one of the characteristics of the smooth running of the company. Maintaining complete stock levels while reducing expenses and optimizing productivity is very important for the success of organizations for stock management. Odoo 17 provides a feature for easy inventory management for various organization types. Implementing reordering rules in odoo is an essential component that enables companies to optimize their procurement procedures and guarantee prompt stock replenishment.

Reordering rules are an effective method for inventory replenishment. Businesses can reduce their stockouts and increase inventory turnover. The process of replenishing products to maintain appropriate inventory levels is referred to as replenishment.

To set up the reordering rule in Odoo 17, Go to Inventory –> Products –> Products.

Select a storable product to set up the reordering rule. We can either configure a new product or an existing one. Under the inventory tab of the product form, the buy route must be set for the product.

Click on the Reordering Rules smart button to create a new rule for replenishment for the product. Before that vendor should be set for the product under the purchase tab of the product form.

When the Reordering Rules are selected, it will be directed to a new page. Click on the New

button to create a new reordering rule for the product. The following fields will be visible :

• Product: The product for which the rule is being created.
• Location: Specifies the storage location for the ordered quantities after they are received.
• On hand: It is the quantity that is currently available in the stock.
• Forecast: It is the estimated quantity of the product that is estimated to be available in the future.
• Route: The route by which the product has to be replenished is given here. It can be Buy, Manufacture, or Replenish on Order (MTO).
• Trigger: The trigger for replenishment whether it is Auto or Manual.
• Min Quantity and Max Quantity: It is the minimum quantity that should be available in the stock. When the quantity goes below the minimum quantity, a new purchase order is created for the maximum quantity set.
• Multiple Quantity: Products can be ordered in multiples of the amount specified in multiple quantities.
• To Order: It is the amount that needs to be ordered to reach the maximum quantity.

Here the min quantity and max quantity are set as 5 and 10 respectively. To order is 10 since the on-hand quantity is 0 and it takes 10 more units to reach the maximum quantity. And the Trigger is set as Manual here. Let’s create a sale order for the product and also ensure that a vendor is given under the purchase tab of the product.

In the sale order, we can give the quantity as 3.

Now since the on-hand quantity is 0, a replenishment has to be done for the product. So go to reordering rules by navigating to Inventory –> Operations –> Replenishment.

Or else we can go to the reordering rules through the product as shown earlier.

Here you can see that the ‘To Order’ is 13 and that is calculated by subtracting the forecast from the maximum quantity, which we get as 13. When click on Order Once a purchase order will be triggered.

Go to the Purchase module to confirm and validate the receipt to receive the items in stock.

Move to the Sales app to validate the delivery for the product since the product is replenished and the items have arrived in stock.

Let’s look at the case when the trigger is set to Auto. For that first, create a reordering rule for a product and set its trigger to Auto.

Here we have given the Multiple Quantity as 4, so the product will be ordered in multiples of 4. This may cause a purchase order to be created that would result in more stock being on hand than what is indicated in the Max Quantity column, depending on the amount given here. Here the min

quantity and max quantity are set as 5 and 10, respectively. The on-hand quantity is 0 and it takes 10 more units to reach the maximum quantity, so the To Order should be 10 but since the Multiple Quantity is given as 4, the product will be ordered in multiples of 4. So the larger multiple of 4 nearest to 10 is 12, so To Order is 12 here.

Now, we can launch the Run Scheduler. Activate the developer mode and navigate to Inventory —

> Operations –> Run Scheduler.

When we click on the Run Scheduler, a pop-up appears as given below.

We can click on the Run Scheduler button to launch the Run Scheduler. Create a sale order for the product headphones.

Since the trigger is set to Auto, a purchase order will be triggered to replenish the product.

In the screenshot below, we can see the quantity in the purchase order is 16, that is because, the To Order was given as 12 before and the demanded quantity in the purchase order is 3, so the To Order will be 15 is 12 plus 3, but since the Multiple Quantity is 4, To Order becomes 16 which is the closest larger number to 15.

We can confirm the order, validate the receipt, and continue the delivery process in the sales order.

So we have seen how odoo reordering rules can be configured for a product and how different triggers replenish the items in stock. With the help of this feature, businesses can improve operational efficiency and customer happiness by streamlining their inventory management procedures using reordering rules in Odoo 17.