SAP Knowledge Base Article - Public

3236192 - Error : Currency of Plan Data differ from Local Currency, Set of Books and Company when Uploading Expenses and Income Statement from Excel

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

  1. Go to the Cost and Revenue Work center.
  2. Go to the Planning.
  3. Go to New and then to Plan Version for Microsoft Excel 
  4. Select the New Expense and Income Statement Plan and Download
  5. Enter the Data 
  6. 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

Product

SAP Business ByDesign 2205 ; SAP Business ByDesign 2208 ; SAP Business ByDesign 2211