Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Is there an inventory forecasting module for Odoo?

By
Adam OConnor
on 9/9/14, 7:43 PM 2,048 views

Is there a way to do smart inventory order forecasting using the EoQ (economic order quantity) method for computing order quantities based on historical ordering and sales loss minimization?

 

 

1
Nilim
On 1/27/16, 3:25 AM

Hi Adams,

Although its a too late reply to your query but i hope my solution might help you.As per your query, there is no separate module for Inventory Order Forecasting in Odoo. But one way which can be used that satisfies your query is by configuring Reordering Rules for products in Odoo which is basically based on Forecasted Quantity/Quantity Available.

In Odoo, this Reordering Rules are basically configured for any Product for which we want automatic reordering of quantities, based on certain quantity values of the products. This can be done by following :-

1) Create/Edit any product by following Sales>Products>Products

2) While Creating/Editing any product,on the right hand corner there appears an icon “Reordering Rules”

3) Once you click on it you will land on the configuration page of “Reordering Rules”

4) Here we can set, the “Minimum Quantity” and “Maximum Quantity” of that particular product.

5) By “Minimum Quantity” it conveys the minimum Forecasted Quantity/Quantity Available of that product for which,this rule would trigger.

For E.g.

If we set “Minimum Quantity” value = 10 then, automatically the Reordering Rule would be triggered whenever Forecasted Quantity/Quantity Available of that particular product reaches 10 or below.

6) By “Maximum Quantity” it conveys the maximum quantity of Forecasted Quantity/Quantity Available which should be ordered.

For E.g:-

If we have set the Maximum Quantity = 20, then the Forecasted Quantity/Quantity Available would become 20 as soon as the Reordering Rule is triggered. As we have set the minimum quantity to 10 hence total of 10 quantities would be ordered to make total Forecasted Quantity/Quantity Available = 20. This is because as we already have 10 quantities in our Forecasted Quantity/Quantity Available hence only ordering of 10 quantities is required to maintain maximum value of Forecasted Quantity/Quantity Available.

7) Now once Reordering Rule is triggered a Procurement along with a Purchase Order would be generated. Once the purchase Order is confirmed and products are received and transferred, the respective Procurement can be confirmed by clicking on Check Procurement. Once the Invoice is paid in the Purchase Order, the inventory of the respective product is updated and we can see that the Forecasted quantity along with Quantity on hand of the respective product is updated.

In this way we can do smart inventory order forecasting.

Hope this helps

 Cheers!!

1

Kevin McMenamin

--Kevin McMenamin--
804
| 5 2 6
Auckland, New Zealand
--Kevin McMenamin--
Kevin McMenamin
On 9/11/14, 5:32 AM

The standard procurement module using a minimum available quantity/minimum order quantity to generate orders - as far as I know there is no forecasting module that uses seasonality etc to determine future demand

I heard that version 8 will have the ability to calculate purchase quantities based on sales history and a solution to the economic order quantity problem. This was more or less in version 6 but was pulled out of version 7 and supposedly put into version 8 with some fixes. However, it is not apparent as to where to enter the input parameters to do inventory forecasting. Can anyone point in the right direction?

Ursa Information Systems, Adam OConnor
on 9/22/14, 12:08 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 9/9/14, 7:43 PM
Seen: 2048 times
Last updated: 1/27/16, 3:25 AM