Case Study Direct Ship Supply Chain Management System
www.brainvire.com | Š 2013 Brainvire Infotech Pvt Ltd
Page 1 of 1
Client
Requirement
This project envisions replacing DTCMO and WS Interlink with Sterling and a custom UI layer as the order management and DS vendor portal solutions. Background: Currently drop ship POS are tracked through the WS Interlink application. Sales orders are created in DTC-MO and POs are created and then interfaced to WS Interlink (WSIN). Vendors can view and do fulfillment related transactions in WSIN. After shipment they trigger invoicing through WSIN. The project envisages implementing DS fulfillment process using Sterling as the Order Management/ DS PO Management system and a custom UI as the vendor portal. Customer orders will be captured in Web store and DTCMO and will be interfaced into Sterling. Sterling will support sourcing decisions and ECDD calculations for DS items. Orders created in Sterling will go through the sourcing/ scheduling logic that will drive the creation of DS POs in Sterling. DS vendors will view, manage and fulfill these POs by accessing the custom vendor portal UI, which will directly interact with Sterling for business data and core business logic. Sterling will interface with DTCMO and Lawson to report shipment confirmations and vendor invoices. Objective: This project’s primary objective is to replace the existing DTCMO/ WS Interlink-based system functionality with Sterling/ custom UI-based applications and in the process, also improve the DS fulfillment process by removing some of the limitations of the existing applications. The WS Interlink Replacement project’s objective is to provide: •
Foundation for additional Direct Ship capabilities and phase out portions of Legacy order management system.
•
Remove limitations in existing WS Interlink solution—personalization, order updates, lack of automation via EDI, cartonization and service-level optimization.
Project Benefits: The Project benefits include: • • • • •
Efficient order management (modifications and visibility) and direct ship vendor capacity management Providing Revenue upside due to the enhanced personalization (images) Savings in transportation costs Reduction/elimination of licensing fees for WSI interlink in longer term More accurate delivery date calculations during order entry
www.brainvire.com | © 2013 Brainvire Infotech Pvt Ltd
Page 2 of 2
Current Drop Ship Flowchart:
Orders entered in DTC MO System
File DSBILP (For accounting system, contains order information)
PO Generation process
Order info (HOST CR00) HOSTCR00 only contains Exel shipments
Nextier (Carrier Exel system)
PO transmitted to WSInterlink through Unix System at WSGC
Vendors
WSInterlink database
World Ship
Load PO's to vendors' accounts
Shipping labels (ups_wsimp ort.cxv)
PO's PO's
UPS
Invoices, Acknowledgement, Ship Status will be captured in DSEFXINV file
UPS Bar Code labels
Vendor performs "End of Day" process from World Ship System
PSB and PLD Reports
UPS Database
"End of day process" upload shipping information from WorldShip to UPS Database
Customers call and place the orders
WSInterlink
Vendors download labels to World Ship
WSGC
PUP & POD
Memphis (PKMS) DSEFXINV file Shipping information
DTC MO System
Invoice file transmitted through Unix System at WSGC Update ship lines
Revenue Recognition / Update Accouting systems
Shipping Information from UPS Database to Memphis
Note: File NDTCYYMMDD contains shipment data from UPS for Drop Ship shipments
www.brainvire.com | Š 2013 Brainvire Infotech Pvt Ltd
Page 3 of 3
Technologies Used Sterling Commerce 8.5
Sterling Product for Order Fulfillment.
Core Java
A suitable managed code development environment for handling the extensive project.
Red hat Linux
Sturdy and stable operating system with high level functionalities for online development.
Oracle
Installed as part of the Sterling Product to manage various branches of Order Fulfillment.
Microsoft Visio
Integrated tool best suited for modular architecture and iterative development of software.
Eclipse Indigo
Versatile web development tool with exhaustive support for various server-side scripting frameworks and CSS, JavaScript.
Subversion (SVN)
Ideal application providing stratified storage and back up of code files.
Manpower
Project Leader
2
Developers
6
Designers
4
Quality Assurance Testers
Managed at Client’s End.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt Ltd
Page 4 of 4
Planning The following pain points will be resolved by generating custom components using Sterling Product: • •
• •
•
Current U/I does not have a practical search functionality to view order lines at the customer order level; leading to processing errors. Currently, ship confirmations are received by customers the evening after the item has been shipped. For all items being shipped via UPS Next Day Air, the item shows up after the goods have been received by the customer. Buyers must search for needle in haystack to find problem orders. Would like exception reporting to minimize manual effort. Vendors updating items to be shipped prior to actual shipment resulting in customer billing early. Vendors not ship confirming order and customer doesn’t get billed resulting in fixing manually by Inventory/Care Center. Cancellations don’t succeed and customer gets billed and receives item.
www.brainvire.com | © 2013 Brainvire Infotech Pvt Ltd
Page 5 of 5
Interface flow:
www.brainvire.com | Š 2013 Brainvire Infotech Pvt Ltd
Page 6 of 6
www.brainvire.com | Š 2013 Brainvire Infotech Pvt Ltd
Page 7 of 7