Openbravo ERP

Openbravo ERP


Project Description

Implement Open Source Openbravo ERP with Webstore An Enterprise web-based ERP Solution with POS

Executive Summary

Sigma Infosolutions leveraged its expertise on Open Source, Openbravo ERP to architect and implement the ERP along with its web engine for a webstore company in North America. The ERP application is an automated engine which allows the Client to monitor, analyze and manage, forecast and helps in strategizing real-time business decisions on the performance of various high-level business objectives. Built on Open Source, Openbravo ERP, the application extends numerous customization capabilities and can achieve more automation through little enhancement.

Facts about Openbravo

  • Two million downloads
  • Estimated abandonment rate 90%
  • 200 paying customers
  • In use at all over between 1,500 and 4,000 customers in 27 countries

The Client

The company specializes in B2B online shopping platform (webstore) and claims to be one among the largest shopping audience online for a specific industry. Headquartered in North America, it services a host of international clients online.

Business Case

Client has Webstore system which could be sufficient enough to interface the end user. However it did not have an effective automated order fulfillment and inventory management. Client was looking for an  efficient financial and accounting system integrated. Client did not want different systems, as it could lead to increased system maintenance and the problem of interoperability.

Client envisioned a versatile, dynamic and an interactive portal for their service space. Sigma Infosolutions proposed ERP system, the only solution which has effective inventory management that integrates with better finance and accounting management system. The system can achieve more automation through little enhancement. With this vision, the client approached Sigma Infosolutions to build this application from concept to an end product.

Challenges

The Client had a hard time managing billing operations. One such typical scenario suggests item is discovered, “Not in stock after print/ collate generated”. This ideally means that the inventory is available in stock, whereas there is a probability that the item may have been damaged. Also this will be realized only before packing which will leave you with no solution.

  • Second scenario is when the requested item has been discontinued by the supplier and next edition is readily available, and thus it becomes almost impossible to meet buyers expectation
  • Third scenario of a potential “uneditable order” would be an order where the pick collate is generated, but before the item is shipped, the customer calls to change the order

Successes

We developed “On Hold” status as a solution for this problem with the combination of manual process. Exceptional Order need to be moved to “On Hold” state. The replacement item could be ordered and once it comes back in stock, the item can be combined to the order in the holding area. For second scenario, remove or replace that item from the order. In third scenario, we can physically intercept the order before it leaves the
warehouse.

Solution

Sigma Infosolutions’ Openbravo team successfully compiled the ERP architecture required for the project. Effectively setup the continuous integration infrastructure along with Client’s existing Webstore application.

Key Modules Developed

  • Webstore with Openbravintegration
  • Webstore sync through RESTfull web services
  • Dropship Orders
  • Blanket Orders
  • Multi Pay (scheduled way of payment collection)
  • Shipment Integration with various shippers (FedEx, UPS, USPS)
  • Pick/pack list, collate forms, automated printing (Configure printers would print collate form automatically on pre-printed form)
  • Inventory Locator/Storage Bin hold (Product items would be moved treal storage bin from hold once after QA process gets over
  • Automated Program Billing
  • General Ledger dual posting

Technology

  • PostgreSQL
  • Sun JDK
  • Apache Ant
  • Apache Tomcat

Business Benefits

  • Monthly technical availability is more than 98%
  • An empowered solution to optimize processes across the retail supply chain
  • Complete set of data, functioning alarms in real-time
  • Ongoing operating costs at or better than budget
  • Low system Overhead and lower support costs

Next Phase

The next phase includes integrating Openbravo ERP with market places like amazon and ebay

  • Services:

    • erp
    • erp implementation
    • openbravo
    • openbravo erp
  • Client:

    B2B Online Shopping Platform Company headquartered in North America