What's New - Features and Enhancements

Release: May, 2019

The best practice is to run the same version of Studio, Foundation, and the Winshuttle Function Module.

For Winshuttle Studio finance and master data templates, see Studio templates on the Winshuttle Community page.

Studio with Connect only

Cross-linking Query and Transaction Scripts
You can download and upload data (or upload and download data) in a single step by cross-linking Query and Transaction scripts, when Excel is your data source. For example, when updating pricing, you can use Query formulas to calculate a new price.

When opening published child scripts from the Add-in, the script icon, script details, and script run settings will be the same as those of the parent script.

Also in the Add-in, you can schedule run cross-linked scripts.

For more information, see the Cross-link Scripts page for Transaction and Query.

Studio with Connect, and
Studio with Foundation/User Governance

Long Text Enhancements
The long text feature now supports the following additional t-codes: AS03, CV03N, FD03, FK03, IE03, IL03, IP03, IP06, IW23, IW33, KS03, ME13, ME33K, ME23N, ME53N, MK03, MM43, MM03, SO10, VA03, VD03, VF03, XD03, XK03.

For more information, see Record Long Text. (For Studio with Foundation/User Governance, see Record Long Text.)

Business Partner Transactions
F4 Help and Field Descriptions are supported for working with Business Partner transactions. (SAP S/4HANA necessitates this capability.)

Run Settings and Validation Improvements
1. In Transaction, in the Add-in (and for macros), you can now process run, validate, and simulate Error Rows and Unprocessed Rows in a single step. For more information, see Run a Transaction Script, Run Settings for Transaction, and Validate Data. (For Studio with Foundation/User Governance, see Run Transaction Script.)
2. You can turn off log column Headers, for manual runs only.
3. You can edit the log column within Add-In, for manual runs only.

F4 Help for BAPI
BAPI scripts support input help values.

Sorting Data
In English locales, Query supports data sorting for new data sources (data sources in addition to XML, which has been supported to date).
Query also supports sorting data which has been downloaded to Excel from SAP.

Conversion Exit
Conversion Exit is supported on the field level, enabling the use of formatting operations such as zero padding. For more information, see the "Select the fields" section on the Choose Query Tables and Fields page. (For Studio with Foundation/User Governance, see Choose Query Tables and Fields.)

GOS Attachment Option
There is a new GOS attachment option in Studio, available when running the Winshuttle Function Module (WFM).

Additional Support
Certification for SAP S/4HANA 1809 (certified December 20, 2018), and support for Microsoft Office 2019 (Excel 2019) and SAP GUI 760.

Studio with Foundation/User Governance only

Enable Detailed Task List
A new Foundation Preference, Enable Detailed Task List, used with the Excel Add-In task list, allows you to view different custom workflow libraries and detailed tasks listed under those libraries. You can:

  • Prioritize tasks and sort them by selecting a column header; then, you can approve tasks in order of priority.
  • Choose the columns which will be visible in the table in each Document library.

For more information, please see Foundation Settings - Preferences in the Foundation Online Help.

Validation Support for BAPI Scripts on Production SAP Systems
Script developers can choose to use BAPI scripts as validation scripts, allowing the scripts to be validated before submission to a workflow. For more information, see Validation Script.

Manage Supporting Documents
If issues are discovered at any step in the workflow process, the person preparing journals can edit supporting documents to resolve those issues. For more information, see Manage Supporting Documents.

Sign Out from the Add-in
From the Add-in, you can sign out from all open Excel instances. After signing out, close all open Excel instances (they will not close automatically). For more information, see Sign Out from the Add-in.

Additional Support
Support for Microsoft SQL Server 2017 and Microsoft SQL Server: Always On