How to change part numbers automatically

Is it possible using a report to go through a particular subset of the item master and change the part numbers[?] Advanced question: Can I use a (different) number series that creates the new numbers automatically AND updates the field “No. Series” to the new one[?] IMPORTANT: All the ledger entries etc. have obviously to be updated as well (just like renaming manually[;)]). Thanks for your help.

Your part numbers are identical with item no. (primary key) ? Yes, it should be possible that a report can do the job for you. And I don´t see a reason, why it shouldn´t be possible to use a new number series to get the new part numbers from. To avoid all the figuring with details in updating the various entry tables: Why you don`t use the RENAME function of the record? This should handle this for you automatically.