BestPractice_FIReporting

Product Details

This exclusive anthology of articles recently published in Financials Expert delivers unparalleled guidance on how to optimize financial reporting processes with SAP applications. Discover insights on how to release a standard cost estimate in the middle of the month, techniques that you can put to use immediately for automating the creation of task lists in the SAP Financial Closing Cockpit, as well as step-by-step instruction on how to optimize the bad debt process in SAP ERP Financials. And, that's just the beginning!

Our expert authors explain the ins and out of how to use the SAP Enterprise Performance Management (EPM) add-in to create a dynamic rolling forecast input form as well as how to significantly improve your ability to view financial data by using the EPM add-in’s report signage parameter. Each of the articles in this compendium has not only been written by an expert, but has also been reviewed for quality, completeness and accuracy by the seasoned Financials Expert editorial team and our trusted panel of advisors.  

Table of Contents

Decoding Sales Order Statuses in Financial Reporting ..... 3
by David Burns, CEO and Founder, Prime, LLC

Exactly what controls the status indicators of a sales order? Follow a step-by-step order-to-cash process and see exactly when and how sales order statuses are set in sales and distribution.

How to Release a Marked Standard Cost Estimate in the Middle of the Month ..... 26
by Mehulkumar Patel, Senior System Engineer, Conagra Foods
Generally, you can release a cost estimate in the beginning of the month when no inventory movement has been completed. However, in some cases, such as when issues in price or in logistics master data arise, you may have to release the cost estimate in the middle of the month. In a standard SAP system, when you try to release a cost estimate after inventory has been updated, you receive an error message. Learn how to successfully release a marked cost estimate in the middle of the month in your SAP system even though inventory transactions have been completed.

Custom Developments for FERC-Compliant Financials Reporting Using SAP HANA & SAP EPM 10 ..... 33
by Dr. Marco Sisfontes-Monge, Managing Partner, Arellius Enterprises, Inc
Follow the stages of the development of a real-life custom solution developed for financial reporting within the oil and mining, utilities, and electric and gas distribution industry in the United States. Compare this improved solution with the same processes executed in SAP ERP Central Component (ECC) Managerial Accounting (CO) and Financial Accounting (FI) modules.

How to Automatically Select Members by User in the SAP EPM Add-In ..... 51
by Charles "Tim" Soper, Senior Education Consultant, SAP
Learn how to create a fully dynamic report in the SAP Enterprise Performance Management (EPM) add-in that automatically selects members by user. The benefit to a company is that it offers a low cost-of-maintenance technique to automatically provide users with the data they need. See how to create this report from start to finish. Discover how to use EPM functions to automatically detect the logged-in user and then, for example, the cost centers that they need to analyze.

How to Use the Report Signage Parameter in the EPM Add-In on BW InfoProviders ..... 59
by Peter Jones, BI Solution Architect, M16 Solutions
Hone your ability to view financial data in an SAP system by using the report signage parameter in the SAP Enterprise Performance Management (EPM) add-in.

Accelerate Operational Reporting with SAP HANA Live: FI Focus ..... 64
by Ned Falk, Senior Education Consultant, SAP
Learn about SAP HANA Live and the SAP HANA-based virtual data model. It enables fast reporting on FI directly from an SAP ERP system running on the SAP HANA database.

Use Report Painter to Facilitate the Design of Due Date Analysis Reports ..... 72
by Ravisankar Venna, Senior SAP FICO Consultant, Logica UK Limited
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.

Set Up a Dynamic Rolling Forecast Input Form in the EPM Add-In ..... 81
by Charles "Tim" Soper, Senior Education Consultant, SAP
Learn how to create a fully dynamic input form in the SAP Enterprise Performance Management (EPM) add-in. The benefit to a company is that it offers a low cost-of-maintenance feature that can generate monthly forecast data. See how to create this form from start to finish. Discover how to use Excel functions for automatically determining the month and year, how to control time in the columns, and how to use formatting to prevent data entry for prior time periods.

Automate Task List Creation in the SAP Financial Closing Cockpit ..... 102
by Gaurav Aggarwal, Lead Consultant, SAP FICO, Infosys Limited
Many organizations now use the SAP Financial Closing Cockpit for making the period-end closing activity faster and more integrated. Organizations create a tasklist for each period-end closing from the template defined in the SAP Financial Closing Cockpit. See how you can automate the creation of the task lists from the template defined in the SAP Financial Closing Cockpit.

4 Tips on How to Optimize the Bad Debt Process ..... 109
by Gaurav Aggarwal, Lead Consultant, SAP FICO, Infosys Limited
Learn how to adopt the standard bad debt process in SAP ERP Financials to ensure better integration to original items, better reporting, and more accurate provisioning as per various regulatory needs.

Expand Your Reporting Options with an Extended G/L Code Block ..... 118
by Rohana Gunawardena, SAP Practice Director, Quality Systems & Software
The G/L code block in FI is not static. Customer-defined fields can be added to provide for reporting functions that SAP did not envision. Learn how to use a standard SAP transaction to add fields to the G/L code block, how to ensure that the field is properly populated, and how to report on the data once it is populated.

Post a comment to this product