frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
20.33k stars 7.08k forks source link

Feature request: How to use ERPNext for Process and Discrete Manufacturing at the same time? #16203

Open yonasmxx opened 5 years ago

yonasmxx commented 5 years ago

I just want to use ERPNext for Leather Tannery business but the software system is built for discrete manufacturing with BoM. In leather tanning process, you start with the by purchasing and storing raw leather from supplier with grading system and size. After that, the raw material will be feed to several machines by adding various chemicals to the leather. I know there should be formula based BoM when dealing with chemicals but the tricky part is feeding multiple leathers in one drum for a day or more and then again operators will deal with individual items. The process is converting a raw hides and skins into finished leather by adding different chemicals and manual works.

For further understanding, you can look this great project: http://leatherlink.net/bsg/tms_commercial/help_manual/LeatherLink_TMS_User_Manual.php?app_name=TMS. I don't know it works for real since they stopped developing after 2010 but they implemented the process in a very convincing way.

Thanks.

agritheory commented 5 years ago

Hi @yonasmxx, I am one of the folks working in the Ag module and we're running into the same issues you mention regard discrete vs process mfg. This is a big ask, but not an unreasonable one and it sounds like you understand that. There isn't a simple fix to incorporate both discrete and process mfg and there are a couple of different designs that are possible. 1) Make BoMs selectable as discrete or process, which means refactoring a lot of code in the BoM but it keeps the changes more or less isolated there. @Alchez is working on some variation of this now. 2) Add infrastructure so that discrete and process are handled in separate workflows, with separate settings. This means modularizing the Manufacturing module by adding a "Manufacturing Line" doctype and reorganizing so that both workflows can be accommodated. 3) Process mfg can be a nightmare for keeping track of things by UoM and I'm concerned that there isn't a design that covers enough generic needs to be useful. In one cases, I'm working with a customer processing animals where the intermediate cuts of meat are kept on ice and it's impossible to get an accurate tare for steps 2 through ~6 and you only know the outcome in the input UoM when it's ready to be packed or go into cold storage. But there have been some set operations on that item that have reduced its weight with an uncertain percentage change. Currently the discrete BoM requires that the scrap percentage be identical each time, which is problematic for several reasons and needs a bit of redesign - I'm not sure myself of all the downstream impacts. Anyway, this gets at the "continuous input" problem, which would have to be handled in a process BoM - if chemical X flows from the container in an unknown quantity per leather hide, how does one attribute it? 4) A workaround that exists today is to handle all these things all as stock-in/ stock-out transactions and adjust the valuation rate on the Item master with the Landed Costs Voucher. This keeps track of "what items" and "how much on average" but not "when" or "how much each (not average)". If you are OK with taking inventory (measuring state) as your process control measure (and for most companies, that's what they're doing), LCV may be a solution. If you need more detail than that or want to commonify or specify the process, more work is required.

yonasmxx commented 5 years ago

Hi @agritheory

Thank you for your thoughtful and quick reply. Today, I found this module https://github.com/ESS-LLP/process-manufacturing. But I don't know how it may help since I have to test it. The other option is to create a new domain "Process manufacturing" replacing BoM with Formula. However the biggest problem will be the changing of number of items in the workstations and UoM. The inoERP guys did it but stopped developing the software since then. My bet is, if ERPNext incorporate this feature https://github.com/inoerp/inoERP/tree/master/inoerp/www/modules/pm- I hope is will be the biggest turning point in this domain since ERPNext is a modern looking software and already raising to the top.

Thanks again.

agritheory commented 5 years ago

@yonasmxx I think you should start a discussion on the forum about this (discuss.erpnext.com) because there are many voices to be heard and people are taking different approaches. I am familiar with the ESS app and recently contributed a bug fix to it but am not using it in a production context.

Alchez commented 5 years ago

@yonasmxx

An inital spec was created here for implementing Process Manufacturing.

Alchez commented 4 years ago

Posting here based on the spec in the Discuss post, but sadly there’s been no progress on this topic from my side, since I’ve been focused on some other projects. And I’m not sure when I’ll be able to get back on this, so if someone from the community wants to pick it up.


Quick note: All of the following is an initial spec and a work-in-progress. 😄

Gap Analysis:

We need the following elements of process manufacturing in the system:

Recipe / Formulation doctype structure

Goal: Master record for describing the process, i.e, bulk input -> bulk output.

Thoughts and suggestions are appreciated!

deercreekseed commented 3 years ago

Has anyone seen any movement on this. Was very curious to try this as our company can benefit from something similar

blewsky commented 3 years ago

We are also very interested in this feature. Is there any update on this?

blewsky commented 2 years ago

Please reopen. As you can see from the upvotes there was quite some interest in this feature request.

erabti commented 1 year ago

Any updates?