3639601 - Discrepancy in "spent" value in Cost Centers - Budget Monitoring Report

In the Cost Centers - Budget Monitoring report, the "Spent" value for Budget Category XYZ differs from the amount shown when drilling down to the G/L Account - Line Items report, which may show a higher or lower value.

(XYZ represents the Budget Category ID)

SAP Business ByDesign

1. Go to Cost and Revenue work center.
2. Navigate to the List subview.
3. Search for the report "Cost Centers - Budget Monitoring" and open it.
4. Fill with the required parameters.
5. Click "Apply".
6. In Budget Category XYZ, click on the value in the "Spent" tab > G/L Accounts - Line Items.
7. Go to the last page of the G/L Account - Line Items report. The value displayed in the result is different, which is inconsistent with the original "Spent" value.

The G/L Accounts - Line Items report does not support the "Budget Category" field. Therefore, when drilling down from the "Spent" column in the Cost Centers - Budget Monitoring report (which is filtered by Budget Category), the same filter cannot be applied.
As a result, the system displays values from multiple G/L accounts and unrelated transactions, leading to differences from the original "Spent" amount.

This is the expected system behavior. 

The "Spent" value in the Budget Monitoring report reflects net actuals that are relevant for the budget. It excludes certain postings, such as reversals, manual adjustments, or entries not assigned to a budget category.

In contrast, when drilling down to the G/L Account - Line Items report, all related postings are shown including those excluded from the budget calculation, which can result in a higher total.

This drilldown does not show a filtered breakdown of the "Spent" value. Instead, it lists all line items for the selected cost center and G/L account, without applying the same logic used in the budget report.

To analyze details for a specific Budget Category, use the following report:

1. Use the "Cost Centers - Line Items" report to analyze or validate values based on a specific Budget Category.
2. Perform the following steps:

• Open the "Cost Centers - Line Items" report.
• Apply filters for the relevant Cost Center and Budget Category.
• Optionally, add G/L Account as a row field to break down the amount by account.

This report supports the necessary fields and provides a consistent view aligned with the "Spent" value shown in the Budget Monitoring report.

cost centers, budget monitoring, spent value, G/L accounts, line items, discrepancy, budget category, drill-down, report navigation, cost center line items, SAP Business ByDesign , KBA , SRD-FIN-COR , Cost & Revenue , Problem