GL Wand for SAP

Authorizations wild card settings support (Release 3.91)

5 days ago

Authorizations wild card settings support added.

See the 3.91 user guide for more detail.

Public Sector New GL Funds Management (Release 3.91)

6 days ago

Public sector New GL Funds Management function added.

See the 3.91 user guide for more detail.

Public Sector Classic Funds Management (Release 3.91)

7 days ago

Public sector Classic Funds Management beta function added.

See the 3.91 user guide for more detail.

Public Sector Classic Grants Management (Release 3.91)

11 days ago

Public sector Classic Grants Management beta function added.

See the 3.91 user guide for more detail.

Value type and business transaction parameters (Release 3.91)

12 days ago

Value type and business transaction parameters added to CO functions.

See the 3.91 user guide for more detail.

Transaction parameter (Release 3.91)

14 days ago

Transaction parameter added to PCA function.

See the 3.91 user guide for more detail.

Drill down (Release 3.91)

14 days ago

Value date field added to line item drill down. Reference key 1,2 and 3 added to document drill down.

See the 3.91 user guide for more detail.

Projects (Release 3.91)

15 days ago

Orders linked to project objects support added.

See the 3.91 user guide for more detail.

SAP Connector (Release 3.91)

15 days ago

Upgraded to the latest SAP .Net Connector 3.0.11.0.

See the 3.91 user guide for more detail.

Duplicate Formulas (Release 3.91)

19 days ago

Duplicate formulas are now individually refreshable.

See the 3.91 user guide for more detail.

GL account master data (Release 3.91)

19 days ago

Option to persist GL account master data between sessions for sites with many company codes.

See the 3.91 user guide for more detail.

Descriptions (Release 3.91)

20 days ago

Descriptions cached when retaining balances.

See the 3.91 user guide for more detail.

Network activity (Release 3.91)

20 days ago

Network activity authorization performance improvement.

See the 3.91 user guide for more detail.

Group Optimization (Release 3.91)

22 days ago

Group optimization process improvement.

See the 3.91 user guide for more detail.

Currency (Release 3.91)

22 days ago

Currency parameter added to Classic GL, New GL and Custom New GL functions.

See the 3.91 user guide for more detail.

64 bit Excel support (Release 3.91)

25 days ago

Support for 64 bit Excel added.

See the 3.91 user guide for more detail.

Union of accounts (Release 3.91)

25 days ago

Option to use union of GL accounts for alternate account functionality.

See the 3.91 user guide for more detail.

Localization (Release 3.65)

7 November 2012

Support added for English Excel users with non-English regional settings.

See the 3.65 user guide for more detail.

Function linking (Release 3.65)

5 November 2012

Automatic re-linking of product functions where required. Functions are automatically relinked if necessary when opening a workbook to prevent common formula prefix issue.

See the 3.65 user guide for more detail.

Project Creation Date (Release 3.65)

30 October 2012

Project creation date setting added to limit project data retrieved.

See the 3.65 user guide for more detail.

Responsibility Area Authorizations (Release 3.65)

26 October 2012

Support for authorizations set at the responsibility area in SAP added.

See the 3.65 user guide for more detail.

Authorizations performance (Release 3.65)

25 October 2012

Authorizations testing performance improved.

See the 3.65 user guide for more detail.

Add-in Activation (Release 3.65)

24 October 2012

The ribbon add-ins will automatically activate their related product add-in.

See the 3.65 user guide for more detail.

Financial Statement Sets (Release 3.60)

17 October 2012

An option has been added to allow the financial statement sets to be included in the list of account groups.

See the 3.60 user guide for more detail.

Greater than 16 periods reporting (Release 3.60)

12 October 2012

The ability to report on New GL parallel ledgers that have been configured with a fiscal year variant of more than 16 periods has been added.

See the 3.60 user guide for more detail.

Refresh Expand (Release 3.60)

9 October 2012

The ability to re-execute a previously expanded hierarchy has been added.

See the 3.60 user guide for more detail.

Get Project Systems Function - Beta (Release 3.60)

8 October 2012

A new get balance function has been added to enable retrieving balances for Project Systems objects.

See the 3.60 user guide for more detail.

Get Object Description (Release 3.60)

5 October 2012

A new parameter and wizard have been added to the object description function to enable the retrieval of master data attributes.

See the 3.60 user guide for more detail.

New version released (3.53)

17 July 2012

A new version (3.53) has been released and incorporates some important bug fixes.

See the 3.53 user guide for more details.

Option for Statistical Values (Release 3.45)

14 May 2012

Option added to include statistical values for CO get balance functions included in the balance and drill downs.

See the 3.45 user guide for more detail.

Descriptions for Lists and Ranges of Values (Release 3.45)

10 May 2012

The Get Description and Get Company Code functions now return results for lists and ranges of values.

See the 3.45 user guide for more detail.

SAP GUI 7.20 saplogon.ini file location (Release 3.45)

8 May 2012

The new SAP GUI 7.20 saplogon.ini file location has been catered for.

See the 3.45 user guide for more detail.

Alternate Account for Classic GL (Release 3.45)

7 May 2012

The Alternate Account parameter has been added to the Classic GL function.

See the 3.45 user guide for more detail.

Display Cleared Line Items (Release 3.45)

3 May 2012

Option added to display cleared line items in the GL drill down.

See the 3.45 user guide for more detail.

New Balance Types for Calendar Year Reporting (Release 3.45)

3 May 2012

CALY for Calendar Year To Date and CALP for Calendar Period To Date balance types added to all functions.

See the 3.45 user guide for more detail.

Trading Partner Balances in PCA function (Release 3.45)

1 May 2012

Balances in the PCA function can be extracted by Trading Partner.

See the 3.45 user guide for more detail.

Activity Type Dollar Values (Release 3.45)

1 May 2012

The Activity Type parameter on the CCA function allows extraction of dollar values for activities.

See the 3.45 user guide for more detail.

Expand Hierarchy (Release 3.45)

27 April 2012

Expand Hierarchy functionality now automatically expands formulas as well. A single level or all level expand option is available.

See the 3.45 user guide for more detail.

New GL Quantities (Release 3.45)

27 April 2012

Quantity Balances can be retrieved for the New GL and the Custom New GL functions.

See the 3.45 user guide for more detail.

Multiple Company Codes per function (Release 3.45)

27 April 2012

Multiple Company Codes may now be used in the Classic GL, New GL and Custom GL functions.

See the 3.45 user guide for more detail.

Reports Distribution Manager (SAP)

22 April 2012

Refresh All Workbooks (Release 3.45)

22 April 2012

An additional refresh calculation option is available to refresh all open workbook calculations.

See the 3.45 user guide for more detail.

Representative Material (Release 3.15)

25 January 2012

Feature Description: Balances by Representative Material can be retrieved from the PCA get balance function. Feature Benefit: Additional get balance parameter in the PCA function.

Quantities for PCA line items (Release 3.15)

29 December 2011

Feature Description: Quantities are an available field for PCA line item drill downs. Feature Benefit: Improved drill down capability.

Drill to FI or CO document (Release 3.15)

29 December 2011

Feature Description: In a CCA line item drill down it is possible to drill further to either the FI or CO document should an FI document be available. Feature Benefit: Improved drill down capability.

Optimize Groups (Release 3.15)

29 November 2011

Feature Description: The user has the option to Optimize Groups which can result in improved performance. Feature Benefit: Improved performance.

Cache On Demand (Release 3.15)

8 November 2011

Feature Description: Master Data is now cached on demand. Feature Benefit: Improved log on times.

Unlock Administrator (Release 3.15)

8 November 2011

Feature Description: A code can be requested from Excel4apps to unlock the Administrator functions. Feature Benefit: User assistance.

Session timeout (Release 3.15)

7 November 2011

Feature Description: The Wand Administrator can set a session timeout value so that inactive users are automatically logged off. Feature Benefit: Enhanced security.

Leverage .Net Architecture (Release 3.15)

31 October 2011

Feature Description: Leverage of the .Net Architecture has improved performance and the user interface. Feature Benefit: Performance and ease of use.

Company Code parameter for PCA function (Release 3.15)

31 October 2011

Feature Description: The Company Code has been added as an additional parameter on the PCA balance function. Feature Benefit: Refined balance selection options.

Use Chart of Accounts Description (Release 3.15)

27 October 2011

Feature Description: The user can select to have the description for the GL Account taken from the Chart of Accounts if desired. Feature Benefit: Additional option for the user.

Discover the individual master records within a range (Release 3.15)

26 October 2011

Feature Description: This allows the user to set an option so that the discover hierarchy functionality will return either a range of values or the individual master records making up that range. Feature Benefit: Users can return the breakdown of a group as it was defined as a range or automatically list the master records within that range.

Drilldown worksheet in current workbook (Release 3.15)

26 October 2011

Feature Description: The user now has the option to have the drill down results appear as a new sheet in the current workbook or to be created in a new workbook. Feature Benefit: Improved user flexibility.

List of Values persisted (Release 3.15)

24 October 2011

Feature Description: The List of Values that have been built are persisted when accessing the List. Feature Benefit: Improved user interface.

Lists of Groups (Release 3.15)

22 October 2011

Feature Description: Lists of Groups can now be used in get balance functions. Feature Benefit: Extended get balance functionality.

Configuration Sheet (Release 3.15)

21 October 2011

Feature Description: The Configuration Sheet provides system configuration and master data information. Feature Benefit: Provides information for troubleshooting.

Custom Drill Down Layouts (Release 3.15)

20 October 2011

Feature Description: Both line item and document drill down layouts can now be customized. Feature Benefit: Improved user interface.

Single Sign On (Release 3.15)

19 October 2011

Feature Description: Single Sign On capability added to the Excel4apps Wands Connector. Feature Benefit: Single Sign On capability.

CO Order, Activity Type and Statistical Key Figure Get Balance Functions (Release 3.15)

18 October 2011

Feature Description: New functions provided to access balances from CO Orders, Activity Types and Statistical Key Figures. Feature Benefit: Greater functional scope.

Excel 2007/2010 Ribbon

13 October 2011

Feature Description: The Excel 2007/2010 ribbon provides a rich user interface to interact with the Wand products. Feature Benefit: Improved user interface.

GL Wand for SAP 1.15.43 released

10 December 2010

An updated version of GL Wand for SAP is available. This version includes support for currencies with additional decimal places as well as a quicker logon process to the Excel4Apps demo server. Also included is a correction to the foreign language conversion routine for other language descriptions. A number of smaller bug fixes and minor enhancements are also included.

Functional area parameter added to the Get_PCA balance function. (Release 1.15.0)

19 May 2010

The functional area parameter has been added to the Get_PCA balance function allowing balances and drill down by functional area.

Support for SAP version 4.70 (Release 1.15.0)

19 May 2010

Support for SAP version 4.70 has been added which requires a different server transport. GL Wand now supports a wider range of SAP versions.

SAPINSIDER | New and Noteworthy

23 April 2010

News from SAP and Partners Excel4apps Streamlines Financial Reprots with New GL Tool. Read about our release of GL Wand 1.10 for SAP Solutions as published in the SAPINSIDER magazine.

See the GL Wand for SAP online demo

5 November 2009

See the GL Wand for SAP online demo published today. You will see a brief overview of the main GL Wand functions including logging on to SAP, refreshing a report and drilling to detail. See it online in the GL Wand for SAP demo section of our website or on YouTube.

GL Wand 1.00 for SAP available for in-house trial

27 October 2009

GL Wand 1.00 for SAP is now available for in-house trial by a limited number of early adopters. Complete the GL Wand for SAP download form to apply for early access.

GL Wand for use with SAP coming soon!

21 August 2009

Excel4apps are pleased to announce that GL Wand for use with SAP will be available in the coming months for download and trial. This annoucement follows over a year of development and testing.