Official sponsor of Oracle-NetSuite SuiteWorld 2025 in Las Vegas, October 6–9! 🎉.

Consolidated Picking Ticket Saved Search with Barcodes

network

Customer Challenges:

The way NetSuite manages picking tickets natively, by printing a pick ticket per order, had slowed down the warehouse operations since the NetSuite go-live. The customer wanted a way to group orders for which items needed to be picked in the same zone within the warehouse in a consolidated “printable” list. They also wanted that list of orders to have barcodes compatible with code 39 and code 128 RF guns, as they wanted to use this list as a traveler sheet to expedite the picking process.


About the Customer:

Company: Missouri Star Quilt Co.
Location: Hamilton, Missouri
Industry: Retail, Consumer Business
Number of Users: 200
Number of Subsidiaries: 2


Solution:

It seems that the way NetSuite handles picking tickets is cause lot of delay in the warehouse as each order is printed on individual sheet and not grouped by picking zone.

Let the software do the heavy lifting

The trick here is to find an extremely creative solution leveraging one or a combination of  out-of-the-box features. Going back to the problem. The goal was to group multiple picking tickets by warehouse bin on a single page. When I hear group transaction with a specific set of rules, I am thinking Saved Search. That would allow to group all orders pending fulfillment by bin where those items are located. That works!

There is so much you can do with Saved Search

For Missouri Star, the next step was to ensure that whatever solution we came up with will be able to display scannable barcodes, as most of their warehouse operations are performed using RF guns. We built a saved search that inlined barcode for use with Code 39 and 128 RF guns. The saved search displayed on each line a scannable Order #, scannable work order # and scannable Item #. We arranged the column properly so it prints easily as a PDF document. We optimized the search to make it easy to pick component of assemblies.

We optimized the saved search to groups orders by picking zone (bins), eliminating the need for multiple travels to same location within the warehouse to picks orders with same item.


With this optimization project, Missouri Star is now able to ship orders faster. The grouping of orders for a specific picking zone has made their picking process much more effective. The inlined barcode allows them to expedite the picking process with literally no manual data entry

Most importantly, the multiple orders on one page have saved hundreds of trees since the solution was implemented.

Feature Setup and Technical Highlights:

Transaction Saved Search on pick tickets. Barcode formula….

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 

Trending Articles

NetSuite Consulting Services Guide: Expert Insights for 2026
NetSuite Skill Improvement Remains Top Priority for OdeCloud Community
NetSuite Inventory Management: Everything You Need To Know
Make More Time for You and Your Family By Becoming a Freelancer
The Essential Guide to Fractional Consulting in 2026

Trek Travel Streamlines Travel Protection Integration with OdeCloud’s experts

Looking to streamline your operations with more automations? Keith shares an OdeCloud project.

#netsuite

#integrations

Project Outcomes

This new integration system transformed our travel protection service.

  1. Efficiency Gains: Completely automated the process, eliminating the need for monthly roster reconciliation.
  2. Enhanced Guest Experience: Guests benefited from a smoother booking process with transparent travel protection options tailored to their needs.
  3. Accuracy in Pricing: The integration ensured precise calculations based on complex variables.
  4. Scalability: The system can easily accommodate future growth and changes in travel protection offerings.

Background

Our company offers guests the option to protect their travel investments through a travel protection plan. This service is crucial, as it provides coverage in cases where guests need to cancel their trips due to unforeseen circumstances such as illness or emergencies. However, the process for managing this service was previously cumbersome and inefficient, requiring manual coordination and reconciliation with the travel protection partner.

Challenge

We needed a seamless integration within NetSuite to handle complex calculations for travel protection costs. The solution needed to account for multiple variables, including:
Guest-specific factors such as age and location.
Travel details like destination, total cost, and type of coverage (e.g., pre-trip hotels, post-trip hotels, flights).
Dynamic pricing calculations based on these variables.

Before partnering with OdeCloud, the process was manual and error-prone, involving monthly exchanges of rosters between our team and the travel protection provider. This created inefficiencies and delayed customer service.

Solution

OdeCloud worked with us to design and implement a fully integrated travel protection solution within NetSuite. Key features of the solution included:


1. API Integration: OdeCloud enabled real-time communication with the travel protection partner’s API. This allowed us to dynamically calculate the cost of travel protection based on the guest’s specific details.
2. Seamless Booking Experience: The integration allowed the travel protection cost to be automatically added as a line item to guest bookings within NetSuite.
3. Flexible Adjustments: Guests could easily add or cancel travel protection directly through NetSuite without requiring interaction with third-party systems.
4. Eliminating Manual Processes: The previously manual reconciliation process was replaced with automated inline API transactions, eliminating errors and saving significant time.

Conclusion

This integration is one of the most impactful projects we’ve undertaken, and it holds a special place in our transformation journey. With OdeCloud’s expertise, we achieved a solution that not only streamlined operations but also elevated the guest experience. This project exemplifies the power of technology in solving complex business challenges and enhancing customer service.