When using the Replenish on Order (MTO) route in Odoo, it is important to understand that a product will always be purchased when there is a demand for it, even if stock is available.
For some companies, this can be a limitation, especially when existing stock should be used first, and only the missing quantity should be purchased.
The Stock MTS+MTO Rule module is designed to handle this scenario. It introduces the Make To Order + Make To Stock route, which first reserves available stock and then creates a purchase order only for the difference.
How to Configure
Once the module is installed, you will see a new route in the Routes section. At first, this route has no rules and does nothing. To make it functional, two steps are required:
-
Activate the Route’s Rules
Go toInventory > Configuration > Warehouse, select the warehouse where you want to use this route, and enable the option:Use MTO+MTS rules. -
Assign the Route to Products
For the products that should follow this logic, select theMake To Order + Make To Stock route along with theBuy route.
How the Make To Order + Make To Stock Route Works
Once configured, when demand is created for a product, the system applies the following logic:
- If the demand is less than or equal to the forecasted quantity, the product is taken from stock.
- If the demand is greater than the forecasted quantity (and the forecasted quantity is positive), available stock is reserved, and a purchase order is created for the missing quantity.
- If the forecasted quantity is zero or negative, a purchase order is created for the full required quantity.
Suggested Improvement
One possible improvement for the module would be to automatically archive the Make To Order + Make To Stock route when the route's rules are not enabled at the warehouse level. This would prevent confusion, since the route currently appears on products even without rules.
This module is maintained by the Odoo Community Association (OCA). The latest version available is 17.0.1.0.1.