Symptom
When trying to migrate a Price List from the Price List Migration Template (XML file), the following error occurs during the Import Simulation:
"Changing amount of Product ID XX not possible; scales lines exist" (Where XX represents the Product ID).
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration work center.
- Go to the Implementation Projects view.
- Click on Open Activity List.
- Search and open the activity Migration of Price Lists.
- Open the hyperlink Migrate Price Lists Using the Migration Tool.
- In case the file was not uploaded yet, click on Upload -> Data From Migration Template.
- Upload the XML file.
- Select the file and click on the Execute Migration -> Execute Migration Step by Step button.
- Advance until the Simulate Import step (step 3).
On the message Log, under the Import Simulation section, the following error occurs:
"Changing amount of Product ID XX not possible; scales lines exist".
Cause
The error message is triggered because within the Price List Migration Excel Template, the product amount is defined on both Items tab (under Price List Item section) and Scales tab (under Scales Items section). Whenever a Price List Item has a Scale, the product amount is automatically defined as the first scale line. Therefore it is not possible to manually set an amount in this case.
Additionally, it is possible to check this behavior from the UI. From the moment that a Scale is entered for a product on the Price List, the Amount field becomes read-only, because it is then determined by the first scale line.
Resolution
This is the expected system behavior.
In order to migrate a Price List with Scales, the values for the product amount must be removed from the Items tab on the Excel Migration Template, since it is defined by the Scales. Once the Migration Template is updated, remove the previous file from the Data Migration Tool and upload the updated one with the correct data.
When executing the migration again, the error should not occur anymore.
Keywords
Price List, migration, data migration tool, Changing amount not possible, scales lines exist, amount, scales, error message, import simulation, product ID, byd. , KBA , AP-PMD-SPL , Sales Price List , Problem