Symptom
You have created and released a budget query, however when running the Forecast Document Items report, the amounts are shown as Zero ($0.00)
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Open and execute the Forecast Document Items.
You notice that amount for your budget query is zero (0.00)
Cause
When checking the Forecast Document Items report, the key figures Amt Comp Curr and Transaction Amount shows the balance of the budget query, which is zero due to credit and corresponding debit.
Resolution
To check further details of the corresponding amount, you may add to the report the characteristic for Debit/Credit.
Additionally, as per current design of forecasting logic, any change in the source documents (budget queries or purchase orders, etc) would trigger forecast document business object and would create entries in the backend for every change. When you bring row fields like Created On and Commitment Level in Forecast Document Items Report, you shall be able to narrow down to further entries that aggregates and balances amount to zero.
Keywords
Budget queries. Budget Query. Forecast Document. , KBA , SRD-FIN-ANA , Analytics Content , How To