Symptom
You are uploading the Planning/Budgeting for the year and end up getting the error as 'Invalid Character in FinancialPlanData/ID'.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Cost and Revenue work center.
- Choose the Planning view.
- Choose New, Plan Version from Microsoft Excel and File upload.
- Logon to SAP Business ByDesign dialog box and enter the details.
- Click the button Save Data To.
Error: Invalid Character in FinancialPlanData/ID.
Cause
Plan Version Cell is Case-Sensitive and also got String Values coded in the backend for this column content.
Resolution
Format the Plan Version ID either with
- Only numbers, for example 123456789
- Only Capital letters, for example TEST (not test or Test).
- A combination of numbers and words
Please Note: All number groups and word - number combinations must not have spaces:
Example:
- Enter 123-456-789 or 123_456_789 (not 123 456 789)
- Enter TEST-123 or TEST_123 (not TEST 123 or Test 123)
Keywords
Invalid Character E in FinancialPlanData/ID; Upload plan data; Plan version; Income statement; Microsoft excel , KBA , invalid character in financialplandata/i , plan version , income statement , upload plan data , microsoft excel , SRD-FIN-COR , Cost & Revenue , How To