SAP Knowledge Base Article - Public

3001389 - Error While Migrating Fixed Asset: Error detected in source record with key value 'ABC'

Symptom

During Migration of Fixed Asset there is an error regarding Valuation View.

ABC - Existing Inventory ID in the migration file.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configurations work center.
  2. Go to the Overview view.
  3. Click Migration of Accounting Transaction Data activity.
  4. Click Migrate accounting transaction data using the migration tool.
  5. Select Migration Unit FA.
  6. Click Execute Migration.
  7. Select Fixed Asset (extended).
  8. Click Process Asset.

Error detected in source record with key value 'ABC'

Valuation view XXX not assigned to set of books YYY in company DEF

DEF - Company ID

XXX - Valuation View ID

YYY - Set of Books ID

Cause

This can occur due to incorrect Value Conversion for Valuation View.

If there are Set of Books with different Account Principle that have different Valuation Views, each Valuation View needs to be added in the Value Conversion separately.

For example:

Set of Books: 1

ID 1 - Valuation View A01 - Company ABC - Active

ID 2 - Valuation View B02 - Company ABC - Active

Set of Books: 2

ID 1 - Valuation View A01 - Company ABC - Active

ID 2 - Valuation View C03 - Company ABC - Active

A01, B02 and C03 - Valuation Views IDs

Resolution

To adjust this, each different Valuation View needs to have an ID in the file even if they belong to different Accounting Principles.

Using the example above, each Valuation View needs to have a different ID in the file, instead of repeating ID 2 for B02 and C03, change C03 to ID 3.

In the file each Valuation View needs to have a different number, and after in the Value Conversion of Valuation View (step b Convert Values on Process Files) the conversion needs to be added for all Valuation Views:

ID 1 - Valuation View A01

ID 2 - Valuation View B02

ID 3 - Valuation View C03

Keywords

Valuation View, Migration of Fixed Assets, Error detected in source record with key value , KBA , valuation view , migration of fixed assets , error detected in source record with key , AP-ACC-FXA , Fixed Asset , How To

Product

SAP Business ByDesign all versions