Merging Duplicate Inventory Part Numbers?

[Paradigm]

For various reasons I have duplicate part numbers on the inventory list. How can I combine the two numbers into one?
This seems so basic, but I don't find an answer anywhere for it.

[ricmorin]

This would be a manual process. Delete one and add the on-hand quantity from the deleted one to the remaining one.

[Paradigm]

If I delete a number, won't that delete the history for that part number?

[ricmorin]

Yes it will. I don't believe there is a way to merge history like you can with vehicles.

[BedfordAutoClinic]

If the system would handle the part supersession the correct way, then history would be maintained with both numbers.

Basically you should be able to tell the system to supersede part # xyz to #123 all sales for xyz would still be there but when you bill out xyz it should state there is a new number 123 that you should use, unless you still have on hand quantities of xyz which would still bill out unless you tell it otherwise until stock is depleted.

The way I see it working now is you have to add a new number, well its not totally out of realm to have a number in stock that you need an older number to supersede too.

I wished the system would work that way with supersessions but I have not been able to do it unless I am missing something.

[timbre4]

Before anything is done, back up and examine why the 'duplicates' exist.

The test for uniqueness with part records is part number & Mfg. Line Code.

If the part number has been ordered electronically from different suppliers, the Mfg. line codes are going to be different. Take a look at the line codes and primary vendor assignments to determine the keepers. It may be that you want to continue having the option of ordering from more than one catalog. If there is no line code present, that part has not been ordered electronically.