Symptom
When you migrate Serial ID via Inventory into the system after validation, it throws below warning message:
General: value XYZ in column Serial ID will be truncated; edit source value
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration work center.
- Select Implementation Projects view or Overview.
- Select the current project and choose the Open Activity List.
- Navigate to Integrate and Extend tab and search for activity:Migration of Accounting Transaction Data
- Select it and choose Open
- Select option:Migration of Accounting Transaction Data using the migration tool
- Select the respective migration file and perform Execute Migration.
- In the guided activity, choose Migration Object as Inventory.
- Select and choose Process File
- Navigate to Next, here system throws above warning message.
Cause
The standard system behavior during Serial ID migration >30 bits is a truncation. During the migration validation step, the system throws a warning message is to notify users that Serial IDs will be truncated to 30 only if it is more than 30. Length is set as 30 in Migration template itself under Serial ID column.
Resolution
- Go to the Business Configuration work center.
- Select Implementation Projects view or Overview.
- Select the current project and choose the Open Activity List.
- Navigate to Integrate and Extend tab and search for activity: Migration of Accounting Transaction Data
- Select it and choose Open
- Select option: Migration of Accounting Transaction Data using the migration tool
- Select the respective migration file and edit the column Serial ID length to 30 only.
- Upload the edited file again and Execute Migration.
Keywords
value in column Serial ID will be truncated; edit source value, value XYZ in column Serial ID will be truncated; edit source value, Migrate of Accounting Transaction Data, Inventory, Serial Numbers, Serial ID , KBA , serial id truncated , migration of inventory , serial numbers limit , AP-RC-GEN-SCM , Common Coding SCM , Problem