Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Editing Items Without Causing Database Corruption

We're using QB Enterprise Solutions 16.0 with advanced inventory enabled. We need to re-organize our item list as many of our items are misplaced and/or incorrectly categorized. Are there any data corruption issues associated with moving an item, editing an item name, or changing the parent item ('Subitem of' item) of an item? Also, I've read that merging items can cause database confusion/corruption, is this true? Our item list is quite large, are there any suggestions for doing this efficiently and avoiding data corruption? Thanks in advance for your time and assistance.

1 Comment
Level 15

Editing Items Without Causing Database Corruption

Merging an Inventory item is dangerous; you are asking the system to Recalculate everything, whether that is FIFO, Average, Assemblies, Margins, etc. That one task should never be done. Inventory items are either unique, or they are the same item serving the same purpose and you didn't need More Item Names for them. This is called FF&F: Fit, Form and Finish. Just because a part replaces a part doesn't always make it a new part number, in other words. Or, it is too different and gets its own item name.

For organizational purposes, you can confirm old inventory items as 0 value and 0 on hand, and assign them as Subitems under a common Parent named Old Items, then make the Parent item inactive and it hides all the child levels, too.
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us