Demand Driven MRP - Revolutionary approach to planning- custom app under development

DDMRP or Demand Driven Material Requirements Planning is a formal multi-echelon planning and execution method to protect and promote the flow of relevant information through the establishment and management of strategically placed decoupling point stock buffers.

This new method is challenging decades old methods that are embedded in established ERP like SAP, Oracle etc

Developing a solution based on specification released by Demand Driven Institute is an opportunity for ERPNext commnunity.

More so because Odoo already has something on these lines.
https://eficent.io/

We can help with understanding the business part of the opportunity.

4 Likes

It would be helpful if you could point out what is missing in ERPNext to what is expected in this type of planning approach

Hi Pavan

I am not an expert on ERPNext.

Basic difference is for Make to Stock scenario - traditional approach is to take forecast as an input. DDMRP uses forecasts to impact the buffer design but the actual production orders and supply orders are generated based on actual consumption in the market.

Demand Driven Institute site has lot of whitepapers to explain the nuances.

Hope this helps.

The idea makes sense. But turning it into actual action points is where the value lies. Maybe actually look into what ERPNext offers, then do a gap analysis and present that. Otherwise this is going to go nowhere.

4 Likes

I guess it would have to be two ways. Those who are experts on ERPNext share their experiences on the challenges faced by clients when what is offered by ERPNext is getting implemented.

I have narrated the generic challenges with other ERPs.

@deepaknagar
it is a very big subject in itself, something similar is ‘Theory of Constraints’ by Eliyahu M. Goldratt. The author is a legend for some prominent teachers and industry leaders.
I would recommend reading Necessary But Not Sufficient: A Theory Of Constraints Business Novel by Eliyahu M. Goldratt , this clears a lot air, and is interesting and relatable.

Based on my reading, here are some points for ERPNext :

  • Have a more cable planning tool that prepares schedules for workstations on demand
  • The demand driven approach is about re-running the Planning tool, which can again schedule as per the changed demands.
  • It is also about controlling excess capacity and not overproducing from workstations. Overproducing leads to locking up of working capital.

I am not sure if ERPNext users who could be SMEs will be able to benefit from this approach. To me it seems suitable for large scale manufacturing/service industries.

1 Like

Hi Dhananjay

Check out the case studies on Demand Driven Institute site.

There are success stories of large, medium and small sized companies.

I will go through the case studies. They seem very relevant.
I think ERPNext has the basic system in place, we might need some reports to begin with.

e.g Base on the British Telecom case study(British Telecom DDMRP Case Study on Vimeo) :
“Purchase Order Items to be Delivered” - report should have a column indicating average daily consumption, based on which Purchase Orders could be categorized and color coded.

If you can help and come up with such examples, you can then either post it here or create a github issue.

Hi Dhananjay

We are implementing such system for Bullows Paints Equipments, a user of ERPNext. We are using existing reports from ERPNext and have developed the solution on Excel.

One of the days if you visit the client site at Thane, we can demonstrate the same to you.

Could you share the excel template and create a github issue on that basis ?

How do I do that?

Sorry a basic doubt. I just created by id on Github.

If you are logged in to github just follow this link Sign in to GitHub ¡ GitHub
You can set a title like [Feature Request] Demand Driven MRP report-

Then describe the following:

  • Why is it needed ?
  • How will it benefit your particular case ?
  • What needs to be done ? State it clearly. Here you put a screenshot of your excel file and describe the columns.
    Also your can refer to the existing reports like Recommended Re-Order Level and Stock Projected Qty, etc, as it seems your report is a combination of these reports.

There is a good first timers guide here : Issue Guidelines ¡ frappe/erpnext Wiki ¡ GitHub

1 Like

Check out the videos uploaded on YouTube:

Total of 30 Minutes in 6 videos

1 Like

I am now working on migrating ODOO’s DDMRP module GitHub - OCA/ddmrp to erpnext, after 2 weeks hard work, the coding is almost done, planned to trial run and promote internally in the following months, any community members interested in this feature also? if enough interests from community, I would like to open source this custom app or contribute to the core.

5 Likes

Great job.

I mean, yes. @deepaknagar, I and a bunch of other people would implore you to open source your code. If you want to push it to the core, that’s awesome, but have it as an app to begin with at least.

Thanks

Jay

This is great…Would you want to test it, let me know.

Yes, I do need 2~3 pilot users to test this app, maybe one month later.

Superb! I can help in testing. Plz expedite.

be more patient, still fine tuning and internal testing.

1 Like

Maybe you can also share some screen shots . And also what you are porting over.?