tips and tricks for using winshuttle in finance › presentations › ...general tip #4 (my personal...
TRANSCRIPT
![Page 1: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/1.jpg)
Tips and Tricks for using Winshuttle in
Finance
Bob Glitch (SE) | Winshuttle
![Page 2: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/2.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 2
General Tip #1
IF Debits Credits
![Page 3: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/3.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 3
General Tip #1
IF Debits Credits POST
![Page 4: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/4.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 4
General Tip #1
IF Debits Credits POST
IF Debits Credits
![Page 5: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/5.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 5
General Tip #1
IF Debits Credits POST
IF Debits Credits PARK
![Page 6: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/6.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 6
General Tip #1
IF Debits Credits POST
IF Debits Credits PARK
Tip #1
• One change in the mapper • No need to record a second script• Easier Script maintenance
![Page 7: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/7.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 7
General Tip #1 (Screen Shots FB50)
![Page 8: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/8.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 8
General Tip #1 (Screen Shots FB50)
![Page 9: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/9.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 9
General Tip #1 (Screen Shots FB50)
GUI StatusDouble Click
![Page 10: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/10.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 10
General Tip #1 (Screen Shots FB50)
![Page 11: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/11.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 11
General Tip #1 (Screen Shots FB50)
![Page 12: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/12.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 12
General Tip #1 (Screen Shots FB50)
![Page 13: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/13.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 13
General Tip #1 (Winshuttle Mapper FB50)
![Page 14: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/14.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 14
General Tip #1 (Winshuttle Mapper FB50)
![Page 15: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/15.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 15
General Tip #1 (Winshuttle Mapper FB50)
![Page 16: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/16.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 16
General Tip #1 (Winshuttle Mapper FB50)
![Page 17: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/17.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 17
General Tip #2
![Page 18: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/18.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 18
General Tip #2
A Script
Business User
Business User a field
Business User’s
No“in the future” “maybe”
Script
Give to Business User to Test
Business User
week
for a field
![Page 19: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/19.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 19
General Tip #2 (Add a field to an existing script)
![Page 20: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/20.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 20
General Tip #2 (Add a field to an existing script)
![Page 21: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/21.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 21
General Tip #2 (Add a field to an existing script)
![Page 22: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/22.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 22
General Tip #2 (Add a field to an existing script)
Hit F1
![Page 23: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/23.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 23
General Tip #2 (Add a field to an existing script)
Hit F1
![Page 24: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/24.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 24
General Tip #2 (Add a field to an existing script)
Hit F1
![Page 25: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/25.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 25
General Tip #2 (Add a field to an existing script)
Hit F1
![Page 26: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/26.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 26
General Tip #2 (Add a field to an existing script)
Hit F1
Tip #2
• No need to record a new script
• Hide ALL disabled fields
• Copy / Paste
![Page 27: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/27.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 27
General Tip #3 (Properties)
![Page 28: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/28.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 28
General Tip #3 (Properties)
![Page 29: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/29.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 29
General Tip #3 (Properties)
![Page 30: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/30.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 30
General Tip #3 (Properties)
![Page 31: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/31.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 31
General Tip #3 (Properties)
![Page 32: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/32.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 32
General Tip #3 (Properties)
![Page 33: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/33.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 33
General Tip #3 (Properties)
Tip #3
• Use Properties
• Added controls• No Excel Programming
![Page 34: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/34.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 34
General Tip #4 (My Personal Tips)
Excel Functionality is your Friend
• Use the power of Excel
• VBA
• Pivot Tables
• Formulas
• Download into Excel format
• Convert to Excel
![Page 35: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/35.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 35
General Tip #4 (My Personal Tips)
“Roundtrip and Linking”
• Makes Automating a Process Easier
• Don’t miss any data
• Be proactive in finding errors
• Attach documents into SAP
• Don’t forget a step
![Page 36: Tips and Tricks for using Winshuttle in Finance › presentations › ...General Tip #4 (My Personal Tips) “Roundtrip and Linking” • Makes Automating a Process Easier • Don’t](https://reader036.vdocuments.us/reader036/viewer/2022070805/5f038cbe7e708231d4099ac4/html5/thumbnails/36.jpg)
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016 36
General Tip #5
Open Discussion