Reordering rules

Reordering rules are used to keep forecasted stock levels above a certain threshold without exceeding a specified upper limit. This is accomplished by specifying a minimum quantity that stock should not fall below and a maximum quantity that stock should not exceed.

Reordering rules can be configured for each product based on the route used to replenish it. If a product uses the Buy route, then a Request for Quotation (RFQ) is created when the reordering rule is triggered. If a product uses the Manufacture route, then a Manufacturing Order (MO) is created instead. This is the case regardless of the selected replenishment route.

Configure products for reordering rules

In order to use reordering rules for a product, it must first be correctly configured. Begin by navigating to Inventory app ‣ Products ‣ Products, then select an existing product, or create a new one by clicking New.

On the product form, under the General Information tab, make sure the Product Type is set to Storable Product. This is necessary because Odoo only tracks stock quantities for storable products, and this number is used to trigger reordering rules.

Set the Product Type as Storable.

Next, click on the Inventory tab and select one or more routes from the Routes section. Doing so tells Odoo which route to use to replenish the product.

Select one or more routes on the Inventory tab.

If the product is reordered using the Buy route, confirm that the Can be Purchased checkbox is enabled under the product name. This makes the Purchase tab appear. Click on the Purchase tab, and specify at least one vendor, and the price that they sell the product for, so that Odoo knows which company the product should be purchased from.

Specify a vendor and price on the Purchase tab.

If the product is replenished using the Manufacture route, it needs to have at least one Bill of Materials (BoM) associated with it. This is necessary because Odoo only creates manufacturing orders for products with a BoM.

If a BoM does not already exist for the product, select the Bill of Materials smart button at the top of the product form, then click New to configure a new BoM.

The Bill of Materials smart button on a product form.

Create new reordering rules

To create a new reordering rule, navigate to Inventory app ‣ Configuration ‣ Reordering Rules, then click New, and fill out the new line as follows:

  • Product: The product that is replenished by the rule.

  • Location: The location where the product is stored.

  • Min Quantity: The minimum quantity that can be forecasted without the rule being triggered. When forecasted stock falls below this number, a replenishment order for the product is created.

  • Max Quantity: The maximum quantity that stock is replenished up to.

  • Multiple Quantity: Specify if the product should be replenished in batches of a certain quantity (e.g., a product could be replenished in batches of 20).

  • UoM: The unit of measure used for reordering the product. This value can simply be Units or a specific unit of measurement for weight, length, etc.

The form for creating a new reordering rule.

Tip

Reordering rules can also be created from each product form. To do so, navigate to Inventory app ‣ Products ‣ Products, and select a product. Then, click the Reordering Rules smart button, and click New to fill out the new line, as detailed above.

For advanced usage of reordering rules, learn about the following reordering rule fields:

0/0/1 reordering rule

The 0/0/1 reordering rule is a specialty rule used to replenish a product that is not kept on-hand, each time a sales order (SO) is confirmed for that product.

Important

The 0/0/1 reordering rule is similar to the Replenish on Order (MTO) route, in that both workflows are used to replenish a product upon confirmation of an SO.

The main difference between the two methods is that the Replenish on Order route automatically reserves the product for the SO that caused it to be replenished. This means the product cannot be used for a different SO.

The 0/0/1 reordering rule does not have this limitation. A product replenished using the rule is not reserved for any specific SO, and can be used as needed.

Another key difference is that replenishment orders created by the Replenish on Order route are linked to the original SO by a smart button at the top of the order. When using the 0/0/1 reordering rule, a replenishment order is created, but is not linked to the original SO.

See the Replenish on Order (MTO) documentation for a full overview of the MTO route.

To create a 0/0/1 reordering rule, navigate to Inventory app ‣ Products ‣ Products, and select a product.

At the top of the product’s page, click the Reordering Rules smart button to open the Reordering Rules page for the product. On the resulting page, click New to begin configuring a new reordering rule.

In the Location field of the new reordering rule, select the location in which replenished products should be stored. By default, this location is set to WH/Stock.

In the Route field, select the route the rule should use to replenish the item. For example, if the product should be purchased from a vendor, select the Buy route.

In the Min Quantity field and Max Quantity field, leave the values set to 0.00. In the To Order field, enter a value of 1.00.

A 0/0/1 reordering rule.

With the reordering rule configured using these values, each time an SO causes the forecasted quantity of the product to fall below the Min Quantity of 0.00, the selected Route is used to replenish the product in one-unit increments, back up to the Max Quantity of 0.00.

Example

A picture frame is configured with a 0/0/1 reordering rule that uses the Buy route. Zero units of the picture frame are kept on-hand at any given time.

An SO is confirmed for one unit of the picture frame, which causes the forecasted quantity to drop to -1.00. This triggers the reordering rule, which automatically creates a PO for one unit of the picture frame.

Once the product is received from the vendor, the forecasted quantity of the picture frame returns to 0.00. There is now one picture frame on-hand, but it is not reserved for the SO which triggered its purchase. It can be used to fulfill that SO, or reserved for a different order.

Trigger

When stock falls below the reordering rule’s minimum, set the reordering rule’s trigger to automatic to automatically create purchase or manufacturing orders to replenish stock.

Alternatively, setting the reordering rule’s trigger to manual displays the product and forecasted stock on the replenishment dashboard, where the procurement manager can review the stock levels, lead times, and forecasted dates of arrival.

See also

Replenishment

Tip

The replenishment dashboard is accessible by going to Inventory app ‣ Operations ‣ Replenishment.

To enable the Trigger field, go to Inventory app ‣ Configuration ‣ Reordering Rules. Then, click the (slider) icon, located to the far-right of the column titles, and enable the Trigger option from the additional options drop-down menu that appears.

Enable the Trigger field by toggling it in the additional options menu

In the Trigger column, select Auto or Manual. Refer to the sections below to learn about the different types of reordering rules.

Auto

Automatic reordering rules, configured by setting the reordering rule’s Trigger field to Auto, generates purchase or manufacturing orders when:

  1. the scheduler runs, and the On Hand quantity is below the minimum

  2. a sales order is confirmed, and lowers the Forecasted quantity of the product below the minimum

Tip

The scheduler is set to run once a day, by default.

To manually trigger a reordering rule before the scheduler runs, ensure developer mode is enabled, and select Inventory app ‣ Operations ‣ Run Scheduler. Then, click the purple Run Scheduler button on the pop-up window that appears.

Be aware that this also triggers any other scheduled actions.

Example

The product, Office Lamp, has an automatic reordering rule set to trigger when the forecasted quantity falls below the Min Quantity of 5.00. Since the current Forecast is 55.00, the reordering rule is not triggered.

Show automatic reordering rule from the Reordering Rule page.

If the Buy route is selected, then an RFQ is generated. To view and manage RFQs, navigate to Purchase app ‣ Orders ‣ Requests for Quotation.

If the Manufacture route is selected, then an MO is generated. To view and manage MOs, navigate to Manufacturing app ‣ Operations ‣ Manufacturing Orders.

When no route is selected, Odoo selects the Route specified in the Inventory tab of the product form.

Manual

Manual reordering rules, configured by setting the reordering rule’s Trigger field to Manual, lists a product on the replenishment dashboard when the forecasted quantity falls below a specified minimum. Products on this dashboard are called needs, because they are needed to fulfill upcoming sales orders, but the forecasted quantity is not enough.

The replenishment dashboard, accessible by navigating to Inventory app ‣ Operations ‣ Replenishment, considers sales order deadlines, forecasted stock levels, and vendor lead times. It displays needs only when it is time to reorder items.

Note

If the one-day window for ordering products is too short, skip to the visibility days section to make the need appear on the replenishment dashboard a specified number of days in advance.

When a product appears on the replenishment dashboard, clicking the Order Once button generates the purchase or manufacturing order with the specified amounts To Order.

Click the Order Once button on the replenishment dashboard to replenish stock.

Visibility days

Important

Ensure lead times are understood before proceeding with this section.

When manual reordering rules are assigned to a product, visibility days make the product appear on the replenishment dashboard (Inventory app ‣ Operations ‣ Replenishment) a certain number of days in advance.

Example

A product has a manual reordering rule set to trigger when the stock level falls below four units. The current on-hand quantity is ten units.

The current date is February 20th, and the delivery date on a sales order (in the Other Info tab) is March 3rd — twelve days from the current date.

The vendor lead time is four days, and the purchase security lead time is one day.

When the Visibility Days field of the reordering rule is set to zero, the product appears on the replenishment dashboard five days before the delivery date, which, in this case, is February 27th.

Graphic representing when the need appears on the replenishment dashboard: Feb 27th.

To see the product on the replenishment dashboard for the current date, February 20, set the Visibility Days to 7.00.

To determine the amount of visibility days needed to see a product on the replenishment dashboard, subtract today’s date from the date the need appears on the replenishment dashboard.

\[Visibility~days = Need~appears~date - Today's~date\]

Example

Referring to the example above, today’s date is February 20th, and the need for the product appears on February 27th.

(February 27 - February 20 = 7 days)

Incorrectly setting the Visibility Days fewer than seven days in this case results in the need not appearing on the replenishment dashboard.

Show the replenishment dashboard with the correct and incorrect visibility days set.

Route

Odoo allows for multiple routes to be selected under the Inventory tab on each product form. For instance, it is possible to select both Buy and Manufacture, thus enabling the functionality of both routes.

Odoo also enables users to set a preferred route for a product’s reordering rule. This is the route that the rule defaults to, if multiple are selected. To select a preferred route, begin by navigating to Inventory app ‣ Configuration ‣ Reordering Rules.

By default, the Route column is hidden on the Reordering Rules page.

Reveal the Route column by selecting the (slider) icon to the far-right of the column titles, and checking the Route option from the drop-down menu that appears.

Click inside of the column on the row of a reordering rule, and a drop-down menu shows all available routes for that rule. Select one to set it as the preferred route.

Select a preferred route from the drop-down.

Important

If multiple routes are enabled for a product but no preferred route is set for its reordering rule, the product is reordered using the selected route that is listed first on the Inventory tab of the product form.