I love open source ERP! I have used it now for 10 years, and I love how it helps growing and rapidly changing organizations. Monday, I was in a meeting, and the purchasing/planning department was not happy with the replenishment process. They were forced to dig through extra records to find the ‘real’ replenishment needs.
Here was the issue: the replenishment process was including products where the quantity on hand was equal-to or less-than the ‘Re-order below minimum threshold’ value. The desire was to only show less-than records. This situation might seem trivial problem; however, the daily replenishment report was significantly longer than what was actually needed. If you have ever been in an organization that touts its abilities to achieve high standards, you understand the accuracy and efficiency is a big deal.
The solution was easy to implement:
Here is what the replenishment code currently says: (less then or equal)
sql = “UPDATE T_Replenish”+ ” SET QtyToOrder = CASE WHEN QtyOnHand – QtyReserved + QtyOrdered <= Level_Min “+ ” THEN Level_Max – QtyOnHand + QtyReserved – QtyOrdered “+ ” ELSE 0 END “+ “WHERE ReplenishType=’1′”
Here is what it should say based on the discussion: (less than)
sql = “UPDATE T_Replenish”+ ” SET QtyToOrder = CASE WHEN QtyOnHand – QtyReserved + QtyOrdered < Level_Min “+ ” THEN Level_Max – QtyOnHand + QtyReserved – QtyOrdered “+ ” ELSE 0 END “+ “WHERE ReplenishType=’1′”
By changing a single character, we prevented implementing a work-around for over 100K products. The issue was identified on Monday. The fix was released on Thursday. Now, the replenishment report only shows products that truely need action.
What makes this sitaution so significant is the alternative. If you use Microsoft Dyanmics, Sage, Netsuite, or many of the other proprietary ERP products, you painfully understand the the next steps:
- You find and implement a work around.
- You report the bug to Microsoft (if you have paid subscription).
- You hope the bug finds it way onto a roadmap.
- You hope the proposed solution gets released in the near future (in the next year).
- You hope they understood and fixed the real problem.
- You hope they did not break anything when the released 10 other features that you did not need.
Why consider Open Source ERP
Open source ERP gives you every opportunity to prove or disprove its ability to support your company’s ERP needs on a timeline that satisfies your organizational needs. With open source ERP, you do not face the same financial constraints nor do you face the same conflicts of interest as with commercial ERP. Instead, you invest in the appropriate skills and knowledge for your people and processes. Best of all – if open source ERP cannot solve your company’s needs, you can safely justify spending the additional $2K to $5K per person per year for life of your commercial ERP to help drive your organization’s success.
ADempiere vs iDempiere vs Openbravo vs Compiere
Please note that ADempiere, iDempiere and Openbravo are forks or copies from Compiere. Therefore, they have similar abilities mentioned above. The biggest difference is that ADempiere and iDempiere are pure open source. There are no features held behind a commercial or paid license.
About Chuck Boecking: I am an ERP educator. I believe that open source ERP have achieved mainstream capabilities, and as a result, more companies can create greater efficiency across their organization. I started using the iDempiere code base in 2003. Back then, it was called Compiere. In 2006, I started my first multi-million dollar installation. Since then, ADempiere has helped me create great success with distribution and manufacturing companies all over the world. My vision of success is to find companies that can best use open source ERP to help them achieve a single, global instance that drives a discontinuous increase in profitability. I believe that organizations win when they own their technology.
If you have questions, comments or concerns, let me know. I definitely want your feedback.
You can contact me by phone using 512.850.6068.
My email is firstname.lastname@example.org.
You can complete the form on this page.
Thank you for taking the time. I look forward to speaking with you.