ERP Integration with Ecommerce and Warehouse
The project involved connecting different platforms to capture all business transactions into ERP (online sales, warehouse despatches, invoices).
Main software integrated
The company was using Sage 200 ERP for the management of sales, orders, purchasing of stock. The stock was not tracked and the ERP was not connected to other solutions.
The 3rd party warehousing partner was using Delta WMS for managing customers orders, dispatching orders and shipping to customers. A closer integration with ERP was needed
The company was using WebselectEcommerce platform for the management of online orders. A link existed between the Ecommerce platform and the Warehouse but not with the ERP
Integration at Lily's Kitchen
[Photo: courtesy of Lily's Kitchen.] The established business pet food manufacturer needed to get full traceability of its stock through Sage, connect Ecommerce transactions to Sage and increase its use of Sage 200 to capture the full Purchase to Pay Cycle.
Project Execution details
The project spanned 11 months, involved coordinating a team of 5 companies (3 Company’s internal users, 1 web developer, 1 Warehouse IT Manager, 1 Sage business partner, 1 EDI solution supplier).
I used Sage200 ERP (All modules). I also used Windows 2012 R2, SQL Server, FTP Servers, Prince2 project methodology,
Krishna Boukadia used Sage200 ERP (All modules). I also used Windows 2012 R2, SQL Server, FTP Servers, Prince2 project methodology, design of process maps and guiding documents and trainings .
Business analysis and Project management
The company was underutilizing Sage 200 modules (stock modules, Stock- GL integration, Bills of material). After doing business analysis of the company’s process and defining the ideal process, I advised the company on the best route to take to reach full Purchase to Pay (P2P) integration and track inventory levels directly from the ERP system. I defined the Project Brief with the Company’s Executive.
I project managed the execution of the various aspects of the project: finalised the execution of the web integration between Website platform and Sage (EDI), ensured all transactions are captured and transactions in the nominal ledger are understood (GL transaction mapping), introduced the use of system generated Purchase Orders, Bills of Materials to capture the Inventory management modules, Units of measures,
Process and Trainings:
I organised training workshops to ensure the new processes were understood and applied. I have created a detailed list of instructions and documented the new system processes. Key attention given to customer satisfaction and to ensure the use of already bought addons was maximised to limit customisations and keep costs under control.
The company can now manage the full Purchase to Pay cycle and captures stock data live and the real cost of sales.
Photo of meeting with clients