Avoid User Confusion by Reconciling Reports Containing SD, FI, and PCA Data with KEAT
- by Gary Fullmer, Solution Architect, MI6 Solutions
- November 15, 2002
CO-PA produces different period-end billing numbers than do the SD, FI, and PCA modules for the same period. This is because CO-PA looks ahead and sometimes estimates numbers that are not seen in the other modules until later. This confuses many users who needlessly resort to manual reconciliation. A new transaction, KEAT, reconciles the period billing differences within the reports. Here's how to set it up.
CO-PA’s unique reporting characteristics and the way it generates its numbers might create a problem for your users. The period-end billing numbers in CO-PA often do not mirror the same-period billing numbers generated in the SD, FI, and PCA modules. If you have detailed knowledge of CO-PA, then you know that CO-PA looks ahead or even estimates certain numbers that are not seen in the other modules until later on in the billing cycle. The discrepancy is intentional. For users who do not understand how CO-PA works, however, it causes confusion and even casts doubt on the integrity of CO-PA reporting.
As a result of this CO-PA "feature," many users spend a lot of time and effort "justifying" period-end billing reports in CO-PA. They often use Excel spreadsheets to track all billing entries occurring in SD, FI, and PCA, and then they compare and reconcile these with the totals of the CO-PA billing reports. This manual reconciliation is very frustrating.
Fortunately, your users don’t have to perform this pesky task. Starting with release 4.5A, SAP has added a standard transaction that generates a report that reconciles the period billing total differences within the various reports. This new transaction is KEAT. The good news for folks not yet running release 4.5A or higher is that they can apply a hot pack to their system that enables KEAT in releases as far back as 3.0F. (See CSN note 112938.)
Let me show you what KEAT can do by tracking a sales order through the system to CO-PA reporting. In Figure 1, the Conditions tab is selected for sales order 8106. This sales order is set up for the purchase of 10 P-100 pumps. The Conditions table outlines the price, tax, cash discount offered, total cost, and the projected profit on the order. Note that there is no entry for the cost of freight.
Would you like to see this full item?