Symptom
You are uploading an Excel file related to Expenses and Income Statement using Excel Add-In and the error message is shown as
"Currency of plan data differ from local currency,Set of Books and Company.
Local Currency of Plan data differs."
You are also entering the Currency in the Excel which is the Company Currency.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Cost and Revenue Work center.
- Go to the Planning.
- Go to New and then to Plan Version for Microsoft Excel
- Select the New Expense and Income Statement Plan and Download
- Enter the Data
- Save the Data using the Excel Add-In
Cause
The Amount field in the Excel is blank. When the Amount field is blank, no currency code is fetched.The Overall currency code is the currency of plan data that is entered in the Excel.
When a comparison happens between the No Currency code and the Currency of Plan Data entered in the excel the error message is raised.
eg: XXX=/=null (XXX stands for the Currency entered in the Excel)
Resolution
The Amount field in the Excel file must be populated with zero instead of leaving it empty/blank.Even if it is zero the Currency code will be fetched.
Keywords
Local Currency of Plan data differs,Expenses and Income Statement Excel , KBA , local currency of plan data differs , expenses and income statement excel , SRD-FIN-COR , Cost & Revenue , Problem