Symptom
You upload the New Expense and Income Statement Plan, error "XXXXXX is balance sheet acct and cannot be planned as income and expense acct" occurs. And you are sure the G/L Account XXXXXX is a revenue account.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Cost and Revenue Work Center.
- Go to Planning View.
- Click New->Plan Version from Microsoft Excel.
- Select New Expense And Income Statement Plan and click Download.
- Open the Excel and enter all necessary data, then logon to SAP Business ByDesign in the Excel.
- Click Save data to ..., error "XXXXXX is balance sheet acct and cannot be planned as income and expense acct" occurs(XXXXXX is the G/L Account).
To verify the G/L account type of XXXXXX, you can:
- Go to Business Configuration Work Center.
- Go to Overview View.
- Search and open Activity Editing Chart of Accounts.
- In the G/L Account table, filter G/L Account XXXXXX, the G/L Account type is REVGAN - Revenues or gains.
Cause
In this case, there are typos in the Company ID or Set of Book ID.
Resolution
Make sure the Company ID and Set of Book ID are correct and the same as what in the system.
Keywords
is balance sheet acct and cannot be planned as income and expense acct, upload, New Expense and Income Statement Plan. , KBA , SRD-FIN-COR , Cost & Revenue , Known Error