1

Simplify mass maintenance for your SAP Master Data using Excel

Copyright Winshuttle 2017

2

Achint VariaSolutions Engineer

London, UK

Justin ThomasDirector

London, UK

3

The cost of bad data

Trillion a year in the US

$3.1

IBM

Million a year per organization

$14.2

Gartner

32%Average amount of bad data in US companies

Experian Data Quality

44

Why good master data is so critical

Transactional data

Master data

BUSINESSANALYTICS

REPORTING DECISIONMAKING

Invoices, sales orders, purchase

orders, work orders, journal

entries, etc.

Conditional data:

Pricing, BOMs, recipes/routing,

production version, etc.

Master data: Material, Vendor,

Customer, Finance

Reference data: Company codes,

plant codes, profit centers,

etc.

55

POLL #1

How are you maintaining your Master Data today?

66

WINSHUTTLE DEMO

Business user experience- Material Setup (Master Data)

- Pricing records (Application Data)

Author experience- Material Create (Master Data)

Winshuttle with Excel

77

SAP data management with business-friendly Excel

88

Creating a Winshuttle script

Mapthe fields

Recordthe script

Runon SAP

9

Three critical success factors of Data Management

QualityAvoid costly business

interruptions

SpeedDon’t delay critical business activities

FlexibilityMake continuous

improvements

1010

Scenario 1

MADE EASIER BY:

• Modern visual interface

MADE POSSIBLE BY:

• Role separation

• Interactive error-handling

• Fail-safe backup

ITUse Winshuttle Studio to develop scriptsEmbed in ExcelRoll out to users

BUSINESS USERSUse Excel to provide dataRun scripts Handle errors

1111

Provide dataRun scripts Handle errors

Develop scripts

BUSINESS DEVELOPER

BUSINESS DEVELOPERS CAN:

• Create solutions without technical coding skills

• Share solutions viatemplate library

BUSINESS USERS

IT CAN:

• Approve scripts

• Set user policies

• Get full audit reports

ITAdministers Winshuttle

Scenario 2

1212

POLL #2

Which master data areas do you have challenges maintaining?

13

• Leading automotive aftermarket supplier

• Over 150,000 products and growing

• 5 plants, lots of master data complexity

• IT were using LSMW, but Dorman chose Winshuttle for business users

Dorman speeds through master data changes

14

Challenge:

• Change subset of materials from ‘Manufactured’ to ‘Kitted’

• Update BoMs and Routings

• Change sales order to reflect non-kitted materials

Dorman speeds through master data changes

15

Key automation steps

‘Block’ materials

Add order lines back to sales orders

Update material master, BOMs,

routings

Extract relevant lines &

schedule dates

Cancel applicable

lines in sales orders

16

Results with Winshuttle

Dramatic time savings

Minimal business impact

Improved data quality

Hours Days Labor Rate Total Cost Difference

Manual Processes 60 5 days $75 $4,500

Using Winshuttle 5 1 day $75 $375 $4,125 saved

3,000 materials converted in Q4, 2016 Savings = $123,750

PER 100 MATERIALS

17

Q&A

Let’s answer some questions

18

Upcoming events and webinars….

www.winshuttle.com/events

Webinar

Solve Customer Master Data Challenges

30 May 2018

PIDX International

London, UK

5 June 2018

19

The time to act is NOW !

Contact us

Set up a 30 minute personalised demo

UK: +44 (0) 208 879 5400

WSSales-UK@winshuttle.com

winshuttle.com

Demos

White Papers

Case Studies

Agree Plan ACT

20

Thank you Visit winshuttle.com for more information.