Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
All of our items should be non-inventory items, but I am seeing that an inventory item can NOT be changed to non-inventory. What is the best solution for our currently categorized inventory items? Do we create all new items for them and categorize them as non-inventory? Is there anything I’m missing that would have a negative affect on our books by doing this? Since these item numbers were already used as inventory, what is the best solution for creating new numbers?
Thank you!
Solved! Go to Solution.
Thanks for your prompt reply, VanguardAccounting.
You'll encounter this error if the same name/number has been previously entered. Let's make sure to select the Include inactive option to see all the items that has the same name/number.
Before doing so, please make sure to update your QuickBooks to the latest release. Then, follow these steps:
I've got this sample screenshot for a visual reference:
If there's a duplicate item, you can edit it to change the name/number. The instructions are included in this article: Add, edit, and delete items.
Please let me know how things go after trying this out. I'm here to make sure your concern is resolved. Take care!
Thanks for checking in with us,@VanguardAccounting. I'm here to provide the steps you need to change Inventory item to non-inventory in QuickBooks.
Yes, you can create a new item and categorized it as non-inventory since you only have the option to change it as an Inventory Assembly-type item. To switch and use non-inventory items, duplicate the inventory items as non-inventory items and use the new set going forward. Then make it inactive or delete them.
To get started, we'll need to create a backup file to make sure that the data will be saved before creating a new item. I've got you an article for your reference: Create a Backup of your Company File.
For more details about this, you can refer to this article in managing your items: Add, edit, and delete items.
Once done, you can delete or make the item inactive. Just right-click and choose the option from there. I’ve attached an image below for your visual reference.
Upon sharing the steps above, I would suggest consulting your accountant. This way, you'll be guided on how to deal with the reconciled transactions that may affect your books. If you're not affiliated with one, you can visit our Intuit Find-A-ProAdvisor site to find certified professionals near you.
You might also want to check these links for additional reference in tracking your inventories effectively:
I'm looking forward to hearing from you again. If you have any other QuickBooks questions, please feel free to add a comment below. I'm always here to help. Have a great day!
Export your Item List data to XLS with an exporter tool and you may get it with the following template
Item Name | Item Type | Is Active | Sales Description | Purchase Description | Tax Code | Account/Income Account | Expense/COGS Account | Asset Account | Cost | Preferred Vendor | Price or % | Reorder Point | Manuf Part Number | Unit of Measure | Max |
Green Widget | Inventory Part | Y | Widget Sales | Widget Purchase | Tax | General Sales | General Cost of Goods Sold | Inventory Asset | 10 | ABC Vendor | 15 | 10 | 12345 | 30 | |
General Services | Service | Y | Services Sales | Services Purchase | Non | Specialized Sales | Specialized Expenses | 8 | DEF Vendor | 9 | |||||
General Parts | Non-inventory Part | Y | Part Sales | Part Purchases | Tax | General Sales | General Cost of Goods Sold | 7 | GHI Vendor | 8 | |||||
Misc Charge | Other Charge | Y | Misc Income | Misc Charges | Non | General Sales | General Cost of Goods Sold | General Expenses | 12 | GHI Vendor | 15 |
Modify the Item Type in bulk and import the data back. Utilize one of these migration tools for your convenience.
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
When I do this, it says my item number is already in use.
Thanks for your prompt reply, VanguardAccounting.
You'll encounter this error if the same name/number has been previously entered. Let's make sure to select the Include inactive option to see all the items that has the same name/number.
Before doing so, please make sure to update your QuickBooks to the latest release. Then, follow these steps:
I've got this sample screenshot for a visual reference:
If there's a duplicate item, you can edit it to change the name/number. The instructions are included in this article: Add, edit, and delete items.
Please let me know how things go after trying this out. I'm here to make sure your concern is resolved. Take care!
Thank you so much for your help! This is exactly what I needed to know!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here