In the realm of efficient warehouse management, syncing purchase orders seamlessly is a critical task. For Bacchus Wine Merchants, the challenge was to automate this process based on the warehouse location. With NetSuite as their backbone, they needed a solution that would send POs to specific Carton Cloud accounts based on the destination.
Warehouse Routing Logic
Bacchus Wine Merchants operates in two key locations, each with its designated Carton Cloud account:
- BW01-SYD: Orders are routed to the NSW warehouse at Provino LogisticsBacchus NSW Sandbox.
- BW02-BNE: Orders are directed to the QLD warehouse at Outrayjus SANDBOX BACCHUS.
Solution Architecture
To achieve this, two key components were developed:
- User Event Script: A ‘Send to Warehouse’ button was added to the purchase order record for BW01-SYD and BW02-BNE locations. Clicking this button triggers the integration process.
- Suitelet Script: A Suitelet script was developed to integrate NetSuite with the respective Carton Cloud accounts. This script facilitates the transmission of POs to the correct warehouse based on the location.
Process Flow
- Clicking the ‘Send to Warehouse’ Button: When the user clicks the ‘Send to Warehouse’ button, the order is sent to Carton Cloud (CC).
- Status Update: The ‘Order sent to CC’ checkbox is automatically checked in the purchase order record, indicating successful transmission.
- Order ID Display: A custom field ‘Order CC ID’ displays the order ID after a successful sync, providing visibility into the synced order.
- Error Handling: A custom field for displaying error messages in the PO record ensures that any issues in the integration process are logged and addressed promptly.
Conclusion
By implementing this solution, Bacchus Wine Merchants has streamlined their warehouse integration process, ensuring that orders are routed to the correct warehouse based on location. This not only improves operational efficiency but also enhances order accuracy and customer satisfaction.