Case Study Direct Ship Supply Chain Management System
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 5
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 Direct Ship fulfillment process using Sterling 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 to improve the DS fulfillment process by removing some of the limitations of the existing application. 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 5
Current Drop Ship Flowchart:
Orders entered in DTC MO System
File DSBILP (For accounting system, contains order information)
PO transmitted to WSInterlink through Unix System at WSGC
PO Generation process
Order info (HOST CR00)
Nextier (Carrier Exel system)
WSInterlink database
Shipping labels (ups_wsimp ort.cxv)
PO's
UPS
World Ship
Load PO's to vendors' accounts
PO's
HOSTCR00 only contains Exel shipments
Vendors
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
Technologies Operating System & Server Management
Development Tools & Environments Database
Used Red Hat Linux OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance Sterling Commerce 8.5, Core Java, Microsoft Visio, Eclipse Indigo, CSS, JavaScript, SVN etc. Oracle Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 5
Manpower Project Leader
2
Developers
6
Designers
4
Quality Assurance Testers
Managed at Client’s End.
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 early customer billing. Vendors will 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 4 of 5
Interface Flow
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 5 of 5