Manufacturing & Production Reporting System Built using Microsoft Dynamics GP [CASE STUDY]
23 Mar 2016
Production planning & control are the most important processes of manufacturing industry. We developed a custom automated manufacturing reporting system with the primary aim to replace the existing manual Excel-based reporting used for daily production goal planning. The manufacturing software solution was also used to track and measure production against the set goal ensuring an optimum utilization of plant capability and resources. The manufacturing dashboard was integrated in the back-end with Dynamics GP helping to track and visualize inventory across various departments.
Want to Automate your Reporting System?
Get in touch with us!
Objective
For any manufacturing industry, production is the primary driving force to which most other functions react. With the changing business environment in Flexible Intermediate Bulk Container (FIBC) manufacturing, decision-makers are investing in developing software & Management Information System (MIS) dashboards to establish effective production planning process and control methods. MIS for manufacturing industry helps to forecast the uncertainties in internal processes and external deliveries.
Our client wanted to streamline their production planning process with the sales order process to manufacture goods on time and achieve profitability. The client also required a fully automated production reporting system with the primary aim to replace the current manual Excel-based reporting used for daily production goal planning. The system was also used to track and measure production, recovery process against the set goal ensuring an optimum utilization of production capability and resources. The reporting dashboard solution needed to be intuitive, responsive in nature and be accessible seamlessly from the web.
Architecture Diagram – Production Reporting Software
Challenges
- Getting requisites data from Dynamics GP without configuring the web services end-points
- Replicating a similar Excel reporting output and easy-to-use data entry user experience considering the target end-users
- Calculating the inventory & actual production volume at any specific period precisely in an in-direct way without implementing the full-fledge inventory related features
Approach
FIBC manufacturers receive the majority of orders from its field sales officers, which usually have very short delivery deadlines. Rishabh Software’s team used custom .NET development for developing a ASP.NET MVC manufacturing reporting software along with integration to existing Microsoft Dynamics GP 2010 database. The development focus was emphasized on streamlining the complete production & recovery lifecycle starting from item collection from customer locations to final product recovery. The team initially streamlined the manual data entry process by building an equivalent data entry interfaces to input the daily item collections, product recovery, daily production work orders and daily production goal information.
To minimize the duplicate data entry between Dynamics GP and the reporting system, Rishabh proposed to retrieve all key records directly from Dynamics GP database. As a final release, custom reporting engine component was built to generate varied production performance at real-time based on key KPI and metrics with provision to export report data into Excel, PDF and share via email.
Dashboard for Manufacturing and Production Planning
Rishabh Software as a custom enterprise software development company has build manufacturing dashboards like manufacturing process to achieve efficiency in production. The solution was built in a planned phase manner, starting with a “Proof of Concept” to test and validate user acceptance of the proposed concept to developing the final custom solution.
Business Benefits
- Visual presentation of performance measures
- Ability to take informed decisions based on collected business intelligence
- Align strategies and organizational goals
- Gain total visibility of all systems instantly
Industry Segment
- Manufacturing
Customer Profile
- US based Flexible Intermediate Bulk Container (FIBC) manufacturer, operating globally.
Technology and Tools
- Dynamics GP
- ASP.NET MVC 5
- C#
- MS SQL Server
- HTML5/CSS3
- Twitter Bootstrap UI
Get a Free Quote
Talk to our experts to get the best suited software solution for your business
Production Planning and Control Software Solution [CASE STUDY]
The client is ranked as the world’s 3rd leading manufacturer of high quality lens for cataract operations. Client has its offices in India and the UK, manufacturing units in India and operates through its channel partners in European countries. The Business Need for Production Planning System Client had a wide product range approximately 150-styles / power variety of quality lenses.
Automation of Sales Call Planning and Reporting with Salesforce.com [CASE STUDY]
A US based leading supplier of eye health products, such as contact lenses and lens care products through its global business divisions in the Americas, Europe, Middle East, Africa and Asia.
ERP Integration With Dynamics 365 For Bakery Sales Automation [CASE STUDY]
A comprehensive end-to-end solution for bakery business helps keep track of the inventory, products, and packaging, including batch control & traceability.
Online Event Management System Built for a US based Digital Enterprise [CASE STUDY]
Event management is often rated as a tedious and under appreciated task. Event managers need to define goals, schedule events, and plan them carefully on a tight budget. We developed a custom event management solution with a mobile front end to manage various events for a global organization.
