SAP Knowledge Base Article - Public

3228151 - Warning "value XYZ column Inventory ID will be truncated; edit source value" Occurs During Fixed Asset Migration

Symptom

You get the warning "value XYZ column Inventory ID will be truncated; edit source value" when you migrate fixed asset. And you notict the inventory ID you input in the migration template is within the field length mentioned in Field List.

In the migration template, it is mentioned the field length of Inventory ID is 60(25).

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configuration work centern and Overview view.
  2. Search and open Migration of Accounting Transaction Data activity.
  3. Select option:Migration of Accounting Transaction Data using the migration tool.
  4. Select the respective migration file of fixed asset.
  5. Select Fixed Assets-> Process file.
  6. Execute migration step by step, and warning occurs during simulation.

However, in the migration template, it is mentioned the field length of Inventory ID is 60(25), and the Inventory ID in the file is within length of 60 characters.

Cause

The field allows 60 characters in database, but the fixed asset UI screens are limited to 25, so the migration template is limited in the same way. That's why you get the warning that the value you input for Inventory ID will be truncated.

Resolution

It is the UI design of fixed asset. Please keep the characters within 25.

See Also

KBA 2809141 - Documentation for Migration Object: Fixed Assets (extended)

Keywords

Inventory ID, Fixed Asset Migration, Field Length, Truncated , KBA , SRD-FIN-FA , Fixed Assets , How To

Product

SAP Business ByDesign all versions