We have referred the best practice document to build our CRM 7.0 system and while setting up the middleware we had set up the number scheme for R3PRODHIER as per the guidelines. We had created 3 levels and with number of characters 5, 5, 8 respectively. Then we had downloaded all required customizing adapters from ERP which included product categories (DNL_CUST_PROD1).
But now as part of a bespoke development, the product hierarchy structure (PRODHS) has been changed to have 4 levels with the number of characters 2,5,5,8 respectively. So I need to download the hierarchy again. However when I try to change the number scheme in CRM, I get the error that the Number scheme is already assigned to a hierarchy and cannot be changed.
The concern here is we have few categories in the system which is as per the 5,5,8 number scheme and also we have created transactions using those products. So is there any way of updating the number scheme in CRM so that we could do a product hierarchy download? Currently it is failing when it tries to download level 4 entries from ERP.
Did anyone else has faced similar issues in past and worked out a way to fix it ? Please let me know if you have suggestions.