Changing Service types to Inventory?

dallasbrews · ‎January 16, 2019

I work at a brewery and we currently use QB Desktop Pro (and have for a couple years now) to handle all of our sales receipts to accounts ordering beer, and apparently the person that set this up input all of our available kegs as Service types. What we're wanting is a better way to track inventory on hand (currently just kegs of beer, no bottles or cans or anything else).... is there a better way to move those items over or is it even possible? And is it reflected on all the past transactions? I took a look just now and the option/dropdown appears to be gray-out so you can't click to change it.

We don't use QB for really much else... just receiving kegs into inventory, and then issuing sales receipts, and wanting the inventory to be reduced appropriately. Hopefully I've explained this well; I'm definitely not well versed in QB, and no one else here is, either (the joys of a small business). Any general advice on the topic would be appreciated!

qbteachmt · ‎January 16, 2019

You cannot Change, because that would result in Data recalculation and Chaos.

You Transition.

Edit the Service items to put a Z in the name, first character, if you will never use them again. Here is the assumption that these are Two Sided Service items, always listed on the Purchase, so everything flows to COGS from purchases.

Make the inventory item names you want. Set the price. Do Not put in Quantity on hand. Get all set up.

Take a physical inventory. Quantity and Cost on hand by Product being managed as Inventory.

Make one large Adjust Inventory screen, selecting all Products on hand, using the physical inventory info to Quantity and Cost what is on hand. Top left, pull from COGS; it is Too High, because these are still On Hand.

Now stop using the Service items. Make one Parent Level and name it Old Sales Items, slide them all under it, and make all of them Inactive. Now they stop showing in dropdowns for selection.

Now you are transitioned.

That's a general overview.

View solution in original post

Rose-A · ‎January 16, 2019

Thanks for checking in with us. dallasbrews.

Allow me to share some information about changing service types of the inventory items in QuickBooks Desktop.

Changing the service types of the inventory items isn't currently offered in QuickBooks Desktop. As a workaround, you can create new service items. Since this option is not yet available, I'd encourage you to submit feedback, which is sent to the Product Development Team for review when determining features to be added in updates.

Here's how:

Click Help at the top.
Select Send Feedback Online.
Then Product Suggestion.

You may find this article helpful:

If you need further assistance, you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours:

Go to: https://help.quickbooks.intuit.com/en_US/contact.
Choose your QuickBooks Product.
Select your QuickBooks version.
On the Contact Us page, click a topic.
Click on the Get Phone Number button to see the support number.

Should you need anything else, please let me know. I'll be around to help.

qbteachmt · ‎January 16, 2019

You cannot Change, because that would result in Data recalculation and Chaos.

You Transition.

Edit the Service items to put a Z in the name, first character, if you will never use them again. Here is the assumption that these are Two Sided Service items, always listed on the Purchase, so everything flows to COGS from purchases.

Make the inventory item names you want. Set the price. Do Not put in Quantity on hand. Get all set up.

Take a physical inventory. Quantity and Cost on hand by Product being managed as Inventory.

Make one large Adjust Inventory screen, selecting all Products on hand, using the physical inventory info to Quantity and Cost what is on hand. Top left, pull from COGS; it is Too High, because these are still On Hand.

Now stop using the Service items. Make one Parent Level and name it Old Sales Items, slide them all under it, and make all of them Inactive. Now they stop showing in dropdowns for selection.

Now you are transitioned.

That's a general overview.

dallasbrews · ‎January 17, 2019

I'm confused because you say as a workaround I can create new service items .. Service items is what we're trying to move away from

qbteachmt · ‎January 17, 2019

I stated:

Rename the Existing Service items, because they are tying up the Name you want to use for Real. Edit the existing item name and put a Z in First Position, such as:

Z-Bud

Z-Red Hook

Now you can make Inventory Items, which is what I stated, and name them what you Had, such as:

Bud

Red Hook.

Go ahead and reread the previous guidance.

Anonymous · ‎January 17, 2019

You should not change pre-existing items to (or from) a service or non-inventory type to an inventory type. To make the change simply make the current item 'inactive', then edit its name slightly (I add an 'x' in front) then create a new inventory type item using the prior name - so it will appear to the the same item to the users.

ScriptDawg · ‎September 10, 2019

Hi there,

I can see some community members have already given you some solutions, but have you considered checking out the QuickBooks App Store for some inventory management software to run alongside your QuickBooks for tracking finances.

For example, Katana is a smart manufacturing software which can automatically help you track your ingredients, finished products, and schedule production.

It’s built to be integrated with QBO and can synchronize stocks, but it still works independently, meaning you can use Katana for tracking your inventory and manufacturing costs, and QBDT for keeping your finances in check.

ibizconsult · ‎March 02, 2021

I unfortunately had to have a client change their inventory from service to Inventory Part. QB created an Inventory Adjustment entry that debited Inventory and credited Opening Balance Equity. Will this entry keep popping up each month?

JoesemM · ‎March 02, 2021

Thanks for joining this thread, @ibizconsult.

The Inventory Adjustment that QuickBooks created will only pop up when you edit an inventory, just like your client did. If you change another inventory item, you'll see the pop-up message again.

In case you want to create an inventory adjustment account. Here's how:

Click the Lists menu at the top, and then choose Chart of Accounts.
Select the Account ▼ dropdown, and then New.
From the Other Account Types ▼ dropdown, choose Cost of Goods Sold.
Name this account “Inventory Adjustments."
Fill out other info as needed, and then click Save and Close.

Once done, you can now adjust the product’s quantity, value, or both. Let me guide you how:

Click Inventory at the top, and then select Adjust Quantity/Value on Hand.
Choose the Adjustment Type ▼ drop-down, and then select Quantity, Total Value, or Quantity and Total Value.
Select the adjustment type option and then choose your adjustment account.
Enter the Adjustment Date.
Choose the Adjust Account ▼ drop-down, then select the adjustment account you set up.
Add Reference No. You can also assign a customer, job, or class.
Select Find & Select Items, and then choose the items you want to adjust. (If you have a lot, search for any product in the Find field.)
Click Add Selected items, and then add a new quantity or new value (or both) for each item.
Select Save and Close.

For more details, please check out this article: Adjust your inventory in QBDT.

Once done, you can run the Inventory Stock Status by Item report to check your product's quantity or the Inventory Valuation Summary report to know the product's value. This ensures your inventory is correct. Just go to the Reports menu, and then choose the said reports from the Inventory section.

In case you want to adjust the inventory for finished products, you can refer to this article for the detailed instructions: Adjust inventory for finished goods.

Let me know if you have more questions about inventory management or any concerns with QuickBooks. I'll be glad to help. Have a good one!

tjmjr · ‎April 21, 2022

Has anyone gotten a valuable answer and work around for this? I CANT edit the "service" item to anything more than a service...

Topics

Training

Community

Resources

Changing Service types to Inventory?