Previously I have asked a question about "is it possible to change a product's Product number", and the answer is yes. But since then I have encountered another problem when trying to change Product number:
Due to managerial reasons, the same product could have different Item numbers and Product numbers in different subcompanies. And we're trying to change these products' Product number so that the same product share the same Product number according to a numbering rule we developed. (we're not trying to change item number since we know that's impossibe).
And the problem is, although we can change a product's Product number, we cannot if the new Product number already exists in the system. There is no merge option in the menu either, unlike Global address book. So my question is, is there a way to do it? If not, do you think it is possible to achieve it with customized functionalities?
