Solved

Best way to convert non inventory to invetory

Forum|Forum|7 years ago
December 11, 2018
4 replies
0 views

Hi

I have listed my inventory part as non inventory part and i need to convert to inventory part

I understand i can change it manually to inventory part but is this the smartest way to go or is there any smarter way to go, meaning that will be more accurate accounting

I have inventory in the non inventory
I want to track inventory in inventory
i created group items on the non inventory items

Thanks

QuickBooks Enterprise Suite

Best answer by Rustler

do NOT do that

if you do the entire history of the file will change, as well as previous years financial reports

make the non inventory item inactive and create inventory

unless you are really sure you know what will happen to the financials, never change one item type to another in QB even if intuit allows it

RustlerAnswer

do NOT do that

if you do the entire history of the file will change, as well as previous years financial reports

make the non inventory item inactive and create inventory

unless you are really sure you know what will happen to the financials, never change one item type to another in QB even if intuit allows it

A

Anonymous

Hi Rustler! I have a similar situation at work. My boss asked me to change the non-inventory items to inventory items so we can have our financial reports more accurate. But my question are :
1. Which cost of goods sold will post into the profit and loss if we create new items with an initial quantity and we start selling them? The one we enter as cost into the purchasing information section of the item?
2. Which cost of goods sold will post into the profit and loss when we start buying the item? does it calculate an average cost including the initial cost entered in the information section or just the real purchase costs?

3. If QB uses the cost entered in the purchasing info to calculate the COGs of items entered with initial quantity, does QB change that cost once a purchase is registered?

I hope you can help me with my dilemma ;)

Thanks

V

Voiceness

I am experiencing a similar problem. When I create an estimate with new items, QB Desktop creates the items as NON inventory. This completely messes up my income from resale as it puts the cost of the item in the income account rather than COGS.

Chuck

HoneyLynn_G

Hello there, BonnieBorn and Voiceness.

Thank you for joining this thread. Allow me to step in and provide more details about converting non-inventory item to inventory item.

In QuickBooks, you can't convert an inventory item to a non-inventory item or vice versa. As a suggestion, you can deactivate the non-inventory item and create a new one with the correct type.

Here's how to deactivate an item:

Click Lists.
Choose Item List.
Highlight the item.
Right-click on your mouse, choose Make Item Inactive.

After that, follow this steps in adding an inventory item:

On the same screen, right-click on your mouse.
Choose New.
Choose Inventory Part.
Enter the necessary information.
Click OK to save.

For in-depth information, you can use this article as a reference: Add, edit, and delete items. After correcting your items' information, you can already select them when creating transactions which will update your reporting.

Let me know if you have follow up questions about the inventory feature in QuickBooks Desktop. I'd be around to help you more. Have a wonderful day ahead!

S

Shelbz0789

We need to switch non-inventory items to inventory items while keeping the same SKUs.

Can we do a bulk edit or export/import to change the SKUs for existing non-inventory parts?
Will this affect anything?

C

CharleneMaeF

Glad to have you here, Shelbz0789.

Allow me to share some information about changing non-inventory items to inventory.

In QuickBooks, it's possible to switch non-inventory items to inventory. However, doing so can affect your reporting because it will create a closing journal entry (JE) for the products that will be overwritten.

Instead of editing, we can either delete the non-inventory items or inactivate them if the items are associated with at least one transaction. Then, recreate the product with the correct type.

Here's how to delete the item:

From the Lists menu, select Item List.
Select the item you want to delete.
From the menu bar, select Edit and then click Delete Item.

You're unable to delete several items or the entire item list at once.

Here's how to inactivate the items:

Click Lists and then Item List.
Highlight the item.
Right-click on your mouse, choose Make Item Inactive.

Once done, you can follow these steps in adding an inventory item:

Go to the Lists menu and then select Item List.
On the Item List window, select Item and then click New.
Select the type of item you want to create.
Fill out the item fields.
Select Save.

To learn more about handling your items in QuickBooks, you can check out this article: Add, Edit, and Delete Items.

Additionally, I've included an article that'll help customize your sales reports. This helps you easily keep track of your data in QuickBooks: Customize Sales Reports in QuickBooks Desktop.

Also, once you customized the settings, select Memorize to save the report for future use.

You can click the Reply button if you have additional questions in managing your items. This way, we can assist you further.

C

Cannot connect bank feed

Can you use the same SKU number?

N

Nick_M

Hi there, Cannot connect bank feed.

Thanks for joining the Community. The SKU number can not be the same, each inventory item needs a unique SKU number. Below I'm attaching a few helpful articles highlight how to set up inventory with the SKU system and how to create a master SKU.

If you have any other questions or concerns, feel free to post below. Thank you for your time and have a nice afternoon.

L

lynweiss

If there are no quantities on Non-inventory parts, how would changing the type to Inventory Items affect the financials?

DivinaMercy_N

Let's get things taken care of, @lynweiss.

In QuickBooks Desktop (QBDT), changing the types from non-inventory to inventory may affect the cost of the item. This may also alter the file's financial history from the beginning.

You can create a new inventory item based on the details of the non-inventory. Then you can make the non-inventory inactive to remove it from the list. Allow me to guide you through the process.

To create a new inventory item:

Open your QBDT program and click the Lists tab.
Next, choose Item List.
At the bottom right part of the page, click the Item dropdown.
Then, select New.
From the Type field, choose Inventory part.
Fill in needed details and select OK.

Make non-inventory items inactivate:

Navigate to the Lists menu and select Item List.
Look for the Non-Inventory item.
Highlight the item and select the Item option below.
Then, choose Make Item Inactive.

See this article for more information: Add, edit, and delete items.

QBDT also gives you the ability to add custom fields for specific details about the products and services you sell. Once you create one, you can also add these item fields to sales forms.

Feel free to click the Reply button if you have additional questions about converting non-inventory items to inventory. This way, we can assist you further. Have a good one.

C

CBPP

Thank you for this detailed post of how to fix this! Here is my question: how can I do this efficiently with 800+ items? We use QBPOS, and for whatever reason, from the beginning, the items have all went into QBDT as non-inventory items, but they all actually SHOULD be inventory. Now that QBPOS is ending, I'm needing to switch to QBO, but all my inventory is "Non-inventory" but need it all to be inventory.
Please help!! Thank you!!!

Sign up

Login with SSO

Login to the community

Login with SSO