Migration to Advanced Inventory - QB Enterprise

@EricG1

To start tracking inventory by item you will first have to set up your items as Inventory Type.

You may want to use a new inventory asset account for tracking inventory by item vs. the original consolidated amounts.

Then you would post an Inventory Adjustment.

• Go to: Inventory > Adjust Quantity/Value on Hand
• Adjustment Type: Quantity and Total Value
• Adjustment Account: Choose the inventory asset account containing the consolidated amounts.
• Fill the list of items, enter the actual count under New Quantity, and the total value under New Value.

This will move the posted value from the inventory asset account to the item and its related asset account.

If you leave the existing inventory asset account to use also for the items, this adjustment will not affect the asset value of the account.

Let me know if this helps or if it needs more clarity.

Thanks for checking in with us, EricG1.

We can follow the recommended solutions provided by OnTrack Team. Also, we can move one or many items from one category to another. Just follow the steps below:

1. Go to Lists and select Category List.
2. Select the category.
3. Checkmark all the items you want from the category to be moved.
4. Click Batch Actions below the list, and then choose Move to a different category.
5. Choose the new category/sub-category where you want the items to be moved.
6. When you're done, press Save.
7. You'll be asked to confirm the items you moved. Press OK.

Once done, we can onboard multiple items and categories using the Add/Edit Multiple List Entries screen. Here's how:

1. Go to Lists.
2. Select Add/Edit Multiple List Entries. You can also select Lists, then CategoryList, then Manage Categories, then Add/Edit multiple categories and items
3. Click List, then the list you want to work with for Item Categories.
   • Inventory Parts
   • Service Items
   • Non-Inventory Parts
   • Inventory Assemblies
4. To add entries in the category column, type in the first empty row at the end of the list. You can also copy (Ctrl+C) data from Excel and paste (Ctrl+V) it into the Add/Edit Multiple List Entries window.
5. To edit entries in the category column, select any field and begin making changes.
6. To copy, One field to the other records, highlight the field, right click then select Copy Down. Any data already in the fields will be overwritten. Then, copy a row, right-click the row and select Duplicate Row. The record is copied into the next row and starts with the word "DUP."
7. Press Save Changes.

To learn more about categorizing your inventory items in QuickBooks Desktop Enterprise, check out this article: Use item categories in QuickBooks Desktop Enterprise. Also, I've added this article for more details about tracking inventory stored at different sites or locations: Set up Advanced Inventory.

Please fill me in if there's anything else I can do to help you manage your inventory items. You can click the reply button below to add your response. Keep safe always!