• HOME

Sales Wand for SAP

Enabling organizations to easily analyze sales performance directly within Excel.

Sales Wand enables SAP users to analyze sales performance in Microsoft Excel from “Order to Cash” in order to gain deeper business insights, collaborate more efficiently, and access reliable information more quickly for effective decision making. With Sales Wand, you can easily build and generate Business Unit Gross Margin Reports, Customer Value Reports, Commission Calculation Reports, Sales Team Performance Reports, Trend Analyses, Sales Forecasting Reports, Pricing Analyses, and many more.

Like all Excel4apps solutions, Sales Wand leverages your existing SAP security settings and provides reports with drill-down capabilities that are refreshable on demand, yet preserve formatting and Excel formula. Without middleware or data warehouse requirements, you can install and utilize Excel4apps solutions in minutes – so there’s less reliance on IT support and greater power given to the individual user.

Sales Wand for SAP Benefits

  • Quick to install
  • Easy to use
  • Analyze business performance by 14 dimensions, including Organization, Customer, and Product groupings
  • Presentation formatting
  • Enables collaboration
  • Full drill down to detail
  • Real-time data refreshes

  • 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.

  • "It’s great to work with a group so committed to providing not only a great product but stellar service as well."

    J Raffensberger (MBA), Corporate Controller, Glatfelters

  • "GL Wand is a fabulous tool, we love it."   

    Donna Holley, Spectranetics

  • "This has to be the quickest ROI we've had on any software investment."

    J Raffensberger (MBA), Corporate Controller, Glatfelters

  • “GL Wand has been a big hit with Cairn’s Finance team."

    Chris Hebden, Cairn Energy PLC

  • "It took less than two hours to train report users. The time savings for everyone is incredible."

    Francis Nocom, Applications Manager, Cochlear

  • “GL Wand has proven extremely valuable in accessing our Oracle data with Excel."

    Michael Hinck, Finance Systems Project Manager, HBO

  • "GL Wand has given our finance users the freedom to think outside the box and be more innovative with performance metrics."

    Martin Stanton, Chief Information Officer, Destination Hotels & Resorts

  • "GL Wand has given our finance users a very flexible tool."

    Paul Simpson, Lancashire County Council

Product Documents