Duplicate Parts in Inventory Control

Question

I am currently trying to clean up our parts database. We have multiple part numbers for the same item. Is there a way to merge the parts together and retain the history?

CShular · Accepted Answer

Sage BusinessWorks does not have a way to merge parts. You would need to delete the parts if they have no on hand quantity and no transactions on file for that part.

Janice Carnarvon · Answer

Please note that you can only delete a part as long as there is no activity for the months to keep history. You will need to use a negative adjustments to zero out on hand quantity for the part you no longer want to use, and then a positive adjustment for the part you are keeping. Then you can rename the obsolete parts to a letter or number to send them to the bottom of your part list so that you can select to run reports excluding those parts until you reach the months to keep history and can delete them.

Sage BusinessWorks

Duplicate Parts in Inventory Control

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING