Enhanced key figures: Analyzing/monitoring SD invoices not transferred to FI
In my two previous blogs New key figures: Analyzing/Monitoring exceptions during delivery due processing and New key figure: Analyzing/Monitoring exceptions during billing due processing I described new key figures that help analyzing exceptions which occur during two important steps within a typical Order to Cash process, the delivery creation and the billing document creation Another important process step is then the transfer of those billing documents to the accounting module FI and/or the controlling module CO. This activity is performed in background by the SAP system once the respective SD billing document has been created and saved. All documents that could not be successfully posted can be displayed and released via transaction VFX3. But as so often this “old” transaction has some limitations if you want to analyze exceptions systematically:
- Transaction VFX3 only allows displaying documents for one single sales organization at a time. So you cannot directly compare exceptions between different sales orgnaizations.
- VFX3 also has another limitation that you can only see the reason of the posting failure in some (typically rare) cases via the post status (field VBRK-RFBSK), i.e. an accounting block exists (status ‘A’), the account could not be determined (status ‘B’), a pricing error occurred (status ‘F’),or export data is missing (status ‘G’). But in most cases the status is blank, i.e. you just get the general information that an error occurred in the FI/CO interface.
The following key figures (available for Business Process Analytics and Business Process Monitoing in SAP Solution Manager) allow to get the same information but across all sales organizations. You can find the new key figures in the setup environment at
- Application Area “Sales & Services” > SD Invoices (AR) > Sales invoices not posted to FI
- Application Area “Sales & Services” > SD Invoices (AR) > Sales invoices not posted to FI via index
These two key figures have been further enhanced in order to ovecome the limitation for those entries with post status blank. As of ST-A/PI 01Q you can flag Incl. log data on the selection screen. Then for all documents with post status blank an additional selection is performed on corresponding log tables in order to search for exception messages. The result list then contains not only the post status information but also a column Message Text which should show precisely what problem occurred in the FI/CO interface, e.g. accounts blocked, CO-PA transfer not possible, missing or incorrect master data. The new ST-A/PI can be downloaded via the SAP Service Marketplace http://service.sap.com/supporttools.
Example screenshots
An example detail list for “Sales invoices not posted to FI” could look as follows:
Further reading
Frequently Asked Questions about Business Process Monitoring and Business Process Analytics are answered at http://wiki.sdn.sap.com/wiki/display/SM/FAQ+Business+Process+Monitoring and
http://wiki.sdn.sap.com/wiki/display/SM/FAQ+Business+Process+Analytics respectively.
The following blogs (in chronological order) provide further details about Business Process Analytics and Monitoring functionalities within the SAP Solution Manager.
- New Business Process Monitoring functionalities in SAP Solution Manager – ALE / IDoc Monitoring
- New Business Process Monitoring functionalities in SAP Solution Manager – qRFC Monitoring
- New Business Process Monitoring Functionalities in SAP Solution Manager – functionalities For Inconsistencies in SAP Solution Manager
- SAP Business Process Monitoring within SAP Solution Manager
- New Business Process Monitoring functionalities in SAP Solution Manager – BPMon Trend Analysis Reporting
- Best Practice: Business Process Monitoring for Manufacturing
- Best Practice: Business Process Monitoring for Procure to Pay
- Best Practice: Business Process Monitoring for Order to Cash
- Business Process Monitoring – Template configuration available for download
- FAQs about Business Process Monitoring
- Typical Use Cases for Business Process Monitoring in SAP Solution Manager
- New Business Process Monitoring functionalities in SAP Solution Manager – Customer Exit
- New key figure catalog for Business Process Monitoring available
- Why SAP offers different tools for Business Process Monitoring & Business Process Optimization
- Create your own auto-reaction messages in Business Process Monitoring via BAdI exit
- Protect your SAP ERP investment & improve your core business processes
- Refresh Solution Landscape cache for Business Process Operation Work Center
- Create your own customer-specific key figure for Business Process Monitoring within 5 minutes
- Best Practice: BW Process Chain monitoring with SAP Solution Manager – Part 1
- Best Practice: BW Process Chain monitoring with SAP Solution Manager – Part 2: Setup Example
- New key figures for Business Process Monitoring in SAP Solution Manager, especially for CRM Marketing
- New functionality “Business Process Analytics” – how to improve your business processes
- New key figures for Business Process Monitoring in SAP Solution Manager, especially Lead Time measurements
- Traditional Business KPI approach vs Business Process Monitoring
- Systematic errors vs real exceptions or improving efficiency vs effectiveness
- Before you get started with SAP HANA…you should also consider cleaning-up your backend system first
- Best Practice: Business Process Monitoring for CRM Sales
- SAP Business Process Operations Extensions at SAP TechEd 2011
- Business Process Operations dashboards – ALL AT A GLANCE
- Business Process Operations dashboards – behind the scenes
- Customer testimonials on Business Process Analytics
- Customer Exit: Create your own key figure for BPMon AND Business Process Analytics
- Heads-up: Setup environment of BPMon & Analytics changes with SolMan 7.1 SP5
- New key figures for BPMon & BP Analytics, especially for working capital improvement
- New Business Process Monitoring functionalities in SAP Solution Manager – BPMon Alert Reporting Analysis
- New Business Process Analytics features with SAP SolMan 7.1 SP5
- New Business Process Analytics – The filter sequence makes the difference
- New key figures: Analyzing/Monitoring exceptions during delivery due processing
- New key figure: Analyzing/Monitoring exceptions during billing due processing