SageForum for UK versions of Sage 50- Help and support.

We have an active part number that needs to be changed
It ends CP-E & needs to be CE-P
We have a lot of in process activity against the code
Is there a feature available that will allow us to change the part number rather than create a new one & move all live activities
Any help much appreciated

As far as I'm aware you cannot change a stock code after it has been created. You could though set up a new part and import the transaction history from the old stock code.

Hope that helps.

I can do it for you.

I would need a list of codes old/new and your data.

It typically takes half an hour to an hour to do this sort of thing, it depends on the amount of data we have to change.

Give me a call if you want.

Hi Bruce
There is not much information to change over, so we could do it ourselves really
My reason for wanting to "change" the part number is so there are no redundant DO NOT USE numbers in the system
It often creates opportunities for future mistakes
Would your solution achieve this
Thanks

If you want to hide the obsolete parts, then I would suggest you set up an "Obsolete Parts" product category.
You then use a search in the products module Where "Stock Category" is not "Obsolete Parts" and they are hidden from view, users can't see them unless they change the search.
This will be useful when you clear the stock history as you can select the obsolete parts with a search and delete them all (apart from the ones with stock history)

Thanks for the help Bruce
That works well!