Symptom
When trying to upload the Budget Release MS Excel file an error message appears: "Budget category XYZ is greater than the planned amount." (XYZ represents a budget category ID).
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Cost and Revenue work center go to the Budget Release view.
- Press New - Budget Release from Microsoft Excel.
- In the Excel file, in the SAP Business ByDesign tab, log on to your system and then enter all the respective data.
- To upload press Save data to.
- The error message "Budget category XYZ is greater than the planned amount" appears.
Cause
The amounts entered in your budget release file for budget category/ cost center XYZ are different to the values entered for the same budget category/ cost center in your default budget plan:
To find your budget plan
- Go to the Cost and Revenue work center.
- Find the Planning view.
- Now find your default budget plan (find the plan where Default appears with a green tick. Ideally, the plan version has the same ID as your release version) and open it.
- Go to the Plan Data tab.
- Check for budget category/ cost center XYZ. Compare all the values. You will find a value that appears lower than maintained in the budget release.
Example:
- In your budget plan V1 (V1 stands for version 1) a value, say 100,00 LC, is maintained for each period of fiscal year YYYY (LC stands for local currency). Altogether, a total result of 1200,00 LC is calculated in the Plan data report.
- In your budget release file you entered the whole yearly budget, 1200,00 LC into period 1 of fiscal year YYYY.
- The error message now appears as the plan value in period 1 of year YYYY is only 100,00 LC.
Resolution
In the budget release file maintain exactly the same values as maintained in the budget plan:
- In the Planning view of the Cost and Revenue work center, find your default budget plan and open it.
- Go to the Plan Data tab.
- Check for budget category/ cost center XYZ. Compare all the values with the budget release file.
- All values entered in the budget release must be maintained exactly the same way as in the budget plan.
So, regarding the example, for period 1, 2, 3...12 enter 100,00 LC rather than the whole yearly budget in one period only.
See Also
Keywords
Budget category is greater than the planned amount, budget release, budget plan, upload , KBA , SRD-FIN-COR , Cost & Revenue , Problem