Inventory parts, inventory and ordering

Merging Duplicate Inventory Part Numbers?

Merging Duplicate Inventory Part Numbers?

Postby Paradigm » Thu Jul 13, 2017 6:30 am

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.
User avatar
Paradigm
25 Club: Starting Contributor
 
Posts: 25
Joined: Wed May 25, 2016 8:21 am

Re: Merging Duplicate Inventory Part Numbers?

Postby ricmorin » Thu Jul 13, 2017 7:58 am

This would be a manual process. Delete one and add the on-hand quantity from the deleted one to the remaining one.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5288
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Merging Duplicate Inventory Part Numbers?

Postby Paradigm » Thu Jul 13, 2017 11:00 am

If I delete a number, won't that delete the history for that part number?
User avatar
Paradigm
25 Club: Starting Contributor
 
Posts: 25
Joined: Wed May 25, 2016 8:21 am

Re: Merging Duplicate Inventory Part Numbers?

Postby ricmorin » Thu Jul 13, 2017 12:01 pm

Yes it will. I don't believe there is a way to merge history like you can with vehicles.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5288
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Merging Duplicate Inventory Part Numbers?

Postby BedfordAutoClinic » Fri Jul 14, 2017 4:44 am

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.
Bedford Auto Clinic
Facebook: Bedford Auto Clinic
Twitter: @TedsBedfordAuto
Google+: Bedford Auto Clinic
http://www.bedfordautoclinic.xyz
User avatar
BedfordAutoClinic
25 Club: Starting Contributor
 
Posts: 45
Joined: Tue Dec 15, 2015 5:37 am
Location: Bedford, Indiana

Re: Merging Duplicate Inventory Part Numbers?

Postby timbre4 » Fri Jul 14, 2017 10:12 am

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.
Tim McDonnell -
Sr. Product Market Mgr / Forum Moderator / Mitchell 1 Media Developer
User avatar
timbre4
System Guru / Moderator
System Guru / Moderator
 
Posts: 4524
Joined: Tue May 25, 2004 5:47 pm
Location: TN - Volunteer State

Return to Inventory / Purchase Orders

Who is online

Users browsing this forum: No registered users and 1 guest