Use Report Painter to Facilitate the Design of Due Date Analysis Reports

  • by Ravisankar Venna, Senior SAP FICO Consultant, Logica UK Limited
  • November 30, 2012
See how to create due date analysis reports for vendors and customers using Report Painter. Understand how to design and create a form and a report, and see the available options to download the due date report.
Key Concept
Although SAP has provided due date analysis reports, mostly they fail to meet reporting requirements because they have a cumbersome format or are not flexible enough. Instead you can use Report Painter, which is provided by SAP, to meet various reporting requirements. Using Report Painter, due date analysis reports for customers and vendors can be designed effortlessly. These reports are still able to provide the drilldown to the line-item level from aggregated totals.

Based on my experience with clients, I believe accounts payable (AP) and accounts receivable (AR) departments always struggle to get a report that provides them with a comfort level for analyzing due dates for business partners. SAP standard reports in this area do not suffice to meet user requirements because they are not in a reportable format. Many reasons why SAP standard reports fail as a reportable format are:

  • The reports are not in SAP List (ALV) grid format
  • The standard due date analysis reports are rigid, and they can showcase no more than two due dates at a time
  • These reports contain the header and address of the business partner, which do not serve any meaningful purpose, as the SAP standard report cannot provide a snapshot of all the items in a single screen. The line of the due items is under the header and address, which means that when downloaded into Excel, the report looks clumsy and the figures are scattered for each vendor.

Users are expected to do a lot of manual work to convert these reports into a reportable format. Furthermore, standard SAP due date analysis reports provide selection criteria only for entering two due dates. If a business intends to analyze the outstanding items by a number of due dates, you have to execute the standard reports numerous times. It is impossible to group these separately executed reports into a single report because at one point only two due dates can be entered in the selection criteria.

The reports come as business partner header and then line of the dues. Refer to SAP Standard Report S_ALR_87012084 - Open Items - Vendor Due Date Forecast.This is one of the frequently used SAP standard reports that are available on the initial easy access screen. If they are to be grouped, an enormous amount of manual Excel work needs to be done. When you consider all these constraints from the standard due date analysis reports, you realize that you need Report Painter to help your business consolidate these reports.

Ravisankar Venna

Ravi Venna is SAP certified in FI/CO (4.6C), SEM (3.5), BW (3.0), Solution Manager (4.0), and SAP NetWeaver – Security (WEB AS 6.40) and FI (SAP ECC 6.0) Ravi is an associate member of the Institute of Cost and Works Accountants of India (ICWAI). He received a Final Pass Certificate from the Institute of Company Secretaries of India (ICSI). Ravi has also passed the Certified Information Systems Auditor (CISA) examination from the Information Systems Audit and Control Association. Ravi has more than 12 years of experience in the Finance and Controlling modules. Additionally, Ravi has worked extensively on both SAP R/3 and BW authorisations and in the use of the SAP testing tool e-CATT, Business Intelligence-Integrated Planning (BI-IP), and SAP BW-BPS. Ravi has taken part in a number of implementation projects in the UK. His further interest areas are SAP BPC and FSCM. For more than eight years, he has been working with Logica in different modules of SAP.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.