Symptom
You are uploading a new Plan data for Expenses and Income Statement, however you receive an error message:
Combination of Budget category PQR and G/L account 123 does not exit
(PQR represents the Budget Category)
(123 represents the G/L Account ID)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Cost and Revenue work center.
- Go to the Planning View.
- Click New >Plan Version from Microsoft Excel.
- Select New Expense and Income Statement Plan.
- Click on Download and Open the template in Microsoft Excel.
- You need to logon to SAP Business ByDesign and provide the Log On details.
- Upload the file via Save data to in the Excel add-in, you receive the below error message:
Combination of Budget category PQR and G/L account 123 does not exit
Cause
You have not mapped the G/L account 123 to the Budget Category PQR in the Budget Queries activity.
Resolution
You need to assign the G/L Account 123 to the Budget Catergory PQR by following below steps:
- Go to the Business Configuration work center.
- Go to the Overview.
- Search for Activity: Budget Queries.
- Click on Edit G/L account groups for reporting.
- Select G/L Account Group : PQR.
- Click on Add Row.
- Enter relevant Chart of Accounts and Select the G/L account 123.
- Click on Save and Close tab.
Now, you shall able to upload the Plan data without any issue.
Keywords
Plan data for Expenses and Income Statement, Upload Plan data, Budget Category, Combination of Budget Category and G/L Account, Budget queries , KBA , budget category , upload plan data , plan data for expenses and income , budget queries , SRD-FIN-FIP , Planning , Problem