100 likes | 704 Views
Retailer MFG. Data Integration: Connecting to the World 3PL Web Store Presented By Kevin Hoyle Shannon Systems/B2BGateway Sales Orders 850 Purchase Orders K-Mart Staples Sears iRiver Amazon EDI Case Study (iRiver- Purchase Orders inbound to NetSuite)
E N D
Retailer MFG. Data Integration: Connecting to the World 3PL Web Store Presented By Kevin Hoyle Shannon Systems/B2BGateway
Sales Orders 850 Purchase Orders K-Mart Staples Sears iRiver Amazon EDI Case Study(iRiver- Purchase Orders inbound to NetSuite) • iRiver is sent Purchase Orders in any format and by any means. • POs are sent via VAN, FTP, HTTP or even through e-mail. • POs are formatted into sales orders and are automatically loaded into NetSuite via System to System and WebServices. • iRiver sells personal electronics (MP3 players) to K-Mart, Staples, Amazon, Sears, BestBuy, OfficeDepot, Etc. SMB XML B2BGateway
Invoices 810 INV and 856 ASNs K-Mart Staples Sears B2BGateway iRiver Amazon EDI Case Study(iRiver- Purchase Orders inbound to NetSuite) • Invoice data is automatically extracted from NetSuite for each of the EDI trading partners. • Invoice data is separated and formatted then it is sent to each of the retailers. In order to be paid for the goods sold, iRiver needs to electronically send invoices to each of the retailers. • Each Retailer has their own requirements and specifications for the receipt of these transactions. B2BGateway
CED DBL ALMO B2BGateway NorthStar Petra EDI Case Study (NorthStar – Sell/Buy Business model) • Yahoo and Amazon request Inventory information from NorthStar • Web Based orders are converted and auto uploaded Web Orders into NetSuite as Sales orders and sent as Purchase orders to manufacturers. • Inventory gets updated in NetSuite, Invoice info is set to NetSuite. • Tracking information is updated on the sales order. Web Orders Purchase Orders Sales Order Tracking No. Inventory update Invoice
E-Mailed order from Boeing Boeing Order for Mobile Phones LexAir Non-EDI Case Study(LexAir) • LexAir sells Mobile Phones, Pagers and related accessories to Boeing Aircraft Company. • Each time a new employee is hired by Boeing, an order for a new phone and phone accessories is e-mailed to LexAir. • LexAir then keyed (typed) 500 orders per day into NetSuite.
Sales Orders E-Mailed order from Boeing Boeing Order for Mobile Phones Order for Mobile Phones B2BGateway NetSuite User LexAir Non-EDI Case Study(LexAir) • Keying in orders is bad for business, costly and prone to errors. (LexAir had 5 order entry people on staff.) • E-Mailed orders are received from Boeing, maped into a NetSuite format and automatically imported. • No more order entry, no more mistakes and a significant savings in payroll.
SageRyder WebSite Case Study(SageRyder) • SageRyder/VergePoint owns ProjectorLampCenter.com and BigScreenCenter.com which are successful Web Stores. • SageRyder wanted to use NetSuite…but didn’t want to give up their established Web store investments. ?
SalesOrders B2BGateway SageRyder WebSite Case Study(SageRyder) • The external Web stores, were integrated so NetSuite users can keep their existing web presence and still use NetSuite. • Web Based sales orders seamlessly and automatically integrated with NetSuite.
Ship Request 3PL 850 Purchase Orders Amazon K-Mart Staples Sears NetSuite User 3PL Case Study(Third Party Logistics, Outsourced Warehouse) • NetSuite can integrate with 3PLs, (outsourced warehouses) so that order fulfillment can be handled by a shipping/warehousing company. • NetSuite is seamlessly and automatically integrated with Third Party Logistics (3PL) companies that may (or may not have) EDI capabilities. Sales Orders B2BGateway
John Deere NetSuite User B2BGateway Inventory Feed Case Study(item Availability) • John Deere needs to have access to NetSuite inventory info. • John Deere posts an XML request for Inventory Item availability • A Web Services request for Item availability is sent to NetSuite. • Inventory information is sent back and converted to the XML response for John Deere. Web Services Inventory Info Request Post XML Request for Item info Item Number On hand Price Date Info . XML response with Item info