The Challenges: Manually Having to Input Inventory Data
Automating work orders using a NetSuite Suitelet can do wonders for your business’ overall speed and efficiency. Unfortunately, not many companies have the time or expertise needed to develop custom Suitelets.
Missouri Star Quilt Company (MSQC), an OdeCloud client, was having issues recording individual work orders through NetSuite.
It would take far too much time finding a specific work order, only to force them to go through the hassle of having to manually fill in inventory details — just to create ONE assembly build.
About the Customer
Company Name: Missouri Star Quilt Co.
Location: Hamilton, Missouri
Industry: Retail, Consumer Business
Number of Users: 200+
Number of Subsidiaries: 2
The Solution: Automating Work Orders
OdeCloud assigned NetSuite expert Thierry Klesse to tackle MSQC’s problem concerning their work orders. Creating two custom Suitelets, Thierry was able to expedite their business processes exponentially.
Sticking to OdeCloud’s promise of making things fast and easy, Thierry’s Suitelets allowed MSQC to simply scan a work order, bringing up a summary of all necessary information regarding that order: the work order number, assembly item, product image, quantity to build, serial/lot number, bin, and more.
Furthermore, serial/lot numbers were programmed to autofill based on pre-established criteria, and the bin field utilized an algorithm to autofill based on the previously determined bin.
After submitting a work order, the page would automatically revert back to the original screen, allowing MSQC to easily scan work orders in rapid succession.
The Process of Automating Work Orders
Work Order Process - Before OdeCloud
1. Take time locating a specific work order in NetSuite
2. Click to open
3. Click 'Create Build' to open Assembly Build page
4. Manually fill inventory details
5. Click to save Assembly Build
6. Manually navigate back to Home screen
7. Repeat
Work Order Process - After OdeCloud
1. Scan Work Order
2. Review Information
3. Repeat
The Results from Automating Work Orders
After rolling out the solution and after they had used it for a few weeks I asked the main point of contact at the customer how things were going with the solution, if they had any problems.
He told me that there were no problems and furthermore the operations department had seen a measured time improvement in cutting fabrics. He was very happy to tell me that the time taken for the cutting fabrics process had improved by 75%.
As a developer/consultant, things can be very abstract and it is not always made clear that your solutions have such a large real world impact. For me, it is always great to hear that the solutions I implement have a concrete impact on my customers.
Thierry Klesse,
Senior NetSuite ERP Consultant @OdeCloud
OdeCloud is proud to remain the Missouri Star Quilt Company’s favorite NetSuite service provider.
For more information, contact us!
For another OdeCloud NetSuite case study, click here.
About Thierry Klesse
Thierry Klesse, Senior NeSuite Solution Architect and Developer, designed and built this solution in collaboration with Colin Emberley, NetSuite Administrator at Missouri Star Quilt. Thierry has over 10 years experience with Enterprise Resource Systems (NetSuite, MS Dynamics SL, Movex Lawson), Database development (TSQL, DML, DDL), Javascript and .NET
