Automating Work Orders in NetSuite Using Custom Suitelets
The Challenge: Manually Having to Input Inventory Data (SN and Lot #) in Work Orders
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.
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 Missouri Star Quilt Co
Location: Hamilton, Missouri Industry: Retail, Consumer Business Number of Users: 200+ Number of Subsidiaries: 2
The Solution: Automating Work Orders, SN and Lot # via Custom NetSuite Suitelets
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 Automation
1. Take time locating a specific work order in NetSuite
2. Click to open
3. Click ‘Create Build’ to open Assembly Build page
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.
About the author, Thierry Senior NetSuite ERP Consultant, Solution Architect and Developer @OdeCloud
Thierry with Colin Emberley, NetSuite Administrator at Missouri Star Quilt. Thierry has over 15 years of experience with Enterprise Resource Systems (NetSuite, MS Dynamics SL, Movex Lawson), Database development (TSQL, DML, DDL), Javascript and .NET.
OdeCloud is proud to remain the Missouri Star Quilt Company’s favorite NetSuite service provider.
Click here for more information on hiring a NetSuite consultant on OdeCloud.
For another OdeCloud NetSuite case study, click here.
Thierry has over 15 years experience with Enterprise Resource Systems (NetSuite, MS Dynamics SL, Movex Lawson), Database development (TSQL, DML, DDL), Javascript and .NET. Thierry has partnered with OdeCloud for over 4 years to support businesses in various industries including Manufacturing, Wholesale, Distribution and Software.
Thierry has over 15 years experience with Enterprise Resource Systems (NetSuite, MS Dynamics SL, Movex Lawson), Database development (TSQL, DML, DDL), Javascript and .NET. Thierry has partnered with OdeCloud for over 4 years to support businesses in various industries including Manufacturing, Wholesale, Distribution and Software.
Be inspire and inspire others – He are thoughts on things we care about. Some personal projects we are really proud of. And many other things that makes OdeCloud very unique.
