Community mailing list archives

community@mail.odoo.com

Re: Procurement Make To Order Check Stock First

by
OpenERP Master
- 05/20/2015 02:22:45
The module I wrote will solve a very basic business case, check the stock first before ordering from a vendor. Here is the link:

https://github.com/aliomattux/make_to_order_check_availability

The module is very lightweight, but does not cover complex business cases. I agree the system should check stock first, this is a classic business case. I wouldn't put too much burden on Odoo for this because at least some other ERP software such as Netsuite also do not have this feature. In Netsuite, it is called special order, meaning that every time a customer orders it, it will not check stock at all and just order it.

I think possibly creating a configurable option is more desirable,but would create additional work to manage the product. There are options out there...

On Tue, May 19, 2015 at 11:00 AM, OpenERP Master <openerpmaster@gmail.com> wrote:
Hi,

Just to comment, I already posted about this problem 2 months ago with a working module.

On Mon, May 18, 2015 at 9:08 PM, Hans Yonathan <hans.yonathan@falinwa.com> wrote:

Hi Joel,


Thanks for your information,

And the module is just committed last week,

 

I will make a test too for this module,

It interesting because we have a different way of code from my module but the same purpose.

 

Thank You.

 

Best Regards,

Hans Yonathan

Odoo Support

FALINWA Limited

Expert in Finance, Information System & Business Intelligence

Odoo Silver Partner

Website: www.falinwa.com

Tel. 13670137019 (China - Shenzhen)

 

From: Paul Catinean [mailto:paulcatinean@gmail.com]
Sent: Monday, May 18, 2015 10:15 PM
To: Community
Subject: Re: Procurement Make To Order Check Stock First

 

I also raised awareness about this feature it's basic need in a lot of warehousing processes, glad to know there's movement on it!

 

On Mon, May 18, 2015 at 3:52 PM, Joël Grand-Guillaume <joel.grandguillaume@camptocamp.com> wrote:

Hello,

I think we do have this module under review in OCA: https://github.com/OCA/stock-logistics-warehouse/pull/47

With this module, you have a new type of routes that allow to first source on stock what you can, and the remaining quantity on classic MTO.

Feel free to test it and provide your feedback.

Regards,

Joël




 

On Mon, May 18, 2015 at 2:31 PM, Hans Yonathan <hans.yonathan@falinwa.com> wrote:

Hello Odoo Community,

 

There’s a lot of request that asked about procurement method in Make To Order, to be check stock first.

Also there’s a discussion about this topic on the forum:

https://www.odoo.com/forum/help-1/question/how-to-make-to-order-with-stock-management-23173

 

But still there’s no solution about it,

Its very strange because it must be a basic feature of ERP for procurement process but Odoo doesn’t developed this function.

Even the warehouse system already upgraded in version 8, there’s still no solution about it.

 

So in my side, we begin to developed a module to achieve this function.

 

How the module works:

In Routes we have add additional checkbox called “Check Stock”,

You can check this checkbox on “Make To Order”, and the behavior of this make to order will always check the stock first rather than always create a PO or MO without consider the stock.

I added this checkbox, so we still have a past behavior of make to order.

When you have product that make to order and buy or manufacture,

The system will readjust the quantity to buy or manufacture based on the quantity that we already have on procurement process.

 

The computation formula is:

If product forescasted quantity >=0,

We apply the formula: procurement quantity = Order quantity – product forescasted quantity

If order quantity <= product forescasted

We cancel the procurement.

 

Right now the module is still beta and never used in production database and If there’s a people that want this function, can you help us to test it?

 

In our side we have test this module and its worked:

Case1:  sell Product (MTO and buy)

Case 2: sell product (MTO and manufacture)

Case 3: sell product (MTO and manufacture), and the raw material of that product BoM (MTO and buy)

Case 4:  manufacture product (MTO and manufacture), and the raw material of that product BoM (MTO and buy)

 

Another case that not test yet:

Multi Level BoM (test it above 2levels)

Multi Location

Multi company

Multi Warehouse

Multi Company, multi warehouse and multi location

 

 

 

Module link:

https://www.odoo.com/apps/modules/master/fal_procurement_check_stock/

 

 

 

Thank You.

 

Best Regards,

Hans Yonathan

Odoo Support

FALINWA Limited

Expert in Finance, Information System & Business Intelligence

Odoo Silver Partner

Website: www.falinwa.com

Tel. 13670137019 (China - Shenzhen)

 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



--

 

camptocamp

INNOVATIVE SOLUTIONS

BY OPEN SOURCE EXPERTS

 

Joël Grand-Guillaume

Division Manager

 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe