Archives

Reporting

Jul 22, 2015

Streamline Accounting Processes to Get More Out of Your Day

In most positions we can expect an element of diversity in job tasks day to day, but this can sap productivity and effectiveness. In accounting, streamlining processes and implementing lean solutions can decrease time spent on low level tasks, and allow you to get more out of each day.

Feb 17, 2014

Five Rules to Maximize Your Data Reporting Effectiveness

Five Rules to Maximize Your Data Reporting Effectiveness What would you say is the most important commodity to any company’s success? I would argue that data is the most vital commodity to any company’s success. In fact data is probably the main reasons your company implemented an ERP solution like SAP. Data is critical to any organization, yet our ability to create and store more information- has created more problems. Data and reporting continue to be one of the most talked about topics including; the rate at which it’s growing, and the types of information being managed and analyzed.  Even… Read more

Jul 17, 2012

How to hide sensitive SAP information in Query Reports

Winshuttle Query is great for adding security on top of the native SAP security to limit users down to the field level. Security administrators can even configure Query to perform custom security checks, restrict or exclusively allow one or multiple tables within an authorization group. What about when we want users to have access to the data but we need to hide or scramble personally identifiable information such as tax id, bank routing, bank account number or show only the last 4 digits of the Social Security number? Winshuttle Query natively supports Excel formulas and functions in the mapper. This… Read more

Jul 9, 2012

How to download SAP structure data with Winshuttle Query

Let me start off by saying that structures in and of themselves do not contain data. By definition, a structure is a skeleton of a table which “forms the basic framework of the axes in a table (rows or columns)”. That still doesn’t change the fact that many of us every day SAP users still need to download the data we see in a transaction code regardless of where it is stored on the backend or how it is derived. Technical users know how to backtrack from the data element, run a trace or read and write code to find… Read more

Feb 28, 2012

Workflow Reporting and Auditing

Visibility into business process history and performance is critical for every business implementing Winshuttle Workflow. For every action taken in every workflow process, audit information is available allowing you to provide comprehensive logs and reports in order to comply with auditing requirements. The same database of workflow activity can be used to create reports and dashboards providing insights into the overall performance of the business unit or single individuals. For example, it is common that shared service departments have service level agreements (SLAs) that they are committed to. You can build dashboards which measure actual performance against these SLAs. Winshuttle… Read more

Apr 5, 2011

When should I use Winshuttle Transaction to create a ‘report’ versus Winshuttle Query?

In response to a number of questions that have come up recently regarding the capabilities of reporting with Transaction versus Query, I thought I would share these with you by way of a blog post. Winshuttle offers three methods of extracting and reporting data from your SAP system: The first and most preferred method is through the use of Winshuttle Query, a desktop query building application that allows you to join ERP tables, Infosets, and logical databases together in a way that enables you to extract ERP data (including custom fields and tables). This data can be furnished to the… Read more